Automated Way to Identify the Dependencies on an Integration Runtime in Synapse

Problem Statement :

In my previous blog Automated Way to Identify the Dependencies on an Integration Runtime in an Azure Data Factory, we identified ways to get dependencies on a Integration Runtime within an Azure data Factory. Similarly for Synapse ;

As of Dec 17,2022 ; One can identify the dependencies on a Integration Runtime in Synapse by logging in to Synapse via Portal and accessing the Integration Runtime under Manage Section.

And Clicking the Related number values to get the Dependencies details as seen below :

A) Linked Service on Integration Runtime

So how can one get the related / dependent objects on an Integration Runtime in Synapse in an automated way.

Solution :

1. Open Powershell in admin mode and import the Azure SDK modules by executing the below commands :

Import-Module Az.Accounts Import-Module Az.Synapse

2. Install the custom module by executing the below command

Install-Module -Name AzSynapseIntegrationRuntimeDependencies

3. Now the environment is set for us to execute the commands to fetch the pipeline details .

To get the list of all Integration Runtime in Synapse and its corresponding dependent objects, execute the below command: Get-AzSynapseIntegrationRuntimeDependencies -WorkspaceName “<<WorkspaceName>>”

To get the details of a specific Integration Runtime in Synapse and its corresponding dependent objects, execute the below command: Get-AzSynapseIntegrationRuntimeDependencies -WorkspaceName “<<WorkspaceName>>” -IntegrationRuntimeName“<<IntegrationRuntimeName>>”

Output Results :

1. Overall Synapse output

2. Specific Integration Runtime output

This would avoid manually identifying the dependent objects of an Integration Runtime in Synapse.