Access Azure Storage account via Synapse through Managed Identity

Nandan Hegde 32,106 Reputation points MVP
2020-12-31T09:36:57.91+00:00

I am trying to connect to Azure Blob storage via Azure synapse through Managed Identity based on the below set of steps:

1) Assigned an Identity to the Server

2) Gave access to the Server on Blob storage as contributor

3) Executed the below queries

    Create Master Key  

    CREATE DATABASE SCOPED CREDENTIAL MSI WITH IDENTITY = 'Managed Service Identity';  


        CREATE EXTERNAL DATA SOURCE [BlobStorage] WITH  
    (    
        TYPE = hadoop,  

    LOCATION = 'abfss://<<ContainerNm>>@<<StorageAccountNm>>.dfs.core.windows.net',  
    CREDENTIAL = MSI  
    )  

4) Created External File Format

When I am trying to create the External table, I am getting the below error:

External file access failed due to internal error: 'Error occurred while accessing HDFS: Java exception raised on call to HdfsBridge_IsDirExist. Java exception message: HdfsBridge::isDirExist - Unexpected error encountered checking whether directory exists or not: AbfsRestOperationException: Operation failed: "This endpoint does not support BlobStorageEvents or SoftDelete. Please disable these account features if you would like to use this endpoint.", 409, HEAD, https://<<>>.dfs.core.windows.net/<<>>//?upn=false&action=getAccessControl&timeout=90'

So what am I missing out?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
4,903 questions
{count} vote

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.