-
Notifications
You must be signed in to change notification settings - Fork 1.2k
/
ExtractTableJson.cs
43 lines (41 loc) · 1.55 KB
/
ExtractTableJson.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
// Copyright(c) 2018 Google LLC
//
// Licensed under the Apache License, Version 2.0 (the "License"); you may not
// use this file except in compliance with the License. You may obtain a copy of
// the License at
//
// http://www.apache.org/licenses/LICENSE-2.0
//
// Unless required by applicable law or agreed to in writing, software
// distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
// WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
// License for the specific language governing permissions and limitations under
// the License.
//
// [START bigquery_extract_table_json]
using Google.Cloud.BigQuery.V2;
using System;
public class BigQueryExtractTableJson
{
public void ExtractTableJson(
string projectId = "your-project-id",
string bucketName = "your-bucket-name")
{
BigQueryClient client = BigQueryClient.Create(projectId);
string destinationUri = $"gs://{bucketName}/shakespeare.json";
var jobOptions = new CreateExtractJobOptions()
{
DestinationFormat = FileFormat.NewlineDelimitedJson
};
BigQueryJob job = client.CreateExtractJob(
projectId: "bigquery-public-data",
datasetId: "samples",
tableId: "shakespeare",
destinationUri: destinationUri,
options: jobOptions
);
job = job.PollUntilCompleted().ThrowOnAnyError(); // Waits for the job to complete.
Console.Write($"Exported table to {destinationUri}.");
}
}
// [END bigquery_extract_table_json]