Skip to main content
Docs
Feature Requests Onboarding Trust Center Status Page

Community

Connector Improvement: No prefix to transfer data from a database to a Postgres destination

Answered
Louis Monier User

All is in the title. I need to transfer a schema_name.table_name from a Postgres source db to a Postgres destination db without having a prefix in the schema_name in the destination. 

Is that possible ? 


Thank you in advance, 

Louis

Please sign in to leave a comment.

Comments

3 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Louis,

    Thanks for your post in our feature requests portal!

    I don't believe this is currently possible in the product, since the creation of schema names and table names is automatic and handled by the Fivetran managed service. We could change the product of course to not include schema names, but that would be a major change for all of our customers, as we want to have one, default choice within Fivetran.

    Could you share more details about your use case here? Why is having the schema name prefix causing an issue for your team? Would it be possible to create a view off the table Fivetran is writing to match the exact string you are looking for?

  • Louis Monier User

    Hi Kevin, 


    Thank you for your answer. Metabase is our BI tool. Switching between databases require to keep the exact same schema/table structure, otherwise the filters of the dashboards break. Hence my feature request. 
    We finally opted for another solution to avoid having this problematic transfer between 2 Postgres databases.

  • Jason Scarlett User

    I am seeing multiple Feature Requests with this issue. We to need full control over the destination name. Having some "prefix" rule applied breaks our naming conventions in Snowflake.