looker-open-source / looker-explore-assistant

A React Application for interacting with Looker data through natural language.
MIT License
110 stars 75 forks source link

Service Account Insufficient Permissions | BQ BE #88

Open LydiaB123 opened 2 months ago

LydiaB123 commented 2 months ago

When running the Big Query Backend terraform, a Big query model was not produced. This was due to the service account (bqcx-955701998566-ohoa@gcp-sa-bigquery-condel.iam.gserviceaccount.com) not having the necessary permissions. As shown below:

Screenshot 2024-09-06 at 15 34 05

To resolve this I updated the permission in the IAM console. The permissions I added include:

After this, I was able to re-run the query, which produced the model.