Troubleshoot the Azure Table Storage connector in Azure Data Factory and Azure Synapse

APPLIES TO: Azure Data Factory Azure Synapse Analytics

Tip

Try out Data Factory in Microsoft Fabric, an all-in-one analytics solution for enterprises. Microsoft Fabric covers everything from data movement to data science, real-time analytics, business intelligence, and reporting. Learn how to start a new trial for free!

This article provides suggestions to troubleshoot common problems with the Azure Table Storage connector in Azure Data Factory and Azure Synapse.

Error code: AzureTableDuplicateColumnsFromSource

• Message: Duplicate columns with same name '%name;' are detected from source. This is NOT supported by Azure Table Storage sink.

• Cause: Duplicated source columns might occur for one of the following reasons:

  • You're using the database as a source and applied table joins.
  • You have unstructured CSV files with duplicated column names in the header row.

• Recommendation: Double-check and fix the source columns, as necessary.

Related content

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Data Factory blog
• Data Factory feature requests
• Azure videos
• Microsoft Q&A page
• Stack Overflow forum for Data Factory
• Twitter information about Data Factory