bq-py-authentication.py

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

credentials = service_account.Credentials.from_service_account_file('FILE PATH JSON')

project_id = 'PROJECT ID' 

client = bigquery.Client(credentials = credentials, project = project_id)  

# Example querying 
dataset_ref = client.dataset("hacker_news", project="bigquery-public-data") 

# API request - fetch the dataset 
dataset = client.get_dataset(dataset_ref)  

# List all the tables in the "hacker_news" dataset 
tables = list(client.list_tables(dataset)) 

# Print names of all tables in the dataset (there are four!) 
for table in tables: 
    print(table.table_id)