Google BigQuery + MySQL

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

When a new row is added in your MySQL database using a custom query, this workflow instantly adds that data to Google BigQuery. It streamlines your data management, keeping Google BigQuery updated with any new information from your MySQL database. This automation effectively eradicates the need for manual data transfers, saving you time and effort.

When a new row is added in your MySQL database using a custom query, this workflow instantly adds that data to Google BigQuery. It streamlines your data management, keeping Google BigQuery updated with any new information from your MySQL database. This automation effectively eradicates the need for manual data transfers, saving you time and effort.

  1. When this happens...
    MySQLMySQL
    New Row (Custom Query)

    Triggers when new rows are returned from a custom query that you provide. Advanced Users Only.

    TriggerScheduled
  2. automatically do this!
    Google BigQueryGoogle BigQuery
    Create Row

    Creates a new row of data in a table. Note: Does not create a job.

    ActionWrite
Start free with email
Start free with email
  • Free forever for core features
  • 14 day trial for premium features & apps

Supported triggers and actions

What does this mean?
    • Table/ViewRequired

    Trigger
    Scheduled
    Try It
    • QueryRequired

    Trigger
    Scheduled
    Try It
    • Table/ViewRequired

    • Primary KeyRequired

    • Order ByRequired

    • Trigger Column

    Trigger
    Scheduled
    Try It
    • TableRequired

    • ID ColumnRequired

    Action
    Write
    • Table/ViewRequired

    • Order By

    • Dedupe Key

    Trigger
    Scheduled
    Try It
  • MySQL triggers, actions, and search

    New Table

    Triggers when you add a new table.

    Trigger
    Scheduled
    Try It
    • TableRequired

    Action
    Write
    • TableRequired

    • Lookup ColumnRequired

    • Lookup ValueRequired

    Action
    Search
google-bigquery logo
google-bigquery logo

About Google BigQuery

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

Related categories

  • Databases
  • Google
mysql logo
mysql logo

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 more

Related categories

  • Databases

Similar apps

SQL Server integrationsSQL Server integrations

SQL Server

Databases
Quickbase integrationsQuickbase integrations

Quickbase

Databases
Firebase / Firestore integrationsFirebase / Firestore integrations

Firebase / Firestore

Databases