Summary
Syncing from MySQL to PostgreSQL is creating columns with case sensitivity as camelCase. User wants to know if it’s possible to create tables and columns as case insensitive.
Question
Hi, Anyone knows how to NOT do the following behaviour. Whan I am syncing from MySQl to PG, it is creating any columns names as camelCase are created with case sensitivity as “camelCase”. This looks like a new behaviour. Is it possible to turn this off and create tables and columns as case insensitive?
Thanks in Advance
This topic has been created from a Slack thread to give it more visibility.
It will be on Read-Only mode here. Click here if you want
to access the original thread.
Join the conversation on Slack
["case-sensitivity", "syncing", "mysql", "postgresql", "camelcase", "case-insensitive"]
The Postgres <Postgres | Airbyte Documentation docs> state:
> INFO: Airbyte Postgres destination will create raw tables and schemas using the Unquoted identifiers by replacing any special characters with an underscore. All final tables and their corresponding columns are created using Quoted identifiers preserving the case sensitivity. Special characters in final tables are replaced with underscores.
So it would seem this is by design. You could model off the raw tables yourself, or open a feature request related to making this a UI option of some type on the destination config.