Error accessing Tables in Lake Database

Wajih Arfaoui 70 Reputation points
2024-03-26T12:38:05.8033333+00:00

Hello,

I used Azure Synapse Link in order to get Dataverse Tables, now i can see them in the lake database but when i try to query one of the tables using the serverless SQL pool I get this error : External table 'dataverse_letecproduct_3338efaf29c245db98b4da54098dec.dbo.bd_article' is not accessible because content of directory cannot be listed. even though I added my Synapse workspace as Storage Blob Data Contributor for the container where these tables are saved. Screenshot 2024-03-26 at 13.36.33

Thank you

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,370 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Vinodh247-1375 11,126 Reputation points
    2024-03-26T13:48:04.5133333+00:00

    Hi Wajih Arfaoui,

    Thanks for reaching out to Microsoft Q&A.

    it plainly looks like a permission issue. Are you sure all the permissions are already there for synapse to access the external table file location?

    Are you using SPN or MI to read the external table? In addition, to Storage Blob Data Contributor provide Storage Blob Data reader role as well.

    What about the firewall? are there any blocks.

    Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.