Forum Discussion
Nick34
Nov 15, 2022Copper Contributor
Access data lake gen2 through Synapse Serverless external tables by technical user
Hi all, I want to grant access on Azure Synapse Analytics Serverless SQL Pool External Tables to some AAD users. The source of an external table is an Azure data lake gen2 parquet file. I’m not t...
ericpasztor
Microsoft
Dec 20, 2022Nick34, you should be able to accomplish this by creating database-scoped permissions for each AAD user in your serverless SQL pool database. The "Configure Database-scoped permissions" steps here show how to create an AAD login in the master database and assign a database role within a specific database. The db_reader role could be used to grant read access to all external tables within a serverless SQL pool, or you could grant the SELECT permission on a table-by-table basis.
Access to the underlying Data Lake Storage files would be provided for all users by a single External Data Source definition and credential (SAS token or workspace Managed Identity), as shown here.