Criteria Based Triggers

Greetings,

It would be great if we could schedule ETL to run on multiple yet very specific criteria. The one I have in mind as an example would be if the data set is not triggered by a prior dataset updating to allow for the system to run it at a certain time. I know we can set it to do this now but in that case it would run twice. I am hoping for something similar to

if dataset update != today then run scheduled time.

Tagged:

Best Answer

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have you looked into the advanced scheduling options? There are several there which may fit your use case:

    https://domo-support.domo.com/s/article/000005216?language=en_US

    Specifically:

    • DataSets have updated — This condition lets you activate the trigger when one or multiple DataSets have updated. If you choose this option, you must also specify the secondary condition for when the selected DataSets updated. These secondary conditions are described below:
      1. Since the last successful run — This option activates the trigger if the DataSets you specify in the condition have updated since the last successful run.
      2. In the last — This option activates the trigger if the DataSets you specify in the condition have updated in the last insert interval. You can make the interval a number of minutes, hours, or days.
      3. Within — This option activates the trigger if the DataSets you specify in the condition have updated within insert interval of each other. You can make the interval a number of minutes, hours, or days.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Answers

  • GrantSmith
    GrantSmith Coach
    Answer ✓

    Have you looked into the advanced scheduling options? There are several there which may fit your use case:

    https://domo-support.domo.com/s/article/000005216?language=en_US

    Specifically:

    • DataSets have updated — This condition lets you activate the trigger when one or multiple DataSets have updated. If you choose this option, you must also specify the secondary condition for when the selected DataSets updated. These secondary conditions are described below:
      1. Since the last successful run — This option activates the trigger if the DataSets you specify in the condition have updated since the last successful run.
      2. In the last — This option activates the trigger if the DataSets you specify in the condition have updated in the last insert interval. You can make the interval a number of minutes, hours, or days.
      3. Within — This option activates the trigger if the DataSets you specify in the condition have updated within insert interval of each other. You can make the interval a number of minutes, hours, or days.

    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**