pip install --upgrade google-cloud-bigquery
from google.cloud import bigquery
client = bigquery.Client()
query = (
"SELECT * FROM `<project>.<dataset>.<table>` "
"LIMIT 100"
)
query_job = client.query(query)
for row in query_job: # API request - fetches results
print(row)