【Python】ローカルPythonからBigQueryを操作する

//pip
pip install google-cloud-bigquery

//conda
conda install -c conda-forge google-cloud-bigquery

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

import pandas as pd


# ダウンロードした認証ファイル（.json）のフルパスを指定
key_path = "Path/to/secret_key.json"
credentials = service_account.Credentials.from_service_account_file(key_path, scopes=["https://www.googleapis.com/auth/cloud-platform"])
client = bigquery.Client(credentials=credentials, project=credentials.project_id)

#実行クエリ
query = """
        -- This query shows a list of the daily top Google Search terms.
        -- These search terms are in the top 25 in the US each day.
        SELECT
            refresh_date AS Day
            , term AS Top_Term                          
            , rank 
        FROM
            `bigquery-public-data.google_trends.top_terms` 
        WHERE
            -- Choose only the top term each day.
            rank = 1                                
            -- Filter to the last 2 weeks.
            AND refresh_date >= DATE_SUB(CURRENT_DATE (), INTERVAL 2 WEEK) 
        GROUP BY
            Day
            , Top_Term
            , rank 
        ORDER BY
            Day DESC                                    
    """

#ジョブ実行
query_job = client.query(query)  # Make an API request.

#データフレームに格納
df = (query_job
      .result()
      .to_dataframe()
    )

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

import pandas as pd

# ダウンロードした認証ファイル（.json）のフルパスを指定
key_path = "Path/to/secret_key.json"
credentials = service_account.Credentials.from_service_account_file(key_path, scopes=["https://www.googleapis.com/auth/cloud-platform"])
client = bigquery.Client(credentials=credentials, project=credentials.project_id)

#実行クエリ
query = """
        -- This query shows a list of the daily top Google Search terms.
        -- These search terms are in the top 25 in the US each day.
        SELECT
            refresh_date AS Day
            , term AS Top_Term                          
            , rank 
        FROM
            `bigquery-public-data.google_trends.top_terms` 
        WHERE
            -- Choose only the top term each day.
            rank = 1                                
            -- Filter to the last 2 weeks.
            AND refresh_date >= DATE_SUB(CURRENT_DATE (), INTERVAL 2 WEEK) 
        GROUP BY
            Day
            , Top_Term
            , rank 
        ORDER BY
            Day DESC                                    
    """

#ジョブ実行
query_job = client.query(query)  # Make an API request.

#データフレームに格納
df = (query_job
      .result()
      .to_dataframe()
    )