This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 32%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
In Synapse, I'm Able to query the data from the data lake file thru openrowset query but when I'm creating the external table on top of any file & try to query it, it's giving me below error
External table 'dbo.table1' is not accessible because location does not exist or it is used by another process.
I have checked my synapse workspace have contributor role on storage account, my Entra Id also have contributor access on same storage account.
Regards
Sanjeev
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 50%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
@Sanjeev Kumar Just checking in to see if the below answer provided by @Nandan Hegde helped.
If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please refer on the below email trail :
https://stackoverflow.com/questions/70107560/error-while-trying-to-query-external-tables-in-serverless-sql-pools
1st validate the datasource credential and eventually go across other aspects
Sanjeev Kumar Following up to see if the above answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.