Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

The method for using Service Principal to access ADL2 in Synapse can be summarized in the following steps:

  1. Create a Service Principal in Azure Active Directory (AAD) and assign it appropriate permissions to access ADL2 storage account.
  2. Create an Azure Key Vault and store the Service Principal credentials (client ID, client secret) as secrets.
  3. Create a Synapse workspace or open an existing workspace, and go to the "Linked Services" tab.
  4. Click on the "New" button and select "Azure Data Lake Storage Gen2" as the linked service type.
  5. In the "Azure Data Lake Storage Gen2" linked service properties, enter the ADL2 storage account name, and select "Service Principal" as the authentication type.
  6. Enter the Service Principal's client ID, client secret, and tenant ID, and select the Azure Key Vault that contains the Service Principal credentials.
  7. Test the connection to verify that the Service Principal can access the ADL2 storage account.
  8. Use the linked service in Synapse pipelines or notebooks to access and process data stored in ADL2.