First post, and I have to say I love Metabase! I have configured several instances and have also poked inside the meta database a bit (relates to this question)
Currently, I am setting up one consolidated Metabase instance for a client that uses separate databases for each of their large customers. Each of these databases has an identical schema that is kept in sync automatically (but the data is, of course, different for each customer). The client does not need to combine separate databases in the same questions/collections, but wants to instead maintain parallel sibling Collections for each customer that have identical Dashboards/Questions/Permissions.
Is there a plan for Metabase to support a feature like this, e.g. a “database switcher” at the Question/Dashboard level, or a “copy Question to new database”?
For what its worth, I was able to build a DB script that performs the copy variation. It is working well so far, but I wonder if there is a native solution for this in the works that would be more future-proof, e.g. robust to Metabase internal schema upgrades that change the fields or logic behind these relevant tables (which is hard-coded into my script):
- metabase_database, metabase_table, metabase_field (to remap non-SQL queries with reference to field and table IDs across databases)
- report_card, report_dashboard, report_dashboardcard, dashboardcard_series
- collection
- permission