bigquery_create_table_with_schema_definition.py

1from google.cloud import bigquery
2
3# Construct a BigQuery client object.
4client = bigquery.Client()
5
6# TODO(developer): Set table_id to the ID of the table to create.
7# table_id = "your-project.your_dataset.your_table_name"
8
9schema = [
10    bigquery.SchemaField("full_name", "STRING", mode="REQUIRED"),
11    bigquery.SchemaField("age", "INTEGER", mode="REQUIRED"),
12]
13
14table = bigquery.Table(table_id, schema=schema)
15table = client.create_table(table)  # Make an API request.
16print(
17    "Created table {}.{}.{}".format(table.project, table.dataset_id, table.table_id)
18)