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

Community

Connector Improvement: CockroachDB - support geometry columns

Completed
Daniel Babiak User
  • Edited

Which connector?: CockroachDB

Additional details: We are migrating from Postgres to CockroachDB

Fivetran supports syncing postgis types, but does not yet support syncing crdb's geometry types

Please add support for syncing geometry columns :)

For what it's worth, the postgres postgis types we are using:

  1. postgis.geometry(Point, 4326)
  2. postgis.geometry(Polygon, 4326)

crdb has a ST_AsGeoJSON function which seems to work for these types as expected, so hopefully adding support should be straightforward?

Please sign in to leave a comment.

Comments

4 comments

Date Votes
  • Official comment
    Valentin Kulichenko Fivetranner
    • Edited

    Hi Daniel,

    We added the support for GEOMETRY and GEOGRAPHY types. You can find the full list of data types supported by the CockroachDB connector here: https://fivetran.com/docs/connectors/databases/cockroachdb#schemainformation

    Thanks,
    Val Kulichenko, Fivetran Product Team

  • Valentin Kulichenko Fivetranner

    Hi Daniel,

    The feature definitely makes sense, I will put it on the roadmap.

    How urgent is this for you at this point? Does it block any of the migrations?

    Thanks,
    Val Kulichenko, Fivetran Product Team

  • Daniel Babiak User

    Thank you!

    We can proceed with migrations by adding `*_geojson jsonb` columns to each table that uses geometry, store the result of ST_AsGeoJSON decoding the respective geometry columns, and then stitch things together in snowflake.

    This should be ok for migrating smaller workloads, but we'd prefer to not need to do this for larger workloads

  • Valentin Kulichenko Fivetranner
    • Edited

    Hi Daniel,

    Just a quick update. I added this feature to the roadmap. Assuming there are no bump, we should roll out it within the next 2-3 months.

    Thanks,
    Val, Fivetran Product Team