Managed Identity link between ADLSGen2 and Synapse External datasource

Nandan Hegde 30,871 Reputation points MVP
2020-07-02T07:08:42.27+00:00

Hello Team,
I need to create an external data source to ADLSGen2 in Azure synapse.
The methods through which we can create is

  1. Access key
  2. SAS
    Is there any way I can create an external data source in synapse via Managed identity functionality to ADLS Gen2
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,631 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. PRADEEPCHEEKATLA-MSFT 84,531 Reputation points Microsoft Employee
    2020-07-06T07:19:19.157+00:00

    @NandanHegde-7720,

    Data source can have credential that enables external tables to access only the files on Azure storage using SAS token or workspace Managed Identity - For examples, see the Develop storage files storage access control article.

    External data sources without credential in SQL pool can also use callers Azure AD identity to access files on storage. External data source with credential use identity specified in credential to access files.

    In SQL pool, database scoped credential can specify custom application identity, workspace Managed Identity, or SAK key.

    In SQL on-demand, database scoped credential can specify caller's Azure AD identity, workspace Managed Identity, or SAS key.

    Reference: Create and query external tables from a file in Azure Data Lake

    Hope this helps. Do let us know if you any further queries.

    Do click on "Accept Answer" and Upvote on the post that helps you, this can be beneficial to other community members.