How to connect to a BigQuery project instead of the individual datasets within?

I want all the datasets within a BigQuery project to be available under the same database in Metabase, but when I use the 'Add a database' option, it won't let me proceed without specifying a dataset_id. We have quite a few datasets in BigQuery, adding an individual connection for each dataset is extremely cumbersome and difficult to scale and maintain. Any suggestions as to how I can connect to the entire project through one database connection?

I have been following the instructions provided here:

Hi @mitaligore
There's a request for that - and there might be a third-party driver that supports it: - upvote by clicking :+1: on the first post