Failure Notifications Aren't Sent When Transformations Fail Multiple Times

Issue

Despite enabling transformation failure notifications, I only receive a notification when my transformations fail for the first time. Subsequent failures don't trigger failure notifications.

Environment

• Notifications
• Transformations

Resolution

There are two ways you can receive notifications about each transformation failure:

1. Set up and configure an external logging solution to notify you when a transformation fails based on the logs generated by Fivetran. See our External Logs documentation for more information.
2. Configure a webhook to receive notifications about transformation failures using the event type dbt_run_failed. See our Webhooks Resource documentation for more information.

Cause

When you enable transformation notifications, we notify you when your transformation fails. However, to avoid sending excessive notification emails, we don't notify you about subsequent failures until your transformation runs successfully without errors at least once.