What you need
- A Zwiron account — start free trial
- MySQL with binlog CDC prerequisites (see MySQL connector)
- A Google BigQuery project and destination credentials (see BigQuery connector)
- Hosted or Agent execution mode
Steps
1. Pick execution mode
Use Hosted when MySQL and BigQuery are reachable from the internet (allowlist egress IPs if required). Use an agent when MySQL sits in a private network — when to use the agent.2. Connect MySQL and BigQuery
- Create a Connection for MySQL.
- Create a Connection for BigQuery.
- Test both connections.
3. Build the pipeline
- Create a job: MySQL → BigQuery (first pipeline guide).
- Select tables.
- Prefer CDC for continuous updates; otherwise Incremental or Full Refresh (sync modes, CDC).