Run the same query against multiple backends

I have multiple databases following the same schema. Imagine regionally running applications rather than multitenancy.

I have about a hundred questions for one region in a single dashboard and would now like to have the same insights into the other database.

What are my options here?

  1. Does Metabase support this somehow and I don't know it?
  2. Ingest the contents of all regional databases into another database, tagging them with a origin/region tag along the way (maybe pg_fwd)
  3. ???
  4. Use the Metabase API and automagically recreate all the questions - advice needed
  5. Manually recreate everything by hand

Hey bolognafingers

The most straightfoward way would be using the Serialization feature for pro and enterprise versions.

Thanks

This is exactly what I'm doing for one of my customers now.
We're importing the data into a central database, tagging with source.
Dashboards are embedded with a hidden filter that selects the correct source/sources.
We're also doing some separate instances of Metabase that work on a separate database containing one or more sources.
We have a single source Metabase configuration that's just rolled out for each instance. Only a case of setting the database connection.