Teams setup for Elementary CLI

Elementary Teams integration includes sending Teams alerts on failures in dbt tests and models.

Integration options

There is one integration option for Microsoft Teams: a Webhook. This method let you receive alerts from Elementary, but lacks some support that is available in the Slack integration solution. Below is features support comparison table (with Slack), to help you select the integration method.

Integration	Elementary alerts	Elementary report	Multiple channels	Slack workflows
Teams Webhook	✅	❌	❌	❌
Slack Token	✅	✅	✅	❌
Slack Webhook	✅	❌	❌	✅

Teams integration setup

First create a Microsoft Teams team:

Create a new Team

Create a new Team

Go to the Microsoft Teams desktop app and create a new team.

Create a team from from a template and use the From Scratch template.

Choose Public as the kind of a team.

Call it Elementary (or whatever you prefer) and connect it to the workspace of your choice.

Now it is time to setup the webhook for this channel.

Create Teams Webhook

Create a webhook

Go to a channel in your Team and choose Manage channel

Choose Edit connectors.

Search for Incoming webhook and choose Add.

Choose Add again and add name your webhook ElementaryWebhook (or whatever you prefer). And Create the webhook.

Copy the URL of the webhook.

Lastly, pass the webhook to the CLI as a param or in the config.yml file:

Teams config as CLI params

Webhook:

Use the webhook URL when you execute edr monitor using the option -tw, --teams-webhook:

edr monitor --teams-webhook <your_teams_webhook_url>

Teams config as in config.yml

The CLI reads the Teams integration from a file, copy it into a file called config.yml. Create it here: HOME_DIR/.edr/config.yml

Here is the format in the yml itself:

Webhook:

config.yml

teams:
  teams_webhook: <your_teams_webhook_url>