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.
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.
@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?