Ask Your Question

What is the method for using Service Principal to access ADL2 in Synapse?

asked 2022-01-16 11:00:00 +0000

nofretete gravatar image

edit retag flag offensive close merge delete

1 Answer

Sort by ยป oldest newest most voted

answered 2022-05-21 12:00:00 +0000

lakamha gravatar image

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.
edit flag offensive delete link more

Your Answer

Please start posting anonymously - your entry will be published after you log in or create a new account. This space is reserved only for answers. If you would like to engage in a discussion, please instead post a comment under the question or an answer that you would like to discuss

Add Answer

Question Tools


Asked: 2022-01-16 11:00:00 +0000

Seen: 23 times

Last updated: May 21 '22