Model creation
BigQuery ML lets you build and operationalize machine learning (ML)
models over data in BigQuery by using SQL.
A typical model development workflow in BigQuery ML looks similar
to the following:
- Create the model using the
CREATE MODEL statement.
- Perform feature preprocessing. Some preprocessing happens
automatically,
plus you can use
manual preprocessing functions
inside the
TRANSFORM clause
to do additional preprocessing.
- Refine the model by performing
hyperparameter tuning to fit the model
to the training data.
- Evaluate the model to assess how it might
perform on data outside of the training set, and also to compare it to other
models if appropriate.
- Perform inference to analyze data by
using the model.
- Provide explainability for the model, to
clarify how particular features influenced a given prediction and also the
model overall.
- Learn more about the components that comprize the model by using
model weights.
Because you can use many different kinds of models in BigQuery ML,
the functions available for each model vary. See the
End-to-end user journey for each model to see
the specific functions available for each model.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-08-25 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-25 UTC."],[[["\u003cp\u003eBigQuery ML enables the creation and operationalization of machine learning models using SQL over BigQuery data.\u003c/p\u003e\n"],["\u003cp\u003eModel development in BigQuery ML involves creating, preprocessing, tuning, evaluating, inferencing, and explaining models.\u003c/p\u003e\n"],["\u003cp\u003eBigQuery ML supports both automatic and manual feature preprocessing via functions and the \u003ccode\u003eTRANSFORM\u003c/code\u003e clause.\u003c/p\u003e\n"],["\u003cp\u003eHyperparameter tuning is used to refine the model to better fit the training data.\u003c/p\u003e\n"],["\u003cp\u003eThe available functions vary between each type of model, detailed in the end-to-end user journey for each model.\u003c/p\u003e\n"]]],[],null,["# Model creation\n==============\n\nBigQuery ML lets you build and operationalize machine learning (ML)\nmodels over data in BigQuery by using SQL.\n\nA typical model development workflow in BigQuery ML looks similar\nto the following:\n\n1. Create the model using the [`CREATE MODEL` statement](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create).\n2. Perform feature preprocessing. Some preprocessing happens [automatically](/bigquery/docs/reference/standard-sql/bigqueryml-auto-preprocessing), plus you can use [manual preprocessing functions](/bigquery/docs/reference/standard-sql/bigqueryml-preprocessing-functions) inside the [`TRANSFORM` clause](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-create#transform) to do additional preprocessing.\n3. Refine the model by performing [hyperparameter tuning](/bigquery/docs/hp-tuning-overview) to fit the model to the training data.\n4. [Evaluate the model](/bigquery/docs/evaluate-overview) to assess how it might perform on data outside of the training set, and also to compare it to other models if appropriate.\n5. [Perform inference](/bigquery/docs/inference-overview) to analyze data by using the model.\n6. Provide [explainability](/bigquery/docs/xai-overview) for the model, to clarify how particular features influenced a given prediction and also the model overall.\n7. Learn more about the components that comprize the model by using [model weights](/bigquery/docs/weights-overview).\n\nBecause you can use many different kinds of models in BigQuery ML,\nthe functions available for each model vary. See the\n[End-to-end user journey for each model](/bigquery/docs/e2e-journey) to see\nthe specific functions available for each model."]]
