Google BigQuery
real-time ingestion
TwinCommit applies changes to Google BigQuery with exactly-once, commit-ordered semantics from any of 9 log-based sources, including Oracle, MySQL, SQL Server and Db2. Storage Write API ingest with MERGE-based upserts and deletes.
Google BigQuery
Google BigQuery (all editions) · BigLake tables
- ✓A service account with BigQuery Data Editor and Job User
- ✓A dataset for staging tables
- ✓Primary keys declared on target tables (recommended)
Apply
How TwinCommit writes to BigQuery
Changes stream through the BigQuery Storage Write API into staging tables and are applied with MERGE on a configurable interval, so deletes and updates are reflected exactly.
BigQuery target docs →BigQuery connector FAQ
Which BigQuery versions does TwinCommit support?
+
Google BigQuery (all editions) · BigLake tables.
How does TwinCommit write to BigQuery?
+
Changes stream through the BigQuery Storage Write API into staging tables and are applied with MERGE on a configurable interval, so deletes and updates are reflected exactly.
Replicate your first table in five minutes.
Download the free Developer edition, or have one of our replication engineers walk you through a migration plan.