Connect to Google BigQuery using a Google Cloud service account

bq-auth-with-service-account.py

import os
from google.cloud import bigquery

# Set this to the path to your credentials file
os.environ[
    'GOOGLE_APPLICATION_CREDENTIALS'] = 'drd-cloud-sandbox-e21f6cf4f15b.json'


def main():
    # Instantiate a Google BigQuery client
    client = bigquery.Client()

    # Create a query job
    query_job = client.query("""
        SELECT 1 AS result""")

    # Run the query and retrieve results
    results = query_job.result()

    for row in results:
        print(row.result)


if __name__ == '__main__':
    main()