Console

1. In the Google Cloud console, go to the BigQuery page.

   Go to the BigQuery page

2. In the left pane, clickexploreExplorer:

   

   If you don't see the left pane, clicklast_pageExpand left pane to open the pane.

3. In theExplorer pane, expand your project, clickDatasets, andthen click the dataset.

4. Click theModels tab, and then click a model nameto select the model.

5. Click theDetails tab.

6. To update the model's description, clickEditedit.

7. In theEdit detail dialog, update the description and thenclickSave.

bq

To update a model's description, issue thebq update command with the--model or-m flag and the--description flag.

If you are updating a model in a project other than your default project,add the project ID to the dataset in the following format:[PROJECT_ID]:[DATASET].

bq update --model --description "[STRING]"PROJECT_ID:DATASET.MODEL

Replace the following:

• STRING is the text string that describes your model in quotes.
• PROJECT_ID is your project ID.
• DATASET is the name of the dataset.
• MODEL is the name of the model.

The command output looks like the following:

Model 'myproject.mydataset.mymodel' successfully updated.

You can confirm your changes by issuing thebq show command. For moreinformation, seeGet model metadata.

Examples:

Enter the following command to update the description ofmymodel inmydataset in your default project.

bq update --model --description "My updated description" \mydataset.mymodel

Enter the following command to update the description ofmymodel inmydataset inmyotherproject.

bq update --model --description "My updated description" \myotherproject:mydataset.mymodel

API

To update a model's description by using the API, call themodels.patchmethod and provide theprojectId,datasetId, andmodelId. To modifythe description, add to or update the "description" property for themodel resource.

Go

import("context""fmt""cloud.google.com/go/bigquery")// updateModelDescription demonstrates fetching BigQuery ML model metadata and updating the// Description metadata.funcupdateModelDescription(projectID,datasetID,modelIDstring)error{// projectID := "my-project-id"// datasetID := "mydataset"// modelID := "mymodel"ctx:=context.Background()client,err:=bigquery.NewClient(ctx,projectID)iferr!=nil{returnfmt.Errorf("bigquery.NewClient: %w",err)}deferclient.Close()model:=client.Dataset(datasetID).Model(modelID)oldMeta,err:=model.Metadata(ctx)iferr!=nil{returnfmt.Errorf("couldn't retrieve model metadata: %w",err)}update:=bigquery.ModelMetadataToUpdate{Description:"This model was modified from a Go program",}if_,err=model.Update(ctx,update,oldMeta.ETag);err!=nil{returnfmt.Errorf("couldn't update model: %w",err)}returnnil}

Java

importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.Model;importcom.google.cloud.bigquery.ModelId;// Sample to update description on a modelpublicclassUpdateModelDescription{publicstaticvoidrunUpdateModelDescription(){// TODO(developer): Replace these variables before running the sample.StringdatasetName="MY_DATASET_NAME";StringmodelName="MY_MODEL_NAME";StringnewDescription="A really great model.";updateModelDescription(datasetName,modelName,newDescription);}publicstaticvoidupdateModelDescription(StringdatasetName,StringmodelName,StringnewDescription){try{// Initialize client that will be used to send requests. This client only needs to be created// once, and can be reused for multiple requests.BigQuerybigquery=BigQueryOptions.getDefaultInstance().getService();Modelmodel=bigquery.getModel(ModelId.of(datasetName,modelName));bigquery.update(model.toBuilder().setDescription(newDescription).build());System.out.println("Model description updated successfully to "+newDescription);}catch(BigQueryExceptione){System.out.println("Model description was not updated \n"+e.toString());}}}

Node.js

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctionupdateModel(){// Updates a model's metadata./**   * TODO(developer): Uncomment the following lines before running the sample   */// const datasetId = "my_dataset";// const modelId = "my__model";constmetadata={description:'A really great model.',};constdataset=bigquery.dataset(datasetId);const[apiResponse]=awaitdataset.model(modelId).setMetadata(metadata);constnewDescription=apiResponse.description;console.log(`${modelId} description:${newDescription}`);}

Python

fromgoogle.cloudimportbigquery# Construct a BigQuery client object.client=bigquery.Client()# TODO(developer): Set model_id to the ID of the model to fetch.# model_id = 'your-project.your_dataset.your_model'model=client.get_model(model_id)# Make an API request.model.description="This model was modified from a Python program."model=client.update_model(model,["description"])# Make an API request.full_model_id="{}.{}.{}".format(model.project,model.dataset_id,model.model_id)print("Updated model '{}' with description '{}'.".format(full_model_id,model.description))

Console

1. In the left pane, clickexploreExplorer:

   

2. In theExplorer pane, expand your project, clickDatasets, andthen click the dataset.

3. Click theModels tab, and then click a model nameto select the model.

4. Click theDetails tab.

5. To update the model's labels, clickEditedit.

6. In theEdit detail dialog, add, delete, or modify labels, and thenclickSave.

bq

To update a model's labels, issue thebq update command with the--model or-m flag and the--set_label flag. Repeat the--set_labelflag to add or update multiple labels.

If you are updating a model in a project other than your default project,add the project ID to the dataset in the following format:[PROJECT_ID]:[DATASET].

bq update --model --set_labelKEY:VALUE \PROJECT_ID:DATASET.MODEL

Replace the following:

• KEY:VALUE corresponds to a key:value pair for a label that you wantto add or update. If you specify the same key as an existing label,the value for the existing label is updated. The key must be unique.
• PROJECT_ID is your project ID.
• DATASET is the name of the dataset.
• MODEL is the name of the model.

The command output looks like the following.

Model 'myproject.mydataset.mymodel' successfully updated.

You can confirm your changes by issuing thebq show command. For moreinformation, seeGet model metadata.

Examples:

To update thedepartment label onmymodel, enter thebq update commandand specifydepartment as the label key. For example, to update thedepartment:shipping label todepartment:logistics, enter the followingcommand.mydataset is inmyotherproject, not your default project.

bq update --model --set_label department:logistics \myotherproject:mydataset.mymodel

API

To update a model's labels by using the API, call themodels.patchmethod and provide theprojectId,datasetId, andmodelId. To modifythe labels, add to or update the "labels" property for themodel resource.

bq update --model --expirationINTEGER \PROJECT_ID:DATASET.MODEL

Model 'myproject.mydataset.mymodel' successfully updated.

You can confirm your changes by issuing thebq show command. For moreinformation, seeGet model metadata.

Examples:

Enter the following command to update the expiration time ofmymodel inmydataset to 5 days (432000 seconds).mydataset is in your defaultproject.

bq update --model --expiration 432000 mydataset.mymodel

Enter the following command to update the expiration time ofmymodel inmydataset to 5 days (432000 seconds).mydataset is inmyotherproject,not your default project.

bq update --model --expiration 432000 myotherproject:mydataset.mymodel

API

To update a model's expiration by using the API, call themodels.patchmethod and provide theprojectId,datasetId, andmodelId. To modifythe expiration, add to or update the "expirationTime" property for themodel resource."expirationTime" is expressed in milliseconds since the epoch.