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

Question

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

Answer 1

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.

Answer 2

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.