To Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS)

Question

I'm not able to Read Delta tables from ADLS Gen2 from Azure Analysis Services (AAS), even though the MS Azure page here https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#tab1400a has given an option to read delta table data from ADLS Gen 2 through the option of Azure Blob storage connector

Answer 1

Hi Aravind K Pachaiyappan - Thanks for reaching out.

Based on interoperability, Data Lake Storage Gen2 APIs, NFS 3.0, and Blob APIs can operate on the same data with certain limitations.

https://learn.microsoft.com/en-us/azure/storage/blobs/data-lake-storage-known-issues#blob-storage-apis

So I believe, the same principle if applied and the you can leverage the blob connector to work with ADLS Gen2 resource.

Can you please share what is error / exception message, that you received post configuration. This might help in further investigation/troubleshooting or deciding the next action plan.

Answer 2

Hello Aravind K Pachaiyappan,

Greetings! Welcome to Microsoft Q&A Platform.I understand that you are facing issue in reading delta table data in ADLS Gen 2 from Azure Analysis Services (AAS). Please review the below suggestions to check if you can perform the same and please help us with more details in error encountered to investigate further on the issue.

You can try using “Multi-Protocol Access” on Azure Data Lake Storage Gen2 now AAS can use the Blob API to access files in ADLSg2. This unlocks the entire ecosystem of tools, applications, and services, as well as all Blob storage features to accounts that have a hierarchical namespace refer this article for more details.

When setting up the connection in AAS, use the correct connection string for ADLSg2. The connection string should include the account name, container name, and hierarchical namespace path. Make sure you’ve configured it correctly.

Ensure that your Azure Analysis Services (AAS) service principal or managed identity has the necessary permissions to read data from ADLS Gen2. You’ll need at least the “Storage Blob Data Contributor” role on the ADLS account. Also check using the access key of the storage account and the delta-lake-reader API.

Hope this suggestion helps! please let us know if you have any further queries. I’m happy to assist you further.

---

Please "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.