使用Google BigQuery Python库创建或替换表

from google.cloud import bigquery

# 创建BigQuery客户端
client = bigquery.Client()

# 定义表的模式
schema = [
    bigquery.SchemaField("column1", "STRING", mode="REQUIRED"),
    bigquery.SchemaField("column2", "INTEGER", mode="NULLABLE"),
    bigquery.SchemaField("column3", "FLOAT", mode="NULLABLE")
]

# 定义表的选项
table_options = bigquery.TableOptions(
    time_partitioning=bigquery.TimePartitioning(field="column2"),
    clustering_fields=["column3"]
)

# 定义表的属性
table = bigquery.Table(
    "project_id.dataset.table_name",
    schema=schema,
    table_options=table_options
)

# 创建或替换表
table = client.create_table(table, exists_ok=True)

print("表已创建或替换成功：{}".format(table.table_id))