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: https://www.metabase.com/docs/latest/administration-guide/databases/bigquery.html