we have a Dashboard Subscription that would send a slack notification when there is a data result from a Question or SQL query,
but when the SQL query has an error (due to a change in the DB table fields for example) we don't get any notifications from that dashboard subscription,
is there a way to get notified when a question or a SQL query has an error?
You should receive an error message if you always get results (disabled "Don't send if there aren't results").
Otherwise you would need to setup another alert which looks for a specific question failing. Will quickly get a little complicated.
There's currently no "reverse" builtin:
https://github.com/metabase/metabase/issues/7860 - upvote by clicking on the first post