Currently, dbt tests are run whenever a transformation is executed. Some of these column tests are critical for my company to ensure the data pipeline is functioning correctly and to avoid providing inaccurate analytics to stakeholders.

However, it is not possible to identify failed dbt tests unless we manually check the terminal output of each transformation. This means that if a change in a SQL query introduces a critical error in the database, we will not be immediately aware of it.

I propose a feature that allows users to select specific column tests and receive email notifications if they fail, similar to the notifications provided when the entire dbt project encounters an issue.