In this video I will setup a pipeline that will clean a public dataset with 137M birth records, removing nulls and wrong values. I will then train a machine learning model from the newly created table in BigQuery using BigQuery ML. Lastly I will demonstrate how to use Cloud Composer, based on Apache Airflow, to automate the complete pipeline.