The ALTER MODEL statement

Stay organized with collections Save and categorize content based on your preferences.

ALTER MODEL statement

To update a model in BigQuery, use the BigQuery ML ALTER MODEL statement.

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.

ALTER MODEL syntax

ALTER MODEL [IF EXISTS] <model_name> SET OPTIONS (key=value, …);

Options table
OPTION_NAME OPTION_TYPE OPTION_VALUE
vertex_ai_model_id STRING The Vertex AI model ID to register the model with. To learn more, see Register an existing BigQuery ML model to the Vertex AI Model Registry
expiration_timestamp FLOAT64 The time when this model expires.
kms_key_name STRING The name of the Cloud KMS key used to encrypt the model.
description STRING A description of the model.
labels ARRAY<STRUCT<STRING, STRING>> An array of STRUCT's that represent the labels on the model.