Blog Post

Azure Synapse Analytics Blog
1 MIN READ

Storage configuration for external table is not accessible while query on Serverless

Liliam_C_Leme's avatar
Liliam_C_Leme
Icon for Microsoft rankMicrosoft
Dec 29, 2020
  Following this lab: Lab: Serverless Synapse - From Spark to SQL On Demand - Microsoft Tech Community You may experience this message:  Failed to execute the query because content of directory...
Updated Sep 15, 2021
Version 6.0
Synapse Administration
synapse spark
Synapse SQL
Shane_Blake's avatar
Shane_Blake
Copper Contributor
Feb 04, 2021

Another option is to set up the data source for the external table to use the Synapse Managed Identity. This way you can then secure the external table using GRANT statements on the external table and have Synapse request the data from the Data Lake.