Frustratingly simple ETL for Postgres
10x faster data movement from and to your Postgres database. Empower your data engineers to write scalable pipelines with ease, in minutes, with SQL.
Backed by
Combinator
CREATE PEER postgres_peer
FROM postgres (...);
postgres connection validated and created peer
CREATE PEER snowflake_peer
FROM snowflake (...);
snowflake connection validated and created peer
CREATE MIRROR real_time_cdc
FROM postgres_peer
TO snowflake_peer
WITH TABLE MAPPING (transactions:transactions, users:users);
transactions and users table replicated in realtime from postgres to snowflake.
Total time: 2 sec
FROM postgres (...);
postgres connection validated and created peer
CREATE PEER snowflake_peer
FROM snowflake (...);
snowflake connection validated and created peer
CREATE MIRROR real_time_cdc
FROM postgres_peer
TO snowflake_peer
WITH TABLE MAPPING (transactions:transactions, users:users);
transactions and users table replicated in realtime from postgres to snowflake.
Total time: 2 sec
Benchmarks
PeerDB · 4.5 min
AirByte · 34 min
Fivetran · Not supported
PeerDB · 30 sec
AirByte · +1 hrs
Fivetran · 5 min
PeerDB · 4 min
AirByte · 28 min
Fivetran · Not supported
PeerDB · 33 sec
AirByte · +1 hrs
Fivetran · 5 min
Real-time CDC
from PostgreSQL
Data-freshness guarantees of less than 30s on target.
Real-time Streaming
of Query Results
Streaming ~100 million rows in 4.5 minutes.
Integrations
Get data in and out of Postgres from multiple connectors
Offerings
check
Real-time CDC – Postgres to Kafka, Azure Event Hubs, Postgres, Snowflake and BigQuery
check
Streaming Query – Postgres to Snowflake, BigQuery, S3 and Postgres; SQL Server to Postgres
check
Query Layer – Snowflake, BigQuery and PostgreSQL.
check
Docker container to setup and install PeerDB
Everything in "PeerDB Open Source" plus...
check
Fully managed and hosted on AWS, Azure and GCP.
check
Blazing fast initial load.
check
Advance metrics and monitoring dashboards
check
High Availability
Everything in "PeerDB Open Source", plus...
check
Blazing fast initial load.
check
Advance metrics and monitoring
check
Kubernetes Helm Chart
check
White-glove Implementation Support
check
24x7 support with enterprise-grade SLAs