Data Warehouse and BigQuery

Slides
Big Query basic SQL

Data Warehouse

Data Warehouse and BigQuery

Partitoning and clustering

Partioning and Clustering
Partioning vs Clustering

Best practices

BigQuery Best Practices

Internals of BigQuery

Internals of Big Query

Advance

ML

BigQuery Machine Learning
SQL for ML in BigQuery

Important links

• BigQuery ML Tutorials
• BigQuery ML Reference Parameter
• Hyper Parameter tuning
• Feature preprocessing

Deploying ML model

BigQuery Machine Learning Deployment
Steps to extract and deploy model with docker

Workshop

• Integrating Bigquery with Airflow (+ Week 2 Review) - Video

• Setup: Copy over the airflow directory (i.e. the Dockerized setup) from week_2_data_ingestion:

  cp ../week_2_data_ingestion/airflow airflow
  

  Also, empty the logs directory, if you find it necessary.

• DAG: gcs_to_bq_dag.py

Homework

Community notes

Did you take notes? You can share them here.

• Notes by Alvaro Navas
• Isaac Kargar's blog post
• Add your notes here (above this line)