Setup Teams alerts
Before you start
Before you can start using the alerts, make sure to install the dbt package, configure a profile and install the CLI. This is required for the alerts to work.
First create a Microsoft Teams team:
Now it is time to setup the webhook for this channel.
Lastly, pass the webhook to the CLI as a param or in the config.yml
file:
Execute the CLI
Make sure to run the following command after your dbt runs and tests:
Or just edr monitor
if you used config.yml
.
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 freshness
andupload-source-freshness
needs to run from the same machine. - Note that
upload-source-freshness
requires passing--project-dir
argument.
Continuous alerting
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).
Read more about how to deploy Elementary in production. If you need help or wish to consult on this, reach out to us on Slack.