BigQuery public datasets?

I would like to import one of bigquery open datasets (more specific the london crime dataset) into my metabase instance.
Issue is that I am only on a bi-contractor role in BigQuery as I do this as a private person, not for my company. Is there a way to do this?
I would need project ID and a json service account and I am not sure if this is even possible when I don't have more rights in BQ.
I don't think this closed issue is solving my problem as it assumes I can just use my own projects credentials, but I don't have my own project in BQ.

Hi, you need to access Bigquery in gcp to do that

1 Like