dbt Failures As Monte Carlo Alerts

Monte Carlo can surface dbt model, test, snapshot, and seed failures and test warnings as Monte Carlo alerts. This lets you:

  • Route and receive notifications like other Monte Carlo alerts
  • Analyze the downstream impact of a failure
  • Report on dbt failures alongside all your other data issues

Failure types

Alert conditionWhen it fires
Model errorA dbt model fails.
Test failureA dbt test fails.
Test warningA dbt test returns a warning.
Snapshot errorA dbt snapshot fails.
Seed errorA dbt seed fails.

A failure alerts only when its node matches a table in Monte Carlo. Test failures and warnings are attached to the model they test.

Create a job monitor

To choose which dbt failures alert and who is notified, create a job monitor on your dbt integration. A job monitor can cover all dbt jobs, whole dbt projects, jobs with a given tag, or jobs you pick. Under Alert when, choose the failure types that alert. You can also use Limit to tables to alert only on failures for certain databases, schemas, or tables. See Job monitors for setup steps.

When a failing model, test, snapshot, or seed succeeds in a later run of the same dbt job, Monte Carlo automatically resolves its failure on alerts opened in the last 24 hours. Test warnings aren't resolved automatically.

Grouping Repetitive Failures into the same alert

By default, all failures from one dbt run share an alert.

On a dbt integration's page in Settings → Integrations, Group repetitive failures into one alert for these alert types lets you group by error message instead, for each alert type:

When this setting is on for an alert type, a new failure of that type joins an open alert when:

  • the alert has a dbt failure that isn't resolved,
  • the event type is the same,
  • the error message is exactly the same, and
  • the failures are within 12 hours of each other.

The model or table that failed is ignored, so the same error across many models becomes one alert.

These settings apply to job monitors that use the default alert grouping. A job monitor with another Reduce noisy notifications option uses that option instead. See Alert grouping.


Did this page help you?