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

APPLIES TO: Azure Data Factory Azure Synapse Analytics

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

• 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.

For more troubleshooting help, try these resources:

• Connector troubleshooting guide
• Stack Overflow forum for Data Factory