03-data-warehouse

Data Warehouse and BigQuery

• Slides
• Big Query basic SQL

Videos

Data Warehouse

• Data Warehouse and BigQuery

🎥 Partitoning and clustering

• Partioning and Clustering

• Partioning vs Clustering

🎥 Best practices

🎥 Internals of BigQuery

Advanced topics

🎥 Machine Learning in Big Query

• SQL for ML in BigQuery

Important links

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

🎥 Deploying Machine Learning model from BigQuery

• Steps to extract and deploy model with docker

Homework

• 2024 Homework

Community notes

Did you take notes? You can share them here.

• 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
• Add your notes here (above this line)