Search code examples
azureazure-data-factoryazure-table-storagelinked-service

Authenticate Azure Table storage from ADF using Service Principle or Managed Identity


I am trying to load data from Azure Table Storage to ADLS Gen2 parquet files using a copy data activity in ADF. While creating the linked service for azure table storage, the authentication method shows below 2 options alone.

  1. Account Key
  2. SAS URI

Is there any other option to connect to azure table storage using service principle or managed identity?


Solution

  • Azure table storage dataset in adf supports only account key and sas uri for now. Alternate option is odata service can be used to connect to azure table storage using service principal.