Question
How do I address the "Duplicate custom field names" warnings on the dashboard?
Environment
Connector: Jira
Answer
- Rename one of the duplicate field in Jira to be unique so that Fivetran is able to write them to the warehouse ( Example :
Actual Result
could be renamed asActual Result_1
). After renaming the duplicate field, you would need to run a historical resync on the connector in order to back-fill the data for that, particularly renamed column. - Delete one of the duplicate field in Jira if it is not needed.
Please make sure to dismiss the warning once you are done with the above actions
Cause
This happens when there is more than one column with the same name. These columns are read as duplicates as a result of the Fivetran naming conventions For example :Actual Result
and Actual result
will be read as actual_result
after the naming conventions and hence we will be skipping these fields from sync.