Skip to content

Google BigQuery + MySQL

Google BigQuery + MySQL

Google BigQuery + MySQL integrations

Create and update rows in Google BigQuery when new or updated rows happen in MySQL

Keep your data seamless and updated with this powerful workflow. When changes are made in your MySQL database, a respective row is instantly created in Google BigQuery, without the need for manual data entry. Streamline your data management and ensure a unified, up-to-date repository effortlessly.

When this happens...
New or Updated RowTriggers when a new row is added or modified.
TriggerPolling
automatically do this!
Create RowCreates a new row of data in a table. Note: Does not create a job.
ActionWrite

Start free with email

Start free with email

Start free with Google

Free forever for core features
14 day trial for premium features & apps

More things you can do with MySQL and Google BigQuery

Discover other triggers and actions you can use with MySQL and Google BigQuery

- Table/View
  Required
Trigger
Polling
Try It
- Query
  Required
Trigger
Polling
Try It
- Table/View
  Required
- Primary_key
  Required
- Order_by
  Required
- Trigger_column
- Trigger Column Configuration
Trigger
Polling
Try It
- Table
  Required
- ID Column
  Required
Action
Write
- Query
  Required
Action
Search

- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
  Required
- Unique Column
  Required
Trigger
Polling
Try It
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Unique Column
  Required
- IS Operator
Trigger
Polling
Try It

- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Rows
  Required
- Skip Invalid Rows
- Ignore Unknown Values
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
- Update Columns
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search
- Project
  Required
- Dataset
  Required
- Table
  Required
- Sort By Column
- Sort Direction
- Where Clause
  Required
Action
Search or write

- Table/View
  Required
- Order_by
- Dedupe_key
Trigger
Polling
Try It
New Table
Triggers when you add a new table.
Trigger
Polling
Try It
- Table
  Required
Action
Write
- Table
  Required
- Lookup Column
  Required
- Lookup_value
  Required
Action
Search
- Project
  Required
- Dataset
- Table
Trigger
Polling
Try It
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Trigger
Polling
Try It
- Project
  Required
- Dataset
  Required
- Table
  Required
Action
Write
- Project ID
  Required
- Dataset
  Required
- Table
  Required
- Where Column
  Required
- Where Value
  Required
Action
Write
- Project ID
  Required
- SQL Query
  Required
- Location
Action
Write
- Stop on error
  Required
- HTTP Method
  Required
- URL
  Required
- Query string parameters
- Additional request headers
- Body
Action
Write
- Project ID
  Required
- Job ID
  Required
- Location
  Required
Action
Search

About Google BigQuery

BigQuery is Google's serverless and highly scalable enterprise data warehouse, designed to make all your data analysts productive.

Learn moreLearn moreHelpHelp

Related categories

About MySQL

MySQL is a premier database used in millions of production environments around the world. Easily plug your MySQL database into any web service.

Learn moreLearn moreHelpHelp

Related categories

Similar apps

SQL Server

Databases

Quickbase

App Builder

Firebase / Firestore

Databases

Related Zap Templates

Related Zap Templates

Create new data rows in Google BigQuery from new MySQL rows

Generate new MySQL rows when new jobs are done in Google BigQuery

Create new rows in Google BigQuery from new rows in MySQL using custom queries