Today we're introducing Supabase Pipelines: managed change-data-capture pipelines that replicate your Postgres tables to analytical destinations in near real time.
Pipelines reads changes from your Postgres database and writes them to external destinations. It uses logical replication to capture inserts, updates, deletes, and truncates as they happen. Setup takes minutes in the Supabase Dashboard.
The first supported destination is Google BigQuery.
Pipelines is powered by the open-source Supabase ETL engine. You can find the code on GitHub at github.com/supabase/etl.
Postgres is excellent for transactional workloads like reading a single user record or inserting an order. But when you need to scan millions of rows for analytics, Postgres slows down.
