Bigquery - Silent Login

I am using the large command line Query. when i use gcloud auth login it asks for login. and when for Unix I need to get the authorization code.

Is there a way that I can put the credentials somewhere (with a password) so that I don't have to do it manually? I am trying to automate it. I can use the secret key for the same.


source to share

1 answer

You can use the service account file for authentication:

bq \ 
   --service_account_credential_file=~/clok_cred.txt \
   --service_account_private_key_file=/somekeyFile.p12 \
   --project_id=formal-cascade-571 \
   query "select * from dw_test.clokTest"


See also How to get gcloud auth activate-service-account persist ".




All Articles