The EXPORT MODEL statement

Overview

To export an existing model from BigQuery ML to Cloud Storage, use the EXPORT MODEL statement.

For more information about supported model types, formats, and limitations, see Exporting models.

Syntax

EXPORT MODEL MODEL_NAME [OPTIONS(URI = STRING_VALUE)]

  • MODEL_NAME is 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:

    `PROJECT.DATASET.MODEL`

    For example, `myproject.mydataset.mymodel`.

    If the model name does not exist in the dataset, the following error is returned:

    Error: Not found: Model myproject:mydataset.mymodel

  • STRING_VALUE is the URI of a Cloud Storage bucket where the model is exported. This option is required for the EXPORT MODEL statement. For example:

    URI = 'gs://bucket/path/to/saved_model/'