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

Jean-Francois Roger ADM 0 Reputation points
2024-04-18T19:05:59.8166667+00:00

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

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,472 questions
PowerShell
PowerShell
A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
2,161 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 27,651 Reputation points Microsoft Employee
    2024-04-18T19:23:11.3+00:00

    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 No comments

  2. Jean-Francois Roger ADM 0 Reputation points
    2024-04-24T23:16:14.6566667+00:00

    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.