Skip to main content

Community

Connector Improvement: Postgres - do not lower case column and table names

Answered

Please sign in to leave a comment.

Comments

1 comment

  • Official comment

    Hi,

    Thanks for your feedback. Our naming convention policy does lowercase all schema and column names automatically, you can find details of this in our documentation here: https://fivetran.com/docs/getting-started/core-concepts#namingconventions

    Your feedback on keeping the original casings and string values is something we have certainly heard from other customers. I will be sure to take this feedback to our teams to investigate how to keep original casings as much as possible.

    One reason this is a challenging problem is that different destinations often have different naming policies! For example, Snowflake is fully case sensitive, however Redshift is case insensitive, so we would need to design a solution that works across all destinations.

    Thank you for sharing this, as this information helps us understand the use cases our users have. While this improvement is not currently planned, I will share this with the team as a possible improvement for our users.

Didn’t find what you need?

Contact support