Google BigQuery with C# sample example

Question

我需要使用Google BigQuery API查询数据，使用服务帐户调用。

然而，我很难找到.NET示例，而且二进制文件（Google.Apis.Bigquery.dll）中没有文档。有人能为我提供C#的示例用法吗？

Answer 1

此信息来自：用于.NET 的Google API客户端库

该示例展示了如何使用Google+api的服务帐户。我对它进行了一些编辑，以便与BigQuery一起使用。

using System;
using Google.Apis.Auth.OAuth2;
using System.Security.Cryptography.X509Certificates;
using Google.Apis.Bigquery.v2;
using Google.Apis.Services;
//Install-Package Google.Apis.Bigquery.v2
namespace GoogleBigQueryServiceAccount
{
class Program
{
    private static String ACTIVITY_ID = "z12gtjhq3qn2xxl2o224exwiqruvtda0i";
    static void Main(string[] args)
    {
        Console.WriteLine("BigQuery API - Service Account");
        Console.WriteLine("==========================");
        String serviceAccountEmail = "SERVICE_ACCOUNT_EMAIL_HERE";
        var certificate = new X509Certificate2(@"key.p12", "notasecret", X509KeyStorageFlags.Exportable);
        ServiceAccountCredential credential = new ServiceAccountCredential(
           new ServiceAccountCredential.Initializer(serviceAccountEmail)
           {
               Scopes = new[] { BigqueryService.Scope.DevstorageReadOnly }
           }.FromCertificate(certificate));
        // Create the service.
        var service = new BigqueryService(new BaseClientService.Initializer()
        {
            HttpClientInitializer = credential,
            ApplicationName = "BigQuery API Sample",
        });
        //Note: all your requests will run against Service.
    }
}

}