The EXPORT MODEL statement
To export an existing model from BigQuery ML to
Cloud Storage, use the
For more information about supported model types, formats, and limitations, see Export models.
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.
The following is the syntax of
EXPORT MODEL for a regular model that is not generated from BigQuery ML hyperparameter tuning.
EXPORT MODEL MODEL_NAME [OPTIONS(URI = STRING_VALUE)]
MODEL_NAMEis the name of the BigQuery ML model you're exporting. If you are exporting a model in another project, you must specify the project, dataset, and model in the following format, including backticks:
If the model name does not exist in the dataset, the following error is returned:
Error: Not found: Model myproject:mydataset.mymodel
STRING_VALUEis the URI of a Cloud Storage bucket where the model is exported. This option is required for the
EXPORT MODELstatement. For example:
URI = 'gs://bucket/path/to/saved_model/'
For a model that is generated from BigQuery ML hyperparameter tuning,
EXPORT MODEL can also export an individual trial to a destination URI. For example:
EXPORT MODEL MODEL_NAME [OPTIONS(URI = STRING_VALUE [, TRIAL_ID = INT_VALUE])]
INT_VALUEis the numeric ID of the exporting trial. For example:
```sql TRIAL_ID = 12 ```
TRIAL_IDis not specified, then the optimal trial is exported by default.