Connect to GBQ using pandas_gbq

PHOTO EMBED

Sun Aug 22 2021 18:42:28 GMT+0000 (Coordinated Universal Time)

Saved by @jmbenedetto #python

import pandas as pd
from google.oauth2 import service_account
import pandas_gbq
import logging

logger = logging.getLogger("pandas_gbq")
logger.setLevel(logging.DEBUG)
logger.addHandler(logging.StreamHandler())

project_id = "analytics-dev-308300"

credentials = service_account.Credentials.from_service_account_file(
    "../keys/gcp_key.json",
)

pd.read_gbq(query=query, credentials=credentials, project_id=project_id)
content_copyCOPY