Viewing labels

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 labels
publicclass GetDatasetLabels{
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.
BigQuery bigquery=BigQueryOptions .getDefaultInstance().getService();
Dataset dataset=bigquery.getDataset (datasetName);
dataset
.getLabels()
.forEach((key,value)->System.out.println("Retrieved labels successfully"));
}catch(BigQueryException e){
System.out.println("Label was not found. \n"+e.toString());
}
}
}

// Import the Google Cloud client library
const{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.cloudimport bigquery
# 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:")
if dataset.labels:
 for label, value in dataset.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 labels
publicclass GetTableLabels{
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.
BigQuery bigquery=BigQueryOptions .getDefaultInstance().getService();
// This example table starts with existing label { color: 'green' }
Table table=bigquery.getTable (TableId.of(datasetName,tableName));
table
.getLabels()
.forEach((key,value)->System.out.println("Retrieved labels successfully"));
}catch(BigQueryException e){
System.out.println("Label was not deleted. \n"+e.toString());
}
}
}

// Import the Google Cloud client library
const{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.cloudimport bigquery
client = 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 labels
print(f"Table ID: {table_id}.")
if table.labels:
 for label, value in table.labels.items ():
 print(f"\t{label}: {value }")
else:
 print("\tTable has no labels defined.")