Query Azure Data Lake from Synapse SQL Pools using SAS credentials

Goal

Query an Azure Data Lake container from Synapse SQL Pools using Shared Access Signature (SAS) authentication.

Create the credential

CREATE CREDENTIAL [https://DATALAKE_ACCOUNT_NAME.dfs.core.windows.net/CONTAINER]
WITH
IDENTITY='SHARED ACCESS SIGNATURE', 
SECRET = '?sv=2020-08-04&ss=bfqt&srt=sco&sp=rwdlacupx&se=2022-12-21T21:35:50Z&st=2021-12-21T13:35:50Z&spr=https&sig=************************************'

Replace:

• DATALAKE_ACCOUNT_NAME with your storage account name
• CONTAINER with your container name
• SECRET value with your SAS token (generate from Azure Portal → Storage Account → Shared access signature)

The credential URL must match the exact Data Lake path you’ll query in your OPENROWSET or external table definitions.