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:
0
Best Answer
-
Have you looked into the advanced scheduling options? There are several there which may fit your use case:
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:
- 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.
- 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.
- 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!**1 - 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:
Answers
-
Have you looked into the advanced scheduling options? There are several there which may fit your use case:
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:
- 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.
- 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.
- 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!**1 - 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:
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 731 Beast Mode
- 55 App Studio
- 40 Variables
- 682 Automate
- 175 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 122 Manage
- 119 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 107 Community Announcements
- 4.8K Archive