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
Solved
Load CSV files from Azure Blob Storage
+1Best answer by Syed Yousuf
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
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
1 person likes this
+1Excellent! It worked!
+4Can 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 ;-)
+7Hi
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)
+4Thanks
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
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
