列出数据集

 using Google.Cloud.BigQuery.V2; using System; using System.Collections.Generic; using System.Linq;  public class BigQueryListDatasets {     public void ListDatasets(         string projectId = "your-project-id"     )     {         BigQueryClient client = BigQueryClient.Create(projectId);         // Retrieve list of datasets in project         List<BigQueryDataset> datasets = client.ListDatasets().ToList();         // Display the results         if (datasets.Count > 0)         {             Console.WriteLine($"Datasets in project {projectId}:");             foreach (var dataset in datasets)             {                 Console.WriteLine($"\t{dataset.Reference.DatasetId}");             }         }         else         {             Console.WriteLine($"{projectId} does not contain any datasets.");         }     } }

import ( 	"context" 	"fmt" 	"io"  	"cloud.google.com/go/bigquery" 	"google.golang.org/api/iterator" )  // listDatasets demonstrates iterating through the collection of datasets in a project. func listDatasets(projectID string, w io.Writer) error { 	// projectID := "my-project-id" 	ctx := context.Background() 	client, err := bigquery.NewClient(ctx, projectID) 	if err != nil { 		return fmt.Errorf("bigquery.NewClient: %v", err) 	} 	defer client.Close()  	it := client.Datasets(ctx) 	for { 		dataset, err := it.Next() 		if err == iterator.Done { 			break 		} 		if err != nil { 			return err 		} 		fmt.Fprintln(w, dataset.DatasetID) 	} 	return nil } 

import com.google.api.gax.paging.Page; import com.google.cloud.bigquery.BigQuery; import com.google.cloud.bigquery.BigQuery.DatasetListOption; import com.google.cloud.bigquery.BigQueryException; import com.google.cloud.bigquery.BigQueryOptions; import com.google.cloud.bigquery.Dataset;  public class ListDatasets {    public static void runListDatasets() {     // TODO(developer): Replace these variables before running the sample.     String projectId = "MY_PROJECT_ID";     listDatasets(projectId);   }    public static void listDatasets(String projectId) {     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();        Page<Dataset> datasets = bigquery.listDatasets(projectId, DatasetListOption.pageSize(100));       if (datasets == null) {         System.out.println("Dataset does not contain any models");         return;       }       datasets           .iterateAll()           .forEach(               dataset -> System.out.printf("Success! Dataset ID: %s ", dataset.getDatasetId()));     } catch (BigQueryException e) {       System.out.println("Project does not contain any datasets \n" + e.toString());     }   } }

// Import the Google Cloud client library const {BigQuery} = require('@google-cloud/bigquery'); const bigquery = new BigQuery();  async function listDatasets() {   /**    * TODO(developer): Uncomment the following lines before running the sample.    */   // const projectId = "my_project_id";    // Lists all datasets in the specified project.   // If projectId is not specified, this method will take   // the projectId from the authenticated BigQuery Client.   const [datasets] = await bigquery.getDatasets({projectId});   console.log('Datasets:');   datasets.forEach(dataset => console.log(dataset.id)); }

use Google\Cloud\BigQuery\BigQueryClient;  /** Uncomment and populate these variables in your code */ // $projectId  = 'The Google project ID';  $bigQuery = new BigQueryClient([     'projectId' => $projectId, ]); $datasets = $bigQuery->datasets(); foreach ($datasets as $dataset) {     print($dataset->id() . PHP_EOL); }

 from google.cloud import bigquery  # Construct a BigQuery client object. client = bigquery.Client()  datasets = list(client.list_datasets())  # Make an API request. project = client.project  if datasets:     print("Datasets in project {}:".format(project))     for dataset in datasets:         print("\t{}".format(dataset.dataset_id)) else:     print("{} project does not contain any datasets.".format(project))

require "google/cloud/bigquery"  def list_datasets project_id = "your-project-id"   bigquery = Google::Cloud::Bigquery.new project: project_id    puts "Datasets in project #{project_id}:"   bigquery.datasets.each do |dataset|     puts "\t#{dataset.dataset_id}"   end end

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. func printDatasetInfo(w io.Writer, projectID, datasetID string) error { 	// projectID := "my-project-id" 	// datasetID := "mydataset" 	ctx := context.Background() 	client, err := bigquery.NewClient(ctx, projectID) 	if err != nil { 		return fmt.Errorf("bigquery.NewClient: %v", err) 	} 	defer client.Close()  	meta, err := client.Dataset(datasetID).Metadata(ctx) 	if err != nil { 		return err 	}  	fmt.Fprintf(w, "Dataset ID: %s\n", datasetID) 	fmt.Fprintf(w, "Description: %s\n", meta.Description) 	fmt.Fprintln(w, "Labels:") 	for k, v := range meta.Labels { 		fmt.Fprintf(w, "\t%s: %s", k, v) 	} 	fmt.Fprintln(w, "Tables:") 	it := client.Dataset(datasetID).Tables(ctx)  	cnt := 0 	for { 		t, err := it.Next() 		if err == iterator.Done { 			break 		} 		cnt++ 		fmt.Fprintf(w, "\t%s\n", t.TableID) 	} 	if cnt == 0 { 		fmt.Fprintln(w, "\tThis dataset does not contain any tables.") 	} 	return nil } 

import com.google.api.gax.paging.Page; import com.google.cloud.bigquery.BigQuery; import com.google.cloud.bigquery.BigQuery.TableListOption; import com.google.cloud.bigquery.BigQueryException; import com.google.cloud.bigquery.BigQueryOptions; import com.google.cloud.bigquery.Dataset; import com.google.cloud.bigquery.DatasetId; import com.google.cloud.bigquery.Table;  public class GetDatasetInfo {    public static void runGetDatasetInfo() {     // TODO(developer): Replace these variables before running the sample.     String projectId = "MY_PROJECT_ID";     String datasetName = "MY_DATASET_NAME";     getDatasetInfo(projectId, datasetName);   }    public static void getDatasetInfo(String projectId, String datasetName) {     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();       DatasetId datasetId = DatasetId.of(projectId, datasetName);       Dataset dataset = bigquery.getDataset(datasetId);        // View dataset properties       String description = 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.html       Page<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 (BigQueryException e) {       System.out.println("Dataset info not retrieved. \n" + e.toString());     }   } }

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

 from google.cloud import 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.  full_dataset_id = "{}.{}".format(dataset.project, dataset.dataset_id) friendly_name = dataset.friendly_name print(     "Got dataset '{}' with friendly_name '{}'.".format(         full_dataset_id, friendly_name     ) )  # View dataset properties. print("Description: {}".format(dataset.description)) print("Labels:") labels = dataset.labels if labels:     for label, value in labels.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). if tables:     for table in tables:         print("\t{}".format(table.table_id)) else:     print("\tThis dataset does not contain any tables.")