The actively-maintained destinations are ClickHouse, ClickHouse Cloud, and Postgres. Snowflake, ElasticSearch, Kafka (including the Confluent and Redpanda variants), Azure Event Hubs, Google Pub/Sub, S3, GCS, and BigQuery as a destination are deprecated and no longer actively maintained. They remain fully functional and no code is currently being removed. BigQuery is deprecated only as a destination; it remains a supported source.Query Based or Watermark Based Replication (QRep), including XMIN-based replication, is also a deprecated mirror type. We recommend CDC (Change Data Capture) as the actively-maintained mirror type for new mirrors.
WAL or Change Data Capture (CDC) Based Replication
Below table shows supported features and features we are working on for WAL or CDC Based replication from Postgres to different targets.
ā means supported. š ļø means Work in Progress and Coming Soon!.
Query Based or Watermark Based Replication (QRep), including XMIN-based replication, is a deprecated mirror type and no longer actively maintained. It remains fully functional and no code is currently being removed. We recommend CDC (Change Data Capture) as the actively-maintained mirror type for new mirrors.
Below table shows supported features and features we are working on for Query Based or Watermark Based Replication from Postgres to different targets.
ā means supported. š ļø means Work in Progress and Coming Soon!.
Feature
Snowflake
BigQuery
Postgres
S3/GCS
Initial Snapshot
ā
ā
ā
ā
Incremental Sync Based on Watermark
ā
ā
ā
ā
DML Support - INSERT, UPDATE (if updated_at & primary key are present)
ā
ā
ā
ā
Schema Changes - ADD COLUMN
ā
š ļø
š ļø
š ļø
Resync Mirrors
ā
š ļø
š ļø
š ļø
Partitioned Tables
ā
ā
ā
ā
Advanced Types - Arrays, JSONB, HSTORE, Geospatial etc.
