bigquery_python_client_public_dataset_query_quickstart.py

1from google.cloud import bigquery
2
3# Construct a BigQuery client object.
4client = bigquery.Client()
5
6query = """
7    SELECT name, SUM(number) as total_people
8    FROM `bigquery-public-data.usa_names.usa_1910_2013`
9    WHERE state = 'TX'
10    GROUP BY name
11    ORDER BY total_people DESC
12    LIMIT 20
13"""
14rows = client.query_and_wait(query)  # API request
15
16print("The query data:")
17for row in rows:
18    # Row values can be accessed by field name or index.
19    print(f"name={row[0]}, count={row['total_people']}")