Stay organized with collections
Save and categorize content based on your preferences.
The ALTER MODEL statement
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, …);
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThe \u003ccode\u003eALTER MODEL\u003c/code\u003e statement in BigQuery ML is used to update existing models.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003eALTER MODEL\u003c/code\u003e syntax allows you to modify a specified model's options using \u003ccode\u003eSET OPTIONS\u003c/code\u003e.\u003c/p\u003e\n"],["\u003cp\u003eModifiable options include the Vertex AI model ID, model expiration timestamp, Cloud KMS key name, model description, and model labels.\u003c/p\u003e\n"],["\u003cp\u003eYou can find more information on model type support and SQL statement compatibility in the "End-to-end user journey" documentation.\u003c/p\u003e\n"]]],[],null,[]]