在使用selected_fields的Bigquery API Python中列出行时不匹配的字段

from google.cloud import bigquery

def list_rows_with_mismatched_fields():
    # 设置BigQuery客户端
    client = bigquery.Client()

    # 构建查询语句
    query = """
        SELECT *
        FROM `project.dataset.table`
    """

    # 指定需要返回的字段
    selected_fields = ["field1", "field2", "field3"]

    # 执行查询并获取结果集
    query_job = client.query(query)
    results = query_job.result()

    # 遍历每一行数据
    for row in results:
        # 检查每个字段是否匹配预期
        for field in selected_fields:
            if field not in row.keys():
                print(f"Field '{field}' is missing in the row.")

# 调用函数进行测试
list_rows_with_mismatched_fields()