如何通过Python SDK复制BigQuery视图？

from google.cloud import bigquery

# 设置源视图和目标表的信息
project_id = 'your-project-id'
source_dataset_id = 'your-source-dataset-id'
source_table_id = 'your-source-table-id'
destination_dataset_id = 'your-destination-dataset-id'
destination_table_id = 'your-destination-table-id'

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

# 获取源视图的定义
source_view = client.get_table(f'{project_id}.{source_dataset_id}.{source_table_id}')

# 创建目标表
destination_table = bigquery.Table(f'{project_id}.{destination_dataset_id}.{destination_table_id}')
destination_table.view_query = source_view.view_query

# 将目标表写入BigQuery
client.create_table(destination_table)

pip install google-cloud-bigquery