How to test a synapse link service from a powershell script?

Question

How to test a synapse link service from a powershell script?

Jean-Francois Roger ADM 0

0 comments

2 answers

Your answer

Answer 1

Jean-Francois Roger ADM 0

Thank you for your reply. The Get cmdlet will retrieve the link service meta data. What I am looking at is to test, to validate, the link service, make sure the connection can be established, equivalent to the TEST button in the synapse portal when you edit the link service.

Bhargava-MSFT 31,361 Reputation points Microsoft Employee Moderator

2024-04-26T20:23:19.63+00:00

Hello Jean-Francois Roger ADM,

I don't see a direct command to test and validate the linked service, however this below blog post explins the process involves making REST API calls to test the connectivity of each linked service.

https://key2consulting.com/how-to-test-azure-data-factory-linked-services-using-powershell/

https://stackoverflow.com/questions/68017714/how-to-automate-for-checking-the-connectivity-of-azure-data-factory-linked-servi

I hope this helps.

Answer 2

Bhargava-MSFT 31,361 Microsoft Employee Moderator

Hello Jean-Francois Roger ADM,

Welcome to the Microsoft Q&A forum.

Please follow the below blog post by Brad Harris

https://key2consulting.com/how-to-test-azure-data-factory-linked-services-using-powershell/

Here, instead of Get-AzDataFactoryV2LinkedService, you can use

Get-AzSynapseLinkedService in the script to get the information about synapse linked services.

https://learn.microsoft.com/en-us/powershell/module/az.synapse/get-azsynapselinkedservice?view=azps-11.5.0

I hope this answers your question.

0 comments

Share via

How to test a synapse link service from a powershell script?

2 answers

Your answer