Connector Improvement: Case-insensitive source column name ingestion
Request: provide a way to specify how to handle column names that match but are not the same case (e.g. one source file has a "Date" column and another instead has "DATE").
Currently Fivetran is able to detect that the two columns are the same, but it ignores/nulls out data from the "duplicate" column—there's no way to configure it to combine/treat them as a single column. There's also no way to keep the two "duplicates" as separate columns because even though "Date" is distinct from "DATE" in Fivetran, this is not the case in some case-insensitive destinations such as Databricks Delta. So this request is to provide other options besides just ignoring data from one of them altogether.
Please sign in to leave a comment.
Comments
0 comments