Not able to read data from Delta External table in catalog

bohemiaRDX
New Contributor II

bohemiaRDX_0-1738733317354.png

spark.conf.set(
    "fs.azure.account.key.sa02flexflowinpp01prod.dfs.core.windows.net",
    dbutils.secrets.get(scope="OpenScope", key="sa02StorageAccessKey")
 
I created an external table using this configuration I am able to query the data only when I run the above configuration. Also I am not able to see the sample data in catalog
    )

Ayushi_Suthar
Databricks Employee
Databricks Employee

Hi @bohemiaRDX , Greetings! 

Generally, this error would occur if the path is not added as an external location with storage credentials. Here the cluster could be trying to access the storage which doesn’t have UC storage credentials set nor any non UC access mechanisms like access keys/service principal setup and eventually failing with the given error.

What’s Next:

Leave a like if this helps, followups are appreciated.
Kudos,

Ayushi

View solution in original post