We have different copies of a database, one for each environment.
So say we have an event database for prod and one for test, both have the same tables (schema).
We want to write the SQL once only so that if the SQL changes, we only need to edit it in one place.
We are looking to use Metabase to supply some questions and dashboards but can't figure out how to let users choose which database to run the SQL (Question/Dashboard) against.
Why is the database tied to a question/dashboard?
Can we have an option to pass in the database to the question/dashboard perhaps as a filter/locked variable etc.
To make this fit in to the current design, I wouldn't mind having to write the questions and dashboards against a particular database, but would like the options to let the user change the database dynamically.