Has anyone tried to create a custom schedule for an ETL job?
I am trying to create a daily snapshot of our datasets regardless of whether the data change or not. The current ETL process I have created can do such, so long as the dataset in which I am pulling data is update. However if the data is never updated, the ETL is never kicked off, which can create a gap in our day to day snapshots. Anyone?
I have been told to create a separate dataset that can help trigger my jobs, but how would i schedule the new dataset to run on a specific time, let alone update the data it would be storing to kick off my ETL job? Anyone?
Best Answer
-
Thank you Godzilla but no. The solution i came up with is to create a datasource that consistently runs at a specific time, once created add that source into my MySQL ETL and select the box that runs the job when that data source is update. I hate using work arounds but seeing as to how we are not implementing workbence, it is my only option.
0
Answers
-
i'm assuming you're using the current version of workbench correct? if so, you may have to revert back to an older version of workbench to be able to schedule jobs at specific times. I'm not sure if version 3 allows to to control the times but i know version 2 does. I'm still using version 2 because of this.
Domo Arigato!
**Say 'Thanks' by clicking the thumbs up in the post that helped you.
**Please mark the post that solves your problem as 'Accepted Solution'0 -
Thank you Godzilla but no. The solution i came up with is to create a datasource that consistently runs at a specific time, once created add that source into my MySQL ETL and select the box that runs the job when that data source is update. I hate using work arounds but seeing as to how we are not implementing workbence, it is my only option.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive