[BQ] Python에서 BigQuery 실행하기

Python Client for Google BigQuery

 

Example Usage

구글 GCS 서비스 계정 json 파일을 사용하여 BigQuery에 쿼리 실행하기

from google.cloud import bigquery

CREDS = 'test_service_account.json'
client = bigquery.Client.from_service_account_json(json_credentials_path=CREDS)
job = client.query('select * from dataset1.mytable')
for row in job.result():
	print(row)

 

---

Reference

• https://stackoverflow.com/questions/45003833/how-to-run-a-bigquery-query-in-python