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

Community

Connector Improvement: CockroachDB - support hash-sharded primary keys

Completed
martin tietz User

Currently the Fivetran connector for CockroachDB does not support primary keys that include virtual columns which is the case when a primary key is hash-sharded. Hash sharding is necessary to avoid hot ranges for tables which have sequential primary keys and receive a lot of inserts. Fivetran should support that use case.

Please sign in to leave a comment.

Comments

2 comments

Date Votes
  • Official comment
    Valentin Kulichenko Fivetranner

    Hi Martin,

    Wanted to let you know that we implemented support for hash-sharded primary keys, please see the updated docs: https://fivetran.com/docs/connectors/databases/cockroachdb#hashshardedprimarykeys

    You should be able to replicate such tables now. Should you have any issues, please let us know!

    Thanks,
    Val Kulichenko, Fivetran Product Team

  • Valentin Kulichenko Fivetranner
    • Edited

    Hi Martin,

    Thanks for bringing this up. The request certainly makes sense, and our initial assessment is that it shouldn't be hard to implement. We are verifying this as we speak; I will update with a more specific timeline when I have more information.

    Thanks,
    Val Kulichenko, Fivetran Product Team