Export query data from google bigquery to local machine
pip install bigQueryExporter
pip3 install bigQueryExporter
For Mac python 2.7
pip install bigQueryExporter --ignore-installed six
from bigQueryExport import BigQueryExporter
bigQueryExporter = BigQueryExporter(project_name, dataset_name, bucket_name)
bigQueryExporter = query_to_local(query, job_name, '../data')
-
Your server/ local machine should have the right to access the project
-
Right should be granted following the insturction on Google SDK
-
Execute the following command
gcloud auth application-default login