Elementary Teams integration includes sending Teams alerts on failures in dbt tests and models. The alerts are sent using Microsoft Teams Adaptive Cards format, which provides rich formatting and interactive capabilities.
MS Teams supports Elementary Alerts, but unlike Slack, it does not support the Elementary report or multiple channels.
There are two ways to create a webhook for Microsoft Teams:
Microsoft Teams Connectors (Legacy): The traditional way of creating webhooks, but this method is being deprecated by Microsoft.
Power Automate Workflows (Recommended): The newer, more flexible way to create webhooks. Note that when using this method, Elementary CLI cannot directly verify if messages were delivered - you’ll need to monitor your workflow runs in Power Automate.
Microsoft 365 Connectors (previously called Office 365 Connectors) are nearing deprecation. We recommend using Power Automate Workflows for new integrations.
Search for "When a HTTP request is received" as your trigger
In the flow, add a "Post adaptive card in a chat or channel" action
Configure the team and channel where you want to post
Save the flow and copy the HTTP POST URL
Important Notes:
When using Power Automate Workflows, Elementary CLI cannot directly verify if messages were successfully delivered. You'll need to monitor your workflow runs in Power Automate to check for any delivery issues.
Workflows can't post in private channels as a flow bot, but can post on behalf of a user
Workflows can only be created in your default environment
Lastly, pass the webhook URL (from either method) to the CLI as a param or in the config.yml file:
