Microsoft Teams alerts

Paradime integrates natively with Elementary CLI to enable you to generate report and/or send alerts using the Bolt scheduler out of the box. No additional installation required.

Configure Microsoft Teams

1. Create a new team and/or channel

First, create a new Team or add a new channel to an existing team to receive the alerts. Ensure the channel's type is set to Standard.

2. Create Teams Webhook

To setup an incoming webhook in our channel:

1. Go to a channel in your Team and choose Manage channel.

2. Choose Edit connectors.

3. Search for Incoming webhook and choose Add.

4. Choose Add again and add name your webhook Paradime (or any other name you prefer).

5. (Optional) You can add the Paradime logo for the Bot. Download this here.

When done, click on Create the webhook. Now copy the URL of the webhook, you will need this later when configuring the alerts.

Configure a Bolt schedule with Elementary CLI

You can use a runtime environment variable to pass your Teams webhook to the edr command at runtime. Check our docs here.

Alert on tests and models

Configure a Bolt schedule with the edr monitor CLI command at the end. Ideally this should be the command after your dbt runs and tests:

dbt run
dbt test
edr monitor --teams-webhook <your_teams_webhook>

Alert on source freshness failures

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.

dbt source freshness
edr run-operation upload-source-freshness --project-dir .
edr monitor --teams-webhook <your_teams_webhook>

Note:

• dbt source freshness and upload-source-freshness needs to run from the same machine.

• upload-source-freshness requires passing --project-dir argument.