MySQL to BigQuery sync that lands MySQL tables in BigQuery incrementally

The MySQL to BigQuery connector from Adapters syncs MySQL tables into BigQuery on an incremental schedule, converting MySQL types to BigQuery types and merging on the primary key so your dashboards read warehouse tables instead of hitting the production database. Field mapping takes about a minute and no code is required.

Try it in the live demo

No credit card required.

Input

Output

Field mapping auto-plugged · tap a port to rewire

5 sample records ready

Last updated August 2026

What running MySQL to BigQuery by hand costs you

Dashboards pointed straight at production MySQL add load to the database that also takes customer orders.
BigQuery bills by bytes scanned, so an unpartitioned copy of a large MySQL table turns a cheap dashboard into a recurring line item.
Reloading the whole table nightly is simple until the table is 400 million rows and the load runs into business hours.

The field mapping, out of the box

These cables are pre-wired when you pick the pair. Rewire any of them, or add your own, in the same visual data mapping tool you use for every adapter.

Input / MYSQL

Output / BIGQUERY

orders.id

customers.email

customers.full_name

customers.name

orders.total_amount

orders.updated_at

orders.created_at

orders.status

Transforms included

Incremental runs use a MySQL updated_at watermark so only changed rows load; DECIMAL maps to BigQuery NUMERIC at its declared scale (and BIGNUMERIC past 38 digits), TINYINT(1) becomes BOOL, DATETIME and TIMESTAMP normalize to BigQuery TIMESTAMP in UTC while true wall-clock columns can stay DATETIME, JSON columns land as JSON, destination tables are partitioned on the load date so queries prune bytes scanned, and loads MERGE on the primary key so replays never duplicate.

How it goes live

Three steps, minutes end to end, covered by flat data integration pricing from $49 a month.

STEP 01

Pick the pair

Connect MySQL and BigQuery with scoped credentials. About a minute each.

STEP 02

Confirm the mapping

The cables above are pre-wired. Adjust any field, preview the transform on sample records, done.

STEP 03

Schedule the sync

Hourly down to every minute, with retries, alerting, and a full log on every run.

Prefer to understand the moving parts first? Our long-form guide to replicating MySQL into BigQuery covers the field-by-field detail, the failure cases, and what changes at volume.

Try it in the live demo Preloads MYSQL → BIGQUERY with sample records

MySQL to BigQuery sync: common questions

How does the MySQL to BigQuery sync work?

Is there a prebuilt MySQL connector for BigQuery?

Yes. This MySQL to BigQuery connector ships prebuilt: the field mapping is wired the moment you pick the pair, transforms are included, and the first sync can run within minutes. No code or engineering sprint required.

How much does the MySQL BigQuery integration cost?

Pricing is flat and monthly: Starter at $49, Growth at $149, Scale at $399. Every plan includes this pair, visual field mapping, and per-record logs. There are no per-task or per-row fees, so the bill stays the same as volume grows.

How often can Adapters sync MySQL to BigQuery?

Hourly on Starter, every 5 minutes on Growth, and down to every minute on Scale. Failed records retry automatically with backoff, and alerting plus a full per-record log come standard on every run.

Do I need to write code to connect MySQL and BigQuery?

No. Fields are auto-mapped the moment you pick the pair, and you can rewire any mapping visually before the first sync. Incremental runs use a MySQL updated_at watermark so only changed rows load; DECIMAL maps to BigQuery NUMERIC at its declared scale (and BIGNUMERIC past 38 digits), TINYINT(1) becomes BOOL, DATETIME and TIMESTAMP normalize to BigQuery TIMESTAMP in UTC while true wall-clock columns can stay DATETIME, JSON columns land as JSON, destination tables are partitioned on the load date so queries prune bytes scanned, and loads MERGE on the primary key so replays never duplicate.

More pairs from the API connector library

Browse the full api connector library, or request a pair you do not see.

MySQL and BigQuery, finally in agreement

Map the pair once and let it sync on schedule. Flat price from $49 a month, no per-task fees.

Try the live demo

No credit card required.