CODEWITHSUNDEEP
google-cloud-platformgoogle-bigquery
codninja0908
codninja0908

Reputation: 567

google default service account did not have permission for bq utility

I have a VM instance having default service account attached.

While doing bq ls on that instance throws error as below:

(airflow) [root@airflow-qa-master ~]# bq ls

BigQuery error in ls operation: Insufficient Permission

So I gave other permissions to that default service account listed below:

BigQuery Admin

BigQuery Data Editor

BigQuery Data Owner

BigQuery Data Viewer

Compute Admin

Compute Storage Admin

Editor

Owner

Still it is throwing Invalid credentials issue.

Upvotes: 2

Views: 1222

Answers (1)

FridayPush
FridayPush

Reputation: 916

The Default scope for an instance does not allow BigQuery access. There are two considerations for whether an API is usable on GCE, first being whether the attached service account is authorized to perform those actions. Second is whether the instance is allowed to perform those actions.

You can change the scope of an instance using this part of their documentation.

Upvotes: 3

Related Questions