使用Python客户端将CSV追加到BigQuery表

from google.cloud import bigquery

client = bigquery.Client()

dataset_id = 'your_dataset_id'
table_id = 'your_table_id'
filename = 'path_to_csv_file.csv'

schema = [
    bigquery.SchemaField('column1', 'STRING'),
    bigquery.SchemaField('column2', 'INTEGER'),
    bigquery.SchemaField('column3', 'FLOAT'),
    # 添加其他列的定义
]

table_ref = client.dataset(dataset_id).table(table_id)
table = bigquery.Table(table_ref, schema=schema)
table = client.create_table(table)

with open(filename, 'rb') as source_file:
    job_config = bigquery.LoadJobConfig()
    job_config.source_format = bigquery.SourceFormat.CSV
    job_config.skip_leading_rows = 1
    job_config.schema = schema
    job = client.load_table_from_file(source_file, table_ref, job_config=job_config)

job.result()