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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!