Error: External table 'RetailDB.dbo.Customer' is not accessible because content of directory cannot be listed.

Darrick B 0 Reputation points
2024-06-14T19:14:00.3033333+00:00

Hi,

I'm a learning path to receive Azure Data Engineer Associate cert. One of the modules asks that you download the customers.csv from github. I've since downloaded but receiving the following error after creating lake db and associated folders:

"External table 'RetailDB.dbo.Customer' is not accessible because content of directory cannot be listed."

Although, I am the storage blob owner, I did assign role as storage blob data contributor as well to try avoiding the error to no avail.

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,916 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Darrick B 0 Reputation points
    2024-06-14T21:26:33.71+00:00

    Inherited database default path was incorrect and needed to be updated. Problem is resolved and no longer receiving the error

    0 comments No comments

  2. Nandan Hegde 32,336 Reputation points MVP
    2024-06-17T03:26:32.43+00:00

    As the OP cannot accept his own answer, posting the resolution again :

    Darrick :

    Inherited database default path was incorrect and needed to be updated. Problem is resolved and no longer receiving the error

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.