Elementary has a Slack integration to send alerts about:
- Failures and/or of dbt tests
- Failures and/or Elementary tests
- Model runs failures
- Source freshness issues
Setup Slack Integration
First create a Slack app:
Based on the method you selected, create a token or webhook:
Lastly, pass the token / webhook to the CLI as a param or in the
Execute the CLI
Make sure to run the following command after your dbt runs and tests:
edr monitor --slack-token <your_slack_token> --slack-channel-name <slack_channel_to_post_at> --group-by [table | alert]
edr monitor if you used
Alert on source freshness failures
Not supported in dbt cloud
To alert on source freshness, you will need to run
edr run-operation upload-source-freshness right after each execution of
dbt source freshness.
This operation will upload the results to a table, and the execution of
edr monitor will send the actual alert.
- Note that
dbt source freshnessand
upload-source-freshnessneeds to run from the same machine.
- Note that
In order to monitor continuously, use your orchestrator to execute it regularly (we recommend running it right after your dbt job ends to monitor the latest data updates).