Logical replication capture
Log based capture through PostgreSQL logical replication, so only committed changes move.
Google Cloud SQL
Polytomic connects Google Cloud SQL for PostgreSQL to your data warehouse, databases, and SaaS tools for ETL and reverse ETL. Replicate tables into your data warehouse and other systems using logical replication change data capture, and write modeled data back into Cloud SQL, without writing code.
Connects through Google
Uses Google's own Cloud SQL connector rather than dialing a raw endpoint.
Source and destination
Replicate out for analytics and write modeled results back in.
Example workflows
Replicate Cloud SQL tables into your data warehouse and other systems
What you can sync
Move data between Cloud SQL for PostgreSQL and your data warehouse, databases, and SaaS tools with full control over table selection and write behavior.
From Google Cloud SQL
Tables and views across one or more schemas
Logical replication change streams with insert, update, and delete
Incremental reads using a tracking field
Incremental reads via xmin for tables without a unique key
Full table reads and point in time snapshots
To Google Cloud SQL
Tables created automatically with new columns added
Update or create as a key based upsert
Create only, update only, and replace all rows
Type changes archived rather than failing the sync
Publication driven table and field discovery
How it works
Connect Cloud SQL with your instance connection name, database credentials, and a service account key. Polytomic connects through Google's own Cloud SQL connector rather than dialing a raw host and port, so you do not need to expose a public database endpoint or run a proxy yourself.
Reading, change data capture, schema handling, and writing all follow standard PostgreSQL behaviour. What is specific here is how the connection is established, through Google's connector rather than a raw endpoint.
- Connect with an instance connection name, database, and credentials
- Provide a service account key with Cloud SQL Client access
- Tick the logical replication option to enable change data capture
- Read changes through logical replication, a tracking field, or a full scan
- Create destination tables and add columns automatically
- Monitor sync health, record volume, and failures from one interface
How to set up
Polytomic needs your Cloud SQL connection name in project, region and instance form, the database name, a username and password, and a JSON service account key with Cloud SQL Client access. Database authentication also supports IAM database authentication, in which case the password may be left empty.
How to get connected
- 1In Google Cloud, note your instance connection name
- 2Create a service account with Cloud SQL Client access and download its key
- 3Enable logical decoding and create a publication if you want change data capture
- 4In Polytomic, navigate to Connections, then Add Connection, then Google Cloud SQL
- 5Enter the connection name, database, credentials, and service account key
- 6Tick the logical replication option, test the connection, and click Save
See the documentation for full setup details.
Frequently asked questions
Why teams choose Polytomic
No engineering required
Set up and manage syncs without writing code.
Flexible data modeling
Use SQL to define exactly what data gets synced.
Handles scale automatically
Supports large datasets with incremental syncs and bulk APIs.
Start syncing your data with Google Cloud SQL in minutes
No credit card required. Free trial available.