Run the same query against multiple backends

1

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
2

Hey bolognafingers

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

Thanks

3

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.

1 Like