Hello, Quick question about the target-postgres transferwise: My schema is in camelcase, but in the end database created all the columns are in lower case. Is there a way to keep camel casing or have the snake case?

Hi Charley 👋 The column rename behaviour is hard coded in the wise variant of

target-postgres

likely because of Postgres' default to lowercase for field names:

Identifiers (including column names) that are not double-quoted are folded to lowercase in PostgreSQL. Column names that were created with double-quotes and thereby retained uppercase letters (and/or other syntax violations) have to be double-quoted for the rest of their life.

We are working on functionality that would allow you to transform field names 'in-flight' between the tap and target (providing an opportunity to convert from camel to snake case). Otherwise, if you would prefer to preserve the case using double-quotes, I recommend raising an issue or PR to the wise variant in Github with your implementation, or checking out the Datamill variant in case it has a different behaviour 🙂

Hello Ken, Thanks for you quick answer! Datamill variant does not support, as I recall, the jsonb format which I am using extensively. I look forward for your new functionnality. Charley