如何从BigQuery读取google-cloud-storage文件的元数据

from google.cloud import bigquery
from google.cloud import storage

# 初始化BigQuery客户端
bq_client = bigquery.Client()

# 定义GCS桶名和文件路径
bucket_name = 'your-bucket-name'
file_path = 'path/to/your/file.csv'

# 构建外部数据源URI
uri = f'gs://{bucket_name}/{file_path}'

# 创建一个外部数据源查询
query = f"""
    SELECT *
    FROM `{bq_client.project}.{bq_client.dataset_id}.your_table`
    WHERE _FILE_NAME = '{file_path}'
"""

# 执行查询
query_job = bq_client.query(query)

# 获取查询结果
results = query_job.result()  # 等待查询完成

# 打印结果
for row in results:
    print(row)

# 如果需要获取文件的元数据，可以直接使用GCS客户端
storage_client = storage.Client()
bucket = storage_client.bucket(bucket_name)
blob = bucket.blob(file_path)

# 打印GCS文件的元数据
print(f"Size: {blob.size} bytes")
print(f"Created: {blob.time_created}")
print(f"Updated: {blob.updated}")