Skip to content

ETL to move data from MySQL into BigQuery using Airflow

Notifications You must be signed in to change notification settings

lixx21/Airflow-MySQL-To-BigQuery

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

4 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Airflow-MySQL-To-BigQuery

How to use

  1. Install requirements libraries using this command pip install -r requirements.txt
  2. In Airflow you need to add connection for gcp_conn_id and mysql_conn_id.
  3. in etl.py, filled BUCKET_NAME, SQL_QUERY, FILENAME, gcp_conn_id, mysql_conn_id, schema, destination_dataset_table
  4. Then you can just run the airflow and the dags

Then finally, you have moved your data from MySQL into BigQuery.

About

ETL to move data from MySQL into BigQuery using Airflow

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages