Skip to main content

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

Hi Ignacio

Please use the examples from this guide

Connect to CSV data sources

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!


@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 ;-)


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)


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

The setup mandatory parameters are:

  • Name: TXT Files in FileShare
  • Authentication Schema: AccessKey
  • Azure Authentication/Access key: The key of the storage account
  • Azure Authentication/Azure storage account: the neme of the storage account
  • Misc/Include files: CSV,TXT,TAB
  • Connection/URI: azurefile://datafiles

Reply