End-to-end user journeys for ML models

This document describes the user journeys for machine learning (ML) models thatare trained in BigQuery ML, including the statements and functions thatyou can use to work with ML models. BigQuery ML offers thefollowing types of ML models:

Supervised learningmodels:
Unsupervised learningmodels:
Transform-only models:Transform-only models aren't typical ML models but areinstead artifacts that transform raw data into features.

Model creation user journeys

The following table describes the statements and functions you can use to createand tune models:

Model category	Model type	Model creation	Feature preprocessing	Hyperparameter tuning¹	Model weights	Feature & training info	Tutorials
Supervised learning	Linear & logistic regression	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	`ML.WEIGHTS`	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	Use linear regression to predict penguin weight Perform classification with a logistic regression model
	Deep neural networks (DNN)	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
	Wide & Deep networks	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
	Boosted trees	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	Perform classification with a boosted trees model
	Random forest	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
	AutoML classification & regression	`CREATE MODEL`	AutoML automatically performs feature engineering	AutoML automatically performs hyperparameter tuning	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
Unsupervised learning	K-means	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	`ML.CENTROIDS`	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	Find clusters in bike station data
	Matrix factorization	`CREATE MODEL`	N/A	Hyperparameter tuning `ML.TRIAL _INFO`	`ML.WEIGHTS`	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	Generate movie recommendations using explicit feedback Generate content recommendations using implicit feedback
	Principal component analysis (PCA)	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	N/A	`ML.PRINCIPAL _COMPONENTS` `ML.PRINCIPAL _COMPONENT _INFO`	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
	Autoencoder	`CREATE MODEL`	Automatic preprocessing Manual preprocessing	Hyperparameter tuning `ML.TRIAL _INFO`	N/A²	`ML.FEATURE _INFO` `ML.TRAINING _INFO`	N/A
Transform-only	Transform-only	`CREATE MODEL`	Manual preprocessing	N/A	N/A	`ML.FEATURE _INFO`	N/A

¹For a step-by-step example of using hyperparameter tuning, seeImprove model performance with hyperparameter tuning.

²BigQuery ML doesn't offer a function to retrieve theweights for this model. To see the weights of the model, you canexport the model from BigQuery ML to Cloud Storage and then use theXGBoost library or the TensorFlow library to visualize the treestructure for tree models or the graph structure for neural networks. For moreinformation, seeEXPORT MODEL andExport a BigQuery ML model for online prediction.

Model use user journeys

The following table describes the statements and functions you can use toevaluate, explain, and get predictions from models:

Model category	Model type	Evaluation	Inference	AI explanation	Model monitoring
Supervised learning	Linear & logistic regression	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT` `ML.TRANSFORM`	`ML.EXPLAIN_PREDICT`³ `ML.GLOBAL_EXPLAIN` `ML.ADVANCED_WEIGHTS`⁵	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Deep neural networks (DNN)	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT` `ML.TRANSFORM`	`ML.EXPLAIN_PREDICT`³ `ML.GLOBAL_EXPLAIN` `ML.ADVANCED_WEIGHTS`⁵	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Wide & Deep networks	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT` `ML.TRANSFORM`	`ML.EXPLAIN_PREDICT`³ `ML.GLOBAL_EXPLAIN` `ML.ADVANCED_WEIGHTS`⁵	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Boosted trees	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT` `ML.TRANSFORM`	`ML.EXPLAIN_PREDICT`³ `ML.GLOBAL_EXPLAIN` `ML.FEATURE_IMPORTANCE`⁴	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Random forest	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT` `ML.TRANSFORM`	`ML.EXPLAIN_PREDICT`³ `ML.GLOBAL_EXPLAIN` `ML.FEATURE_IMPORTANCE`⁴	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	AutoML classification & regression	`ML.EVALUATE` `ML.CONFUSION _MATRIX`¹ `ML.ROC_CURVE`²	`ML.PREDICT`	`ML.GLOBAL_EXPLAIN`	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
Unsupervised learning	K-means	`ML.EVALUATE`	`ML.PREDICT` `ML.DETECT _ANOMALIES` `ML.TRANSFORM`	N/A	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Matrix factorization	`ML.EVALUATE`	`ML.RECOMMEND` `ML.GENERATE _EMBEDDING`	N/A	N/A
	Principal component analysis (PCA)	`ML.EVALUATE`	`ML.PREDICT` `ML.GENERATE _EMBEDDING` `ML.DETECT _ANOMALIES` `ML.TRANSFORM`	N/A	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
	Autoencoder	`ML.EVALUATE`	`ML.PREDICT` `ML.GENERATE _EMBEDDING` `ML.DETECT _ANOMALIES` `ML.RECONSTRUCTION _LOSS` `ML.TRANSFORM`	N/A	`ML.DESCRIBE_DATA` `ML.VALIDATE_DATA _DRIFT` `ML.VALIDATE_DATA _SKEW` `ML.TFDV_DESCRIBE` `ML.TFDV_VALIDATE`
Transform-only	Transform-only	N/A	`ML.TRANSFORM`	N/A	N/A

¹ML.CONFUSION_MATRIX is only applicable to classification models.

²ML.ROC_CURVE is only applicable to binary classification models.

³TheML.EXPLAIN_PREDICT function encompasses theML.PREDICT function because its output is a superset of theresults ofML.PREDICT.

⁴To understand the difference betweenML.GLOBAL_EXPLAIN andML.FEATURE_IMPORTANCE, see theExplainable AI overview.

⁵TheML.ADVANCED_WEIGHTS function encompasses theML.WEIGHTS function because its output is a superset of theresults ofML.WEIGHTS.

Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.

Last updated 2026-02-18 UTC.

Movatterモバイル変換

End-to-end user journeys for ML models

Model creation user journeys

Model use user journeys