When trying to configure a BigQuery data source, I am unable to use a public dataset from BigQuery. I have set up a Google Service account, enabled the APIs needed, and uploaded that json. That all works, and using the same project ID as the service account all is fine, other than not having data.
However, when trying to connect to a public data set, which uses a different product ID than the one with the service account, the following error is shown.
googleapi: Error 403: Access Denied: Project tbatv-prod-hrd: User does not have bigquery.jobs.create permission in project tbatv-prod-hrd., accessDenied
Further, if I ignore this error, and set up a query, I can tell the connection works, because I can select the dataset, the table, and the columns. However again when trying to query the dataset, a similar error is shown:
Access Denied: Project tbatv-prod-hrd: User does not have bigquery.jobs.create permission in project tbatv-prod-hrd., accessDenied
Is there anyone that has used a public BigQuery data set, or any other way to fix this error?
For reference,
Grafana: v9.3.2
Dataset: https://thebluealliance.com/bigquery