在Bigquery中使用Python API创建一个表并查询该表的值

from google.cloud import bigquery

client = bigquery.Client()

schema = [
    bigquery.SchemaField("column1", "STRING"),
    bigquery.SchemaField("column2", "INTEGER"),
    bigquery.SchemaField("column3", "FLOAT"),
]

table_ref = client.dataset("dataset_name").table("table_name")
table = bigquery.Table(table_ref, schema=schema)

table = client.create_table(table)

rows = [
    ("value1", 1, 1.1),
    ("value2", 2, 2.2),
    ("value3", 3, 3.3),
]
errors = client.insert_rows(table, rows)
if errors == []:
    print("插入数据成功")
else:
    print("插入数据时发生错误")

query = """
    SELECT *
    FROM `project_name.dataset_name.table_name`
"""
query_job = client.query(query)
results = query_job.result()

for row in results:
    print(row)