I am trying to access BigQuery from GKE (Google Kubernetes Engine). But even after repeated trial and error, it's showing Invalid Credential.

I checked the access logs. The user is xxx-compute@developer.gserviceaccount.com, which is enlisted as an editor of the BigQuery dataset I am trying to access.

But this same query succeeds with the project owner's credentials. I tried elevating the service account as an owner, but that didn't change the outcome either.

The screenshots are as follows: