Change the database for a specific question

caer · March 17, 2018, 5:12pm

Is it possible to change the database for an existing question?

We have similar schemas in two databases : “production-db” and “dev-db” have mostly the same tables.
We frequently need to repeat an existing “dev” table question on the corresponding “production” database table.

For SQL queries this is easy, just copy the query. For Metabase questions, I have to rewrite all parameters.

jornh · March 18, 2018, 1:05pm

Short answer: No currently not.

But as a workaround you might convert your Question to native SQL and manipulate the database on those as you describe you already do with other native Questions.

Related GitHub issues:

github.com/metabase/metabase

Query for one database cannot be run on other database.

opened 10:50AM - 29 Nov 17 UTC

frodrigo

Priority:P2 Type:New Feature Organization/Saved Questions Querying/GUI Querying/Notebook

Query build with one database cannot be switched to another. For SQL query is ju…st switching of database. My use case is from writing query on staging database and running latter on production database. :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment

github.com/metabase/metabase

How to export/import configuration and metadata

opened 10:49AM - 28 Nov 17 UTC

closed 07:57AM - 06 Jan 21 UTC

kstan79

Operation/

I'm new in metabase, I would like to check is there a way to support multiple da…tabase but same schema by export and import the configuration. The use case as below: 1. we develop chart and dashboard at development server 2. we export all charts/dashboard/configuration and import into different server (production) Cause we may have a few production server shared identical schema, we wish to eliminate repeated work on create chart, create dashboard cause we frequently change our work. Or, if metabase support multi-tenancy and allow administrator replace data source it will be much more easier. Is there any suitable solution for my use case? Thanks in advance. Ks :arrow_down: Please click the :+1: reaction instead of leaving a `+1` or `update?` comment

Dobrin · March 17, 2020, 2:59pm

It’s been 2 years, does anybody know whether now it’s possible to change the database for an existing question?

AndrewMBaines · March 18, 2020, 8:48am

Only if you want to change the connection for all questions that use that database.
For an individual questin, sadly not. The database is easy as it’s just an ID. The problem is all the tables in the question also have a unique id, as do the columns. It’s poor design in the backend database.

Dobrin · March 18, 2020, 11:17am

Thanks for replying!

@AndrewMBaines So if I have all my questions having DB1 as a source, can I add a new DB (DB2) that has all the same schemas’, tables’, columns’ names as DB1 and then make all questions have DB2 as a source (and then delete DB1)?
If yes, how exactly?

AndrewMBaines · March 18, 2020, 2:16pm

No, change DB1 connection to be the settings you’d have for DB2