Attempting to send conditional email

Ron_vB
Ron_vB Registered Posts: 3 ✭
in General Discussion

Hello,

I am attempting to create an output email scenario where one email with a specific dataset attached will always send and a second email will send only if the dataset has output in it.

I attached a capture of how I currently have this set up but, I am thinking there maybe some Python script involved to fix this. Any help would be appreciated.

Thanks,

Ron

Tagged:
· Share on FacebookShare on Twitter

Best Answer

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 297 Dataiker
    Answer ✓

    Hi @Ron_vB
    ,

    Can you describe which step you think you might be missing? Did you add the check to the dataset (status > edit > checks > select "metric value is in a numeric range")?

    Screen Shot 2022-12-09 at 12.45.41 PM.png

    Thanks!

    Jordan

     

    · Share on FacebookShare on Twitter

Answers

  • JordanB
    JordanB Dataiker, Dataiku DSS Core Designer, Dataiku DSS Adv Designer, Registered Posts: 297 Dataiker

    Hi @Ron_vB
    ,

    You could use a python step, but a simpler way to achieve this would be to use a check on the dataset with a minimum record value of 1.

    Screen Shot 2022-11-30 at 5.58.35 PM.png

    Then, add a "run checks" step in the scenario. You will need to check "consider warnings as failures".

    In the "send message" step, for the field "Run this step", you can add "if no prior step failed".

    If the dataset has at least 1 record, the step will pass and the message will send. If the dataset is empty, the message step will not run.

    Please let me know if this works for you.

    Thanks!

    Jordan

    · Share on FacebookShare on Twitter
  • Ron_vB
    Ron_vB Registered Posts: 3 ✭

    Thank you for the response. I put a run check into the scenario but, I do not seem to have the same options as you. Am I running an older version maybe?

    · Share on FacebookShare on Twitter
  • Ron_vB
    Ron_vB Registered Posts: 3 ✭

    Ahhh ha! Yes now I see what I was missing. Thank you that worked correctly!

    · Share on FacebookShare on Twitter
  • Nirmal Kumar
    Nirmal Kumar Registered Posts: 1 ✭✭
    https://community.dataiku.com/discussion/comment/31138#Comment_31138

    Hi @JordanB - Thanks your solution, it helped . But have a question. I have multiple checks set up for a dataset and one of them is to find the min record count. I have also set up a scenario with email reporters and in the steps tab i added the run checks as you advised by choosing the dataset. My check failed (because 0 records in dataset) but still the email reporters triggered an email.

    Does steps and scenario email has a connect? how does the steps execute first and tells to trigger a email? Do we need to set up a run condition or?


    Also for the dataset i have 4 checks, how the steps here will determine which check to be used ?
    Thanks much in advance - Nirmal

    image.png

    Email scenario

    image.png

    Steps

    image.png

    · Share on FacebookShare on Twitter
  • Turribeach
    Turribeach Dataiku DSS Core Designer, Neuron, Dataiku DSS Adv Designer, Registered, Neuron 2023 Posts: 2,166 Neuron

    You need to set a run condition. Or use a Send Mail scenario step rather than the scenario reporter. In any case please open a new thread if you have further questions. This thread has been marked as answered already.

    · Share on FacebookShare on Twitter
Bookmark this topic

Categories

Setup Info
    Tags
      Help me…