使用Python计算BigQuery表中的行数

from google.cloud import bigquery
from google.oauth2 import service_account

credentials = service_account.Credentials.from_service_account_file('path/to/credentials.json')
client = bigquery.Client(project='your-project-id', credentials=credentials)

table_ref = client.dataset('your-dataset-id').table('your-table-id')

query = f"SELECT COUNT(*) FROM `{table_ref}`"

query_job = client.query(query)
result = query_job.result()
row_count = list(result)[0][0]

print(f"行数：{row_count}")