BigQuery列出专案中的所有资料集 [英] BigQuery list all datasets within project

问题描述

我目前正在尝试通过从BigQuery动态查询所需的表来在C#中构造查询.我发现了一种查询项目并在其中获取所有数据集的方法，但是在使它正常工作方面花费了很多时间.

I'm currently trying to construct a query within C# by dynamically querying the tables I need from BigQuery. I found out about a way you can query the project and get all datasets within it but am having a rough time getting it working.

static public List<BigQueryDataset> ListDatasets(BigQueryClient client)
{
    var datasets = client.ListDatasets().ToList();
    return datasets;
}

object datasets = ListDatasets(client);

数据集包含 Google.Cloud.BigQuery.V2.BigQueryDataset 的列表/枚举.我不知道如何从中获取数据集的实际名称.我是C#的新手，甚至是BigQuery的新手，所以任何帮助都将是很棒的.谢谢！

datasets contains a list/enum of Google.Cloud.BigQuery.V2.BigQueryDataset. I do not know how to get the actual name of the dataset out of this. I'm extremely new to C# and even newer to BigQuery so any help at all would be great. Thanks!

推荐答案

类似以下内容:

[..]
List<BigQueryDataset> datasets = client.ListDatasets().Take(20).ToList();
foreach (BigQueryDataset dataset in datasets){
   Console.WriteLine(dataset.FullyQualifiedId);
}
[..]

查看更多摘录此处.

这篇关于BigQuery列出专案中的所有资料集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！