在BigQuery select语句中动态包含所有可用的自定义维度

# 导入必要的库
from google.cloud import bigquery

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

# 获取所有可用的自定义维度
query = """
SELECT dimension_name
FROM `project.dataset.__TABLES__`
WHERE table_id = 'your_table_id' AND dimension_name LIKE 'custom_dimension_%'
"""

# 执行查询
query_job = client.query(query)
results = query_job.result()

# 构建动态SQL查询语句
select_statement = "SELECT "
for row in results:
    dimension_name = row.dimension_name
    select_statement += f"{dimension_name}, "

# 去除最后一个逗号
select_statement = select_statement[:-2]

# 添加其他查询部分
select_statement += " FROM `project.dataset.your_table_id`"

# 执行动态生成的SELECT语句
query_job = client.query(select_statement)
results = query_job.result()

# 处理查询结果
for row in results:
    # 处理每一行的数据
    pass