Do Not Drop Duplicate Column
Which application or service?: Hybrid
What type of connector? (SaaS, Database, File or Event Source): Database (but really any that perform renaming)
Additional details: When using Fivetran Naming and a duplicate column name is encountered due to renaming, do not drop one if the columns and lose the data. Instead, rename one of the columns by adding a character like a '1' or prompt the user to resolve the duplicate name issue.
Example where the special character is replaced with an underscore causing a duplicate column name:
a$b -> a_b
a#b -> a_b
Please sign in to leave a comment.
Comments
0 comments