Is it possible to use a single question across multiple databases?

[omkar]

Problem

I have two databases with the same schema. The question logic is exactly the same, and the only thing that changes is the database selected from the database dropdown.

Currently, to display metrics from both databases together, I:

1. Create a question against Database A.

2. Duplicate the question.

3. Change the duplicated question to Database B.

4. Add both cards side by side on a dashboard.

Question

Is there a way to create a single question and dynamically choose which database it runs against?

Why I'm Asking

Maintaining duplicate copies of every question is becoming difficult. Any change to the query or visualization needs to be repeated across all copies, which makes it harder to keep everything consistent.

Are there any recommended approaches or built-in features for handling this use case?

Thanks!

[dwhitemv]

Not currently. Metabase has a tight binding to the source database and its fields. The paid versions have a ‘re-source a question to a new database with an identical schema’ feature, and there are third-party tools, but its not possible to make it dynamic.

If you find you need to clone questions a lot, you might look into the Remote Sync feature in the paid versions, where you can copy a template, commit it, and push it to Metabase.