Lecture 39: BigQuery: Machine Learning

Content locked

The catalog is public. Reading this content requires approved access.

Overview

Learning Objectives

LLMs in SQL

Basic Form

Choosing an Endpoint

Labels with Descriptions

BigQuery ML Basics

Train/Test Split

Training: Step 1 — Select Features and Label

Training: Step 2 — Choose a Model Name

Training: Step 3 — Choose a Model Type

Training: Step 4 — Indicate the Label Column

Using Trained Models

ML.WEIGHTS — Inspect Coefficients

ML.PREDICT — Make Predictions

ML.EVALUATE — Measure Performance

Background: Feature Transformation

Patterns and Features

Transforming Non-linear Patterns

Transforming Categorical Features

Conclusion

Source