Connect MySQL to BigQuery

Instead of complex integration scenarios with lots of custom coding, try Coupler.io’s no-code MySQL to BigQuery integration. All you need to do is set up the importer with pre-built connectors and no-code settings for data collection, transformation, and transfer.

To export MySQL to BigQuery, follow these simple steps:

Step 1: Collect data
The initial step of the integration is to link the MySQL server account to Coupler.io for authorization and access. For that, specify the MySQL database name from which you’d like to extract data. This information is crucial since there might be several databases connected to the same MySQL account. Then, specify the name of the table for data export.



Once all the source settings are in place, click FINISH & PROCEED to go to the next step.

Step 2: Organize and transform
Before loading MySQL data to BigQuery, check its accuracy and structure in the preview window. If some transformations are needed, Coupler.io offers a number of options for data transformation and management:

• Sort records
• Filter records
• Edit names and rearrange columns
• Hide columns
• Add new columns with custom metrics using mathematical formulas
• Blend data from different MySQL tables or other apps

These functions help to prepare MySQL data for further analysis in BigQuery.



Step 3: Load and schedule refresh
Go to the Destination tab and configure the BigQuery connection. Specify the dataset name and the preferred table. Alternatively, create a new dataset or table right from the Coupler.io interface.



To connect MySQL to BigQuery and regularly send data from one database to another, enable the Automatic data refresh option. Specify the scheduling parameters of your choice.

To start the integration, save the importer and click Run.

Thanks to Automatic data refresh, your MySQL data will be self-updated in Google BigQuery. Select the update interval, the days of the week, hours, and time zone to decide how often to refresh data.



With Coupler.io, you can reduce manual intervention in your integration scenarios. Your data will be collected automatically, and the BigQuery table will always coincide with the latest MySQL data.