Skip to main content

models

Overview

Namemodels
TypeResource
Idgoogle.bigquery.models

Fields

NameDatatypeDescription
descriptionstringOptional. A user-friendly description of this model.
locationstringOutput only. The geographic location where the model resides. This value is inherited from the dataset.
modelTypestringOutput only. Type of the model resource.
transformColumnsarrayOutput only. This field will be populated if a TRANSFORM clause was used to train a model. TRANSFORM clause (if used) takes feature_columns as input and outputs transform_columns. transform_columns then are used to train the model.
encryptionConfigurationobject
trainingRunsarrayInformation for all training runs in increasing order of start_time.
labelColumnsarrayOutput only. Label columns that were used to train this model. The output of the model will have a "predicted_" prefix to these columns.
expirationTimestringOptional. The time when this model expires, in milliseconds since the epoch. If not present, the model will persist indefinitely. Expired models will be deleted and their storage reclaimed. The defaultTableExpirationMs property of the encapsulating dataset can be used to set a default expirationTime on newly created models.
hparamTrialsarrayOutput only. Trials of a hyperparameter tuning model sorted by trial_id.
labelsobjectThe labels associated with this model. You can use these to organize and group your models. Label keys and values can be no longer than 63 characters, can only contain lowercase letters, numeric characters, underscores and dashes. International characters are allowed. Label values are optional. Label keys must start with a letter and each label in the list must have a different key.
remoteModelInfoobjectRemote Model Info
hparamSearchSpacesobjectHyperparameter search spaces. These should be a subset of training_options.
lastModifiedTimestringOutput only. The time when this model was last modified, in millisecs since the epoch.
friendlyNamestringOptional. A descriptive name for this model.
bestTrialIdstringThe best trial_id across all training runs.
featureColumnsarrayOutput only. Input feature columns for the model inference. If the model is trained with TRANSFORM clause, these are the input of the TRANSFORM clause.
creationTimestringOutput only. The time when this model was created, in millisecs since the epoch.
etagstringOutput only. A hash of this resource.
optimalTrialIdsarrayOutput only. For single-objective hyperparameter tuning models, it only contains the best trial. For multi-objective hyperparameter tuning models, it contains all Pareto optimal trials sorted by trial_id.
defaultTrialIdstringOutput only. The default trial_id to use in TVFs when the trial_id is not passed in. For single-objective hyperparameter tuning models, this is the best trial ID. For multi-objective hyperparameter tuning models, this is the smallest trial ID among all Pareto optimal trials.
modelReferenceobject

Methods

NameAccessible byRequired ParamsDescription
getSELECT+datasetId, +modelId, projectIdGets the specified model resource by model ID.
listSELECT+datasetId, projectIdLists all models in the specified dataset. Requires the READER dataset role. After retrieving the list of models, you can get information about a particular model by calling the models.get method.
deleteDELETE+datasetId, +modelId, projectIdDeletes the model specified by modelId from the dataset.
_listEXEC+datasetId, projectIdLists all models in the specified dataset. Requires the READER dataset role. After retrieving the list of models, you can get information about a particular model by calling the models.get method.
patchEXEC+datasetId, +modelId, projectIdPatch specific fields in the specified model.