CODEWITHSUNDEEP
azure-table-storageazure-data-factory
Shaswat Rungta
Shaswat Rungta

Reputation: 3805

Duplicate column name in table storage source in Azure data factory

Setup:
1. I have a Azure table storage table with the following schema

PartitionKey
RowKey
TimeStamp [Generated By Azure table storage automatically]
DataField1
TimeStamp [Field added by code]

I have added this table as a source in my data factory.

Issue
When i try to publish this data set, it gives me an error saying The name 'TIMESTAMP' is duplicated in 2 Schema

I tried removing the code generated TimeStamp in the structure of data. But the error still persists.

Please do suggest any way to import this dataset.

Upvotes: 0

Views: 2779

Answers (1)

Li Liu
Li Liu

Reputation: 61

Did you use the ADF visual authoring tool? Just checking the duplicated column and clicking delete button should work.

In you case you said you already remove the column but the error still exists, I suspect that you import the schema again before publishing somehow, thus the schema structure change is reverted. If that's not the case, please provide more details.

Upvotes: 1

Related Questions