Query from Bigquery using local command line

Question

I'm trying to query from BigQuery using PowerShell. I've initialised gcloud init and logged in to my account.
The request was this:

bq query --use_legacy_sql=false 'SELECT customer_id FROM `demo1.customers1`'

Resulting with this error:

BigQuery error in query operation: Error processing job
'PROJECT-ID:bqjob': Access Denied:
BigQuery BigQuery: Permission denied while getting Drive credentials.

This worked when I run it in cloud shell.

I've created a service account before and a key for the project. I tried to run this command and doesn't solve it:

gcloud auth activate-service-account [email protected] --key-file=D:/folder/key.json --project=MYPROJECT_ID

Could you please try bq ls. Just ensure that this account able to access BigQuery. — zzob
– zzob, Commented Sep 2, 2022 at 2:44
Can you try this command “gcloud auth login --enable-gdrive-access”? Let me know if it's helpful or not? — Prajna Rai T
– Prajna Rai T, Commented Sep 2, 2022 at 7:38

Prajna Rai T · Accepted Answer · 2022-09-08 11:56:24Z

1

Service account should have the OAuth scope for Drive to access drive, below command can be used to authenticate with Drive.

gcloud auth login --enable-gdrive-access

answered Sep 8, 2022 at 11:56

Prajna Rai T

1,8245 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Query from Bigquery using local command line

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related