import("context""fmt""io""cloud.google.com/go/bigquery""google.golang.org/api/iterator")// printDatasetInfo demonstrates fetching dataset metadata and printing some of it to an io.Writer.funcprintDatasetInfo(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: %w",err)}deferclient.Close()meta,err:=client.Dataset(datasetID).Metadata(ctx)iferr!=nil{returnerr}fmt.Fprintf(w,"Dataset ID: %s\n",datasetID)fmt.Fprintf(w,"Description: %s\n",meta.Description)fmt.Fprintln(w,"Labels:")fork,v:=rangemeta.Labels{fmt.Fprintf(w,"\t%s: %s",k,v)}fmt.Fprintln(w,"Tables:")it:=client.Dataset(datasetID).Tables(ctx)cnt:=0for{t,err:=it.Next()iferr==iterator.Done{break}cnt++fmt.Fprintf(w,"\t%s\n",t.TableID)}ifcnt==0{fmt.Fprintln(w,"\tThis dataset does not contain any tables.")}returnnil}

importcom.google.api.gax.paging.Page;importcom.google.cloud.bigquery.BigQuery;importcom.google.cloud.bigquery.BigQuery.TableListOption;importcom.google.cloud.bigquery.BigQueryException;importcom.google.cloud.bigquery.BigQueryOptions;importcom.google.cloud.bigquery.Dataset;importcom.google.cloud.bigquery.DatasetId;importcom.google.cloud.bigquery.Table;publicclassGetDatasetInfo{publicstaticvoidmain(String[]args){// TODO(developer): Replace these variables before running the sample.StringprojectId="MY_PROJECT_ID";StringdatasetName="MY_DATASET_NAME";getDatasetInfo(projectId,datasetName);}publicstaticvoidgetDatasetInfo(StringprojectId,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();DatasetIddatasetId=DatasetId.of(projectId,datasetName);Datasetdataset=bigquery.getDataset(datasetId);// View dataset propertiesStringdescription=dataset.getDescription();System.out.println(description);// View tables in the dataset// For more information on listing tables see:// https://javadoc.io/static/com.google.cloud/google-cloud-bigquery/0.22.0-beta/com/google/cloud/bigquery/BigQuery.htmlPage<Table>tables=bigquery.listTables(datasetName,TableListOption.pageSize(100));tables.iterateAll().forEach(table->System.out.print(table.getTableId().getTable()+"\n"));System.out.println("Dataset info retrieved successfully.");}catch(BigQueryExceptione){System.out.println("Dataset info not retrieved. \n"+e.toString());}}}

// Import the Google Cloud client libraryconst{BigQuery}=require('@google-cloud/bigquery');constbigquery=newBigQuery();asyncfunctiongetDataset(){// Retrieves dataset named "my_dataset"./**   * TODO(developer): Uncomment the following lines before running the sample   */// const datasetId = "my_dataset";// Retrieve dataset referenceconst[dataset]=awaitbigquery.dataset(datasetId).get();console.log('Dataset:');console.log(dataset.metadata.datasetReference);}getDataset();

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.full_dataset_id="{}.{}".format(dataset.project,dataset.dataset_id)friendly_name=dataset.friendly_nameprint("Got dataset '{}' with friendly_name '{}'.".format(full_dataset_id,friendly_name))# View dataset properties.print("Description:{}".format(dataset.description))print("Labels:")labels=dataset.labelsiflabels:forlabel,valueinlabels.items():print("\t{}:{}".format(label,value))else:print("\tDataset has no labels defined.")# View tables in dataset.print("Tables:")tables=list(client.list_tables(dataset))# Make an API request(s).iftables:fortableintables:print("\t{}".format(table.table_id))else:print("\tThis dataset does not contain any tables.")