使用 BigQuery Python 客户端

安装客户端库

?

1	pip install google-cloud-bigquery

示例代码

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

from google.cloud import bigquery   # 初始化客户端 client = bigquery.Client()   # 表引用 table_ref = client.dataset('dataset_id').table('table_id')   # 获取当前表结构 table = client.get_table(table_ref) original_schema = table.schema   # 添加新列 new_schema = original_schema[:]  # 复制当前表结构 new_schema.append(bigquery.SchemaField("new_column_name", "STRING"))   # 更新表结构 table.schema = new_schema table = client.update_table(table, ["schema"])   print(f"表结构已更新: {table.schema}")