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 the storage account name
• CONTAINER with the container name
• SECRET value with the SAS token (generate from Azure Portal → Storage Account → Shared access signature)

The credential URL must match the exact Data Lake path used in the OPENROWSET or external table definitions.