cancel
Showing results for 
Search instead for 
Did you mean: 
Machine Learning
Dive into the world of machine learning on the Databricks platform. Explore discussions on algorithms, model training, deployment, and more. Connect with ML enthusiasts and experts.
cancel
Showing results for 
Search instead for 
Did you mean: 

Error "Invalid configuration value detected for fs.azure.account.key" when listing files stored in an Azure Storage account using "dbutils.fs.ls"

Mado
Valued Contributor II

I get the following error when getting a list of files stored in an Azure Storage account using "dbutils.fs.ls" command in Databrciks.

Failure to initialize configuration for storage account AAAAA.dfs.core.windows.net: Invalid configuration value detected for fs.azure.account.keyInvalid configuration value detected for fs.azure.account.key

0 

Databricks Workspace:

  • Unity catalog is enabled.
  • There is a catalog named "Exploration"
  • Service principal has "ALL PRIVILEGES" grant on this catalog

1 

Azure storage account: ADLS Gen2

Service principal has Read/Write/Execute access to the root folder. Also, it has the same access to the sub-folder "test".

2 

What should I do to be able to get a list of files?

Notes:

  • I am able to create sub-folders in the Exploration storage location.
  • Also, I can upload files into the storage location.
  •   I can get the list of files in the "raw" container using dbutils:

6 

Configurations to access the Azure data lake storage are done by another company. I think they have used "External Locations" in Databricks.

2 REPLIES 2

Anonymous
Not applicable

Hi @Mohammad Saber​ 

Great to meet you, and thanks for your question!

Let's see if your peers in the community have an answer to your question. Thanks.

Mado
Valued Contributor II

I solved the issue by creating an External Location in Databricks workspace.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group