Datastream is Google Cloud's serverless change data capture and replication service, streaming changes from Oracle, MySQL, PostgreSQL, SQL Server, MongoDB, and Spanner into BigQuery and Cloud Storage with minimal latency.
Fully managed and serverless: configure a source (with redo logs, row binlog, or a publication and slot enabled per engine) and a destination, and the service streams changes with at-least-once delivery and event UUIDs for deduplication.
How Google Cloud Datastream answers the questions Change Data Capture turns on.
| How it works | |
| Initial snapshot | Backfill handled by the same service |
| End-to-end lag | Seconds, tuned by the BigQuery staleness limit you set |
| Delivery guarantee | At-least-once: event UUIDs for deduplication |
| Schema drift | Handled: new columns and tables replicate; type changes don't |
| Running it | |
| What you run | Nothing: serverless; no instance to size or patch |
| Connections | |
| Sources | MySQL, PostgreSQL, Oracle, SQL Server, Spanner; MongoDB in preview |
| Source requirements | Oracle redo logs, MySQL row binlog, Postgres publication and slot |
| Transformations | None: replication only; transform in BigQuery after landing |
| Destinations | BigQuery, Cloud Storage; Iceberg tables |
| Cost | |
| Billing unit | Per GiB processed, with backfill flat-rate and 500 GiB free monthly |
vs Google Cloud Datastream: Open source (permissive) · Self-hosted · Managed · Free · Subscription · Operational complexity: High · Streaming · Batch · Java, Scala, Python
vs Google Cloud Datastream: Operational complexity: Medium · Batch · Streaming
vs Google Cloud Datastream: Open source (permissive) · Self-hosted · Managed · Free · Subscription · Operational complexity: High · Java