Stay organized with collectionsSave and categorize content based on your preferences.
The ALTER MODEL statement
ALTER MODELstatement
To update a model in BigQuery, use the BigQuery MLALTER
MODELstatement.
For information about supported model types of each SQL statement and function,
and all supported SQL statements and functions for each model type, readEnd-to-end user journey for each model.
ALTER MODELsyntax
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-29 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,["# The ALTER MODEL statement\n=========================\n\n`ALTER MODEL` statement\n-----------------------\n\nTo update a model in BigQuery, use the BigQuery ML `ALTER\nMODEL` statement.\n\nFor information about supported model types of each SQL statement and function,\nand all supported SQL statements and functions for each model type, read\n[End-to-end user journey for each model](/bigquery/docs/reference/standard-sql/bigqueryml-syntax-e2e-journey).\n\n`ALTER MODEL` syntax\n--------------------\n\n`ALTER MODEL [IF EXISTS] \u003cmodel_name\u003e SET OPTIONS (key=value, ...);`\n\n##### Options table"]]