Alerts - When Dataset Fails X times in a row.

DataMaven
DataMaven 🟢
in Ideas Exchange

We are all overwhelmed with email alerts on dataset failures, right?

How often do you open the dataset only to find that it was a single random failure, and has since run successfully?

I think it would help to have a setting where the dataset/dataflow failure alerts only trigger when there have been multiple consecutive failures.

DataMaven
Breaking Down Silos - Building Bridges
Check out my video!
**Say "Thanks" by clicking the heart in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"
Tagged:
7
Up
7 votes

Submitted · Last Updated

Comments

  • jstan
    jstan Dallas, TX 🟠

    The thing I have done in the interim is put an alert on datasets that haven't updated in XX minutes and control the minutes on a google sheet by dataset ID. I usually target my production datasets and then can dig into root causes. It updates every 15 minutes. Then I can get a single alert for all datasets I want to track.

  • TheLookout
    TheLookout 🟡
    edited January 25

    If you're using the DomoStats datasets, you could build a small dataflow to show you dataflows that have failed a specified amount of times since their last successful run.

    Dataflows_with_Multiple_Failures.txt
    Dataflows_with_Multiple_Failures.PNG

    I built this real quick so I'd be willing to bet there are optimizations/changes that you could make. The two inputs are the Dataflows and Dataflows History from the DomoStats connector. For most everyone this connector can only run its reports once a day so be aware it could be up to a day behind your live domo data.


    Oh and just in case you've never done it before, you can just copy and paste that text document into a New ETL.

    I uploaded a different version of the text file with a typo corrected.

Categories