-
Notifications
You must be signed in to change notification settings - Fork 1.2k
/
CreateTable.cs
38 lines (36 loc) · 1.27 KB
/
CreateTable.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
// 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_create_table]
using Google.Cloud.BigQuery.V2;
public class BigQueryCreateTable
{
public BigQueryTable CreateTable(
string projectId = "your-project-id",
string datasetId = "your_dataset_id"
)
{
BigQueryClient client = BigQueryClient.Create(projectId);
var dataset = client.GetDataset(datasetId);
// Create schema for new table.
var schema = new TableSchemaBuilder
{
{ "full_name", BigQueryDbType.String },
{ "age", BigQueryDbType.Int64 }
}.Build();
// Create the table
return dataset.CreateTable(tableId: "your_table_id", schema: schema);
}
}
// [END bigquery_create_table]