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

Community

Connector Improvement: CockroachDB - support geometry columns

Planned
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

2 comments

Date Votes
  • 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