How to Connect to Azure table Storage with Managed Identity. ( Is there any work around to connect to Azure Table Storage with out SAS URL or Account key)

Matiwos Gebremichael (MINDTREE LIMITED) 20 Reputation points Microsoft Vendor
2024-07-17T21:29:51.05+00:00

Hi Everyone

Is there any method to connect to Azure Storage table in ADF with managed Identity.

With out using SAS URL or Account Key.

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,470 questions
0 comments No comments
{count} votes

Accepted answer
  1. hossein jalilian 6,265 Reputation points
    2024-07-17T23:59:01.69+00:00

    Thanks for posting your question in the Microsoft Q&A forum.

    Unfortunately, there is currently no direct method to connect to Azure Table Storage in Azure Data Factory using managed identity authentication.

    There are a few alternative approaches you could consider:

    • You can set up an OData service to connect to Azure Table Storage using a service principal.
    • If your data structure allows, you might consider using Azure Blob or Queue Storage instead of Table Storage, as these services do support managed identity authentication in ADF
    • You could create an intermediary service using Azure Functions or Logic Apps that connects to Table Storage using managed identity, and then have ADF interact with this service.

    Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful


0 additional answers

Sort by: Most helpful

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.