Hi there,
I am trying to add a new BigQuery database to our Metabase instance. It's a public dataset provided by The Python Software Foundation: https://console.cloud.google.com/bigquery?project=the-psf&page=dataset&d=pypi&p=the-psf&redirect_from_classic=true
First, I am not able to generated credentials for this project. So I generated credentials for another project. I was able to add the BigQuery database, and Metabase seems to be able to scan the database metadata (it gives me all the tables and all the columns in it). But when I try to run queries (either from the UI or a native query), it returns the following error:
Access Denied: Project the-psf: User does not have bigquery.jobs.create permission in project the-psf.
I double check that I was able to run the query from BigQuery UI and it worked great. Is there any way I can make this work in Metabase?
Thanks!
on the first post