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)

Question

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.

Answer 1

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