Connector Improvement: SFTP conenctor syncs file with case sensitivity
AnsweredThe SFTP connector treats column names as case-sensitive (e.g., Id and ID are not treated as the same). If the source file contains columns that differ only by case, the connector may create duplicate columns in the schema.
When the primary key is defined using a different case than the column header in the file, the connector fails to match it.
- Allow columns that are similar in terms of case sensitivity to exist at the same target table instead of not ignoring the duplicate column.
- Force the connector to error out in case of duplicate columns before sync the data because of the schema change instead of forcing sync the data to snowflake.
-
Official comment
Hi Monisha, thanks for filing this request! Are the duplicate columns in the same or separate files?
Best,
Parmeet
Please sign in to leave a comment.
Comments
1 comment