Hi all We have an issue with the data ingestion process it s | Advice-data-transformation

Hi all! We have an issue with the data ingestion process, it seems the normalization process lower case most (but not all) of the column names. Doesn't matter what source it was invoked from, the behaviour is the same. I'd like to keep the column name the same, but I can't find any configuration option for it. If I check the _airbyte__raw table, I see the column name is unchanged. Also, if I check the Replication page and open the particular source table, I see the destination name match the original name, but for some reason the column name is modified when is changed to tabular format. Any idea how I can fix that?

Augustin Lafanechere (Airbyte)

05/31/2022, 7:02 AM

Hi @Ohad, our normalization process sanitizes / normalizes table name to maximize compatibility with various data warehouses. It's not possible to change this at the moment. The only workaround I'd suggest is to create a custom dbt transformation to replace the normalization and define your own table names. If you need additional support please post on our forum.

Ohad

05/31/2022, 8:45 PM

Thank you @Augustin Lafanechere (Airbyte) for clarifying this!

View count: 1

Join thread in Slack