Warn about DB Routing breaking Public Dashboards
Describe the bug
When you enable DB Routing it breaks Public Dashboards created against that DB ... This was done on purpose the lack of support but a user has no idea why this happened, there is a feature request to support this
https://github.com/metabase/metabase/issues/73899
To Reproduce
Create a public dashboard against a DB and then enable DB routing notice the Question fail:
Expected behavior
When you enable DB Routing we should expose some type of warning to notify the user about this. And if they don't have Public Dashboards the option should be disabled if the DB has DB routing and a small note about this
Logs
Anonymous users cannot access a database with routing enabled
Information about your Metabase installation
Always been like this since DB Routing
Severity
Can break functionality without knowing why
Additional context
For one of their verticals, they have a large number of reports and dashboards. Maintaining two different environments/editors is not feasible, as every change or newly created report/dashboard would need to be replicated and maintained in both places, leading to additional operational overhead and maintenance effort. So they broke a number of dashboards but had no idea why.
Source: metabase/metabase