The CREATE MODEL statement
To create a model in BigQuery, use the BigQuery ML CREATE
MODEL
statement. This statement is similar to the
CREATE TABLE
DDL statement. When you run a query that contains a CREATE MODEL
statement, a query job is generated for you that
processes the query.
For information about supported model types of each SQL statement and function, and all supported SQL statements and functions for each model type, read End-to-end user journey for each model.
CREATE MODEL
syntax
{CREATE MODEL | CREATE MODEL IF NOT EXISTS | CREATE OR REPLACE MODEL} model_name [TRANSFORM (select_list)] [INPUT (field_name field_type) OUTPUT (field_name field_type)] [REMOTE WITH CONNECTION `connection_name`] [OPTIONS(model_option_list)] [AS {query_statement | ( training_data AS (query_statement), custom_holiday AS (holiday_statement) )}] model_option_list: MODEL_TYPE = { 'LINEAR_REG' | 'LOGISTIC_REG' | 'KMEANS' | 'MATRIX_FACTORIZATION' | 'PCA' | 'AUTOENCODER' | 'AUTOML_CLASSIFIER' | 'AUTOML_REGRESSOR' |