metabase
Option to disable a database
Is your feature request related to a problem? Please describe. During db migration (non-Metabase related), or because of high load, then it is sometimes need to disable a database connection. Currently there is only an option to delete the database, but that will remove all related questions/etc. Changing the host, user or password might not be an option, since Metabase validates the information.
Describe the solution you'd like A toggle, which will stop any connections (queries, sync, etc). All the questions etc should still exist, but would error. The error message displayed should indicate that the database has been disabled in Metabase.
Describe alternatives you've considered
- Manually changing the
metabase_database.details, but that might require sysadmin or not possible at all if encrypted at rest. - Blocking using a firewall - can be complicated and might require sysadmin.
Related to #10398 and #7526
:arrow_down: Please click the :+1: reaction instead of leaving a +1 or update? comment
up up up :)
BTW: "Yes I read the Please click the 👍 reaction i..." part but 3 years passed from this issue and nothing is changed...
You can reduce the number of queries by adjusting the schedule, which may help in the case of high load. (https://www.metabase.com/docs/latest/databases/sync-scan#choose-when-metabase-syncs-and-scans)
But being able to disable it would still be helpful in the case where you want to disconnect the DB connection. (eg to rebuild the database)
