Data Warehouse and BigQuery

• Slides
• Big Query basic SQL

Videos

Data Warehouse

• Data Warehouse and BigQuery

:movie_camera: Partitioning and clustering

• Partitioning vs Clustering

:movie_camera: Best practices

:movie_camera: Internals of BigQuery

Advanced topics

:movie_camera: Machine Learning in Big Query

• SQL for ML in BigQuery

Important links

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

:movie_camera: Deploying Machine Learning model from BigQuery

• Steps to extract and deploy model with docker

Homework

• 2026 Homework

Community notes

• Notes by Alvaro Navas
• Isaac Kargar's blog post
• Marcos Torregrosa's blog post
• Notes by Victor Padilha
• Notes from Xia He-Bleinagel
• Bigger picture summary on Data Lakes, Data Warehouses, and tooling, by Vera
• Notes by froukje
• Notes by Alain Boisvert
• Notes from Vincenzo Galante
• 2024 videos transcript week3 by Maria Fisher
• Notes by Linda
• Jonah Oliver's blog post
• 2024 - steps to send data from Mage to GCS + creating external table by Maria Fisher
• 2024 - mage dataloader script to load the parquet files from a remote URL and push it to Google bucket as parquet file by Anju Mohan
• 2024 - steps to send data from Mage to GCS + creating external table by Maria Fisher
• Notes by HongWei
• 2025 Notes by Manuel Guerra
• Notes from Horeb SEIDOU
• 2025 - Notes by Gabi Fonseca
• 2025 Gitbook Notes Tinker0425
• 2025 Notes from Daniel Lachner
• 2026 Notes from Catherine Frost
• Add your notes here (above this line)