ETL Google BigQuery data to MySQL

About Google BigQuery

BigQuery is a serverless, cost-effective and multicloud data warehouse designed to help you turn big data into valuable business insights.

Learn more about Google BigQuery.

Choose what data you would like to move from Google BigQuery

Table/View

This pipeline can be used to request and retrieve data from the database based on a table/view and/or columns chosen by the user.

Custom Query

This pipeline can be used to request and retrieve data from the database based on a custom query entered by the user.

Learn more about what data can be integrated into your data warehouse using DataChannel in the documentation here.

‍

Steps to Integrate Google BigQuery with MySQL using DataChannel

From the DataSources section select Google BigQuery as the data source.
Select your added MySQL data warehouse as the data destination. If you have not yet added a data warehouse, go to Data Warehouse tab and add a warehouse.
Authorize DataChannel to connect to your Google BigQuery warehouse with your database details, using OAuth, similar to the process described in this Documentation page.
Click on + Data Pipeline to start adding data pipelines to your account.