How to read test logs via dbt Cloud?

I know Slack notifications are limited to job runs (at least for now), but I’m still interested in a workaround to fulfill the need to alert on testing successes/failures on a routine basis via Slack.

What appears to be the suggested solve is:

  1. query test logs
  2. write to database
  3. read DB and push data to a Slack channel with orchestration tool (eg, Airflow)

I’m not at all sure how/where to access logs specifically via dbt Cloud. Is this feasible? I’m strictly dependent on dbt Cloud.

Parts 2 and 3 I have covered.

Any help would be much appreciated. Thanks in advance.