3.3.1 - BigQuery Machine Learning

Last updated Feb 5, 2025

🕓 Estimated time spent on this lesson | ~35 min

Youtube Video | ~16 min

https://www.youtube.com/watch?v=B-WtpB0PuG4&list=PL3MmuxUbc_hJed7dXYoJw8DoCuVHhGEQb&index=31

✍️ In this video we will discuss BigQuery ML and pricing

💰 Pricing

For Free we get

• 10 GB per month of data storage

• 1 TB per month of queries processed

• ML Create model step: First 10 GB per month is free

For Full pricing see

Pricing  |  BigQuery: Cloud Data Warehouse  |  Google CloudGoogle Cloud

BigQuery ML

Full BigQuery ML SQL found here - https://github.com/DataTalksClub/data-engineering-zoomcamp/blob/main/03-data-warehouse/big_query_ml.sql

Introduction to AI and ML in BigQuery  |  Google CloudGoogle Cloud

For our video example, we want to use Machine Learning to predict the tip amount. In addition to the video, this blog post by Cris Crawford walks through all of the steps:

BigQuery Machine LearningDEV Community

Resources

An End to End Machine Learning Model Development Guide Using BigQuery MLGoogle Cloud - Community