cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

#HelpPost for Azure Blob to Databricks connection.

menonshiji
New Contributor

Hi,

There is a set of .csv/.txt files in the storage container ie Azure Blob Storage/ Azure Storage Gen 2. I would like to ingest the files to Databricks. Dataset,LinkedServices was created on both ends. Also an all purpose cluster was created in Bricks. Can we ingest the data using ETL Tool ADF from Blob to Databricks?

I tried creating and debugging the pipeline, but failed with the following message in the pipeline - "ErrorCode=AzureDatabricksCommandError,Hit an error when running the command in Azure Databricks. Error details: shaded.databricks.org.apache.hadoop.fs.azure.AzureException: shaded.databricks.org.apache.hadoop.fs.azure.AzureException: Unable to access container csv-file-storage in account storageaccountfordev.blob.core.windows.net using anonymous credentials, and no credentials found for them in the configuration.
Caused by: shaded.databricks.org.apache.hadoop.fs.azure.AzureException: Unable to access container csv-file-storage in account storageaccountfordev.blob.core.windows.net using anonymous credentials, and no credentials found for them in the configuration.
Caused by: hadoop_azure_shaded.com.microsoft.azure.storage.StorageException: Public access is not permitted on this storage account.. "

I have a limited experience with Databricks. Can anyone give me some insights about this? Basically i wanted to know how the ADF works. 

Thanks,

1 REPLY 1

cgrant
Databricks Employee
Databricks Employee

These errors occur when you are not authenticated / properly authorized to access the storage account. Ensure that you've set proper storage credential configurations, and that those credentials have proper access. Documentation here.

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