Unable to use public BigQuery dataset

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?


Hi @mvdb
It looks like you’re seeing this issue:
https://github.com/metabase/metabase/issues/2273 - upvote by clicking :+1: on the first post

1 Like

Thanks, that’s it!