import("context""fmt""io""cloud.google.com/go/bigquery")// printDatasetLabels retrieves label metadata from a dataset and prints it to an io.Writer.funcprintDatasetLabels(wio.Writer,projectID,datasetIDstring)error{// projectID := "my-project-id"// datasetID := "mydataset"ctx:=context.Background()client,err:=bigquery.NewClient(ctx,projectID)iferr!=nil{returnfmt.Errorf("bigquery.NewClient: %v",err)}deferclient.Close()meta,err:=client.Dataset(datasetID).Metadata(ctx)iferr!=nil{returnerr}fmt.Fprintf(w,"Dataset %s labels:\n",datasetID)iflen(meta.Labels)==0{fmt.Fprintln(w,"Dataset has no labels defined.")returnnil}fork,v:=rangemeta.Labels{fmt.Fprintf(w,"\t%s:%s\n",k,v)}returnnil}

importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.Dataset;// Sample to get dataset labelspublicclassGetDatasetLabels{publicstaticvoidrunGetDatasetLabels(){// TODO(developer): Replace these variables before running the sample.StringdatasetName="MY_DATASET_NAME";getDatasetLabels(datasetName);}publicstaticvoidgetDatasetLabels(StringdatasetName){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();Datasetdataset=bigquery.getDataset(datasetName);dataset.getLabels().forEach((key,value)->System.out.println("Retrieved labels successfully"));}catch(BigQueryExceptione){System.out.println("Label was not found. \n"+e.toString());}}}

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctiongetDatasetLabels(){// Gets labels on a dataset./**   * TODO(developer): Uncomment the following lines before running the sample.   */// const datasetId = "my_dataset";// Retrieve current dataset metadata.constdataset=bigquery.dataset(datasetId);const[metadata]=awaitdataset.getMetadata();constlabels=metadata.labels;console.log(`${datasetId} Labels:`);for(const[key,value]ofObject.entries(labels)){console.log(`${key}:${value}`);}}getDatasetLabels();

fromgoogle.cloudimportbigquery# Construct a BigQuery client object.client=bigquery.Client()# TODO(developer): Set dataset_id to the ID of the dataset to fetch.# dataset_id = "your-project.your_dataset"dataset=client.get_dataset(dataset_id)# Make an API request.# View dataset labels.print("Dataset ID:{}".format(dataset_id))print("Labels:")ifdataset.labels:forlabel,valueindataset.labels.items():print("\t{}:{}".format(label,value))else:print("\tDataset has no labels defined.")

import("context""fmt""io""cloud.google.com/go/bigquery")// tableLabels demonstrates fetching metadata from a table and printing the Label metadata to an io.Writer.functableLabels(wio.Writer,projectID,datasetID,tableIDstring)error{// projectID := "my-project-id"// datasetID := "mydataset"// tableID := "mytable"ctx:=context.Background()client,err:=bigquery.NewClient(ctx,projectID)iferr!=nil{returnfmt.Errorf("bigquery.NewClient: %w",err)}deferclient.Close()meta,err:=client.Dataset(datasetID).Table(tableID).Metadata(ctx)iferr!=nil{returnerr}fmt.Fprintf(w,"Table %s labels:\n",datasetID)iflen(meta.Labels)==0{fmt.Fprintln(w,"Table has no labels defined.")returnnil}fork,v:=rangemeta.Labels{fmt.Fprintf(w,"\t%s:%s\n",k,v)}returnnil}

importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.Table;importcom.google.cloud.bigquery.TableId;// Sample to get table labelspublicclassGetTableLabels{publicstaticvoidmain(String[]args){// TODO(developer): Replace these variables before running the sample.StringdatasetName="MY_DATASET_NAME";StringtableName="MY_TABLE_NAME";getTableLabels(datasetName,tableName);}publicstaticvoidgetTableLabels(StringdatasetName,StringtableName){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();// This example table starts with existing label { color: 'green' }Tabletable=bigquery.getTable(TableId.of(datasetName,tableName));table.getLabels().forEach((key,value)->System.out.println("Retrieved labels successfully"));}catch(BigQueryExceptione){System.out.println("Label was not deleted. \n"+e.toString());}}}

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctiongetTableLabels(){// Gets labels on a dataset./**   * TODO(developer): Uncomment the following lines before running the sample.   */// const datasetId = "my_dataset";// const tableId = "my_table";// Retrieve current dataset metadata.consttable=bigquery.dataset(datasetId).table(tableId);const[metadata]=awaittable.getMetadata();constlabels=metadata.labels;console.log(`${tableId} Labels:`);for(const[key,value]ofObject.entries(labels)){console.log(`${key}:${value}`);}}getTableLabels();

fromgoogle.cloudimportbigqueryclient=bigquery.Client()# TODO(dev): Change table_id to the full name of the table you want to create.table_id="your-project.your_dataset.your_table_name"table=client.get_table(table_id)# API Request# View table labelsprint(f"Table ID:{table_id}.")iftable.labels:forlabel,valueintable.labels.items():print(f"\t{label}:{value}")else:print("\tTable has no labels defined.")