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

Community

Destination Improvement: Allow synching of indices between PostgreSQL databases

Answered
Borja Lazaro Toralles User

We'd find it very useful if Fivetran would be able to synch indices from a source Google Cloud PostgreSQL database to another Google Cloud PostgreSQL destination.

Currently the connector and destination synch both the data and the schema. For our BI analytics we'd benefit from synching the original indices too and we're now forced to implement that in-house.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Kevin Kim Fivetranner

    Hi Borja,

    Thank you for your feedback in our feature request portal! I'm Kevin from the product team here at Fivetran.

    We don't have a concrete timeline at the moment for adding this feature. However, many customers have asked for this same functionality, so I will be sure to add yours to the tally. I am curious what types of indices you are currently using in Postgres, based on their docs, there are many different kinds: https://www.postgresql.org/docs/current/indexes-types.html

    Any insight you can share will help us scope out this project!

  • Borja Lazaro Toralles User

    Hi Kevin, we're primarily interested on btree indexes (unique and non-unique, multi-column...). Looking forward to the implementation :)