bq cmd query Google Sheet Table occur "Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found" Error

user_6328519 0
Viewed 7360

I have a table connect with Google Sheet, use WebUI query this table success, but if I use bq cmd query, It will echo error msg:

Access Denied: BigQuery BigQuery: No OAuth token with Google Drive scope was found

gcloud google-bigquery google-cloud-platform
4 Answers

Run auth revoke then auth login if only the latter doesn't work.

gcloud auth revoke
gcloud auth login --enable-gdrive-access
user_45226780

Hi, I know what happen, before gcloud auth login --enable-gdrive-access, I need delete ~/.config/gcloud folder, thanks!! – Karl Lin Sep 14 '17 at 12:32

Here's the complete answer based on Karl Lin's comment to the accepted answer.

rm -rf ~/.config/gcloud 
gcloud auth login --enable-gdrive-access

I needed to delete ~/.config/gcloud or it won't work.

user_1513650
Related