Solved

Load CSV files from Azure Blob Storage

Hi everyone,

I am adding a new data source to ODX, this connection has to load 6 cvs files from azure storage, could you help me to create the connection?

Thanks

Ignacio

icon

Best answer by Syed Yousuf 3 March 2023, 20:04

Userlevel 3

Hi Ignacio

Please use the examples from this guide

For Blob storage containers, specify abfss:// or azureblob:// in URI

If your file is stored in a FileShare instead of a container, you can use the azurefile:// option

Excellent! It worked!

Userlevel 3

@ignacio I’m triying to setup a data source o connect to an Azure FileShare that it’s using “Storage Account Key” not an Active Directory to connect.

Can you give me the details to get it?

I’ve with several options and I’m not be able to do that.

Thanks in advance

Gracias ;-)

Userlevel 5

Hi @rvgfox ,

there are a couple of different keys that can be involved when accessing an Azure Storage account:

Access keys: found in Azure Portal for your storage account under ‘Access Keys’
Shared access keys: found in Azure Portal for your storage account under ‘Shared access signature’

If you look at the example linked above you would use the azurefile:// URI in combination with a shared access key.

For an Azure Files share I would expect you could also reach it through SMB or NFS though (similar to an on-prem situation)

Userlevel 3

Thanks @rory.smith I’ve solve it with:

The setup mandatory parameters are:

Sign up