Feat: warns as alerts

[famazak]

What

Allows test warnings to be surfaced in the alerts model so that the alerts page in the re_data UI can list warnings as well as failures

How

Adds a new variable re_data:show_warns_as_alerts (defaults to false) that when set to true will modify the SQL in the alerts model to select tests with the warn status

[famazak]

Hey @davidzajac1 - I just wanted to give this a quick bump.

Some background that led to this proposed new feature: my team has a custom Tableau dashboard that we've used for years to monitor our dbt test results. We implemented re_data, but as it stands, the alerts page of the overview UI doesn't show test warnings so we have to rely on both re_data and this custom Tableau dashboard we built in order to monitor our tests because we use both warn and fail severity levels. If the re_data alerts page also included test warnings along with failures, we can fully move to re_data which would be great because we could finally have a single tool for observability.

I figured this might be useful to other users of the tool, so my proposed implementation adds a new variable that can be used to toggle this functionality.

I also opened a PR in the main re_data repo that includes some documentation updates: https://github.com/re-data/re-data/pull/418

Thanks in advance for your time!

[davidzajac1]

@famazak this is great! Added some changes to your branch of the re-data repo to show this feature in the UI and it looks good. Thanks for the contribution and sorry for the delay!