Can you use workflows to automatically manage workbench?
Our workbench jobs have a habit of getting hung up when updating making our data fall behind and our end users annoyed. I've already reached out to domo support to help with this issue but in the meantime I have workbench open and I manually update the jobs that miss their scheduled updates. Seeing how this is pretty annoying I began looking into creating a workflow that would notify me when a workbench job missed the update and would automatically run the job to get it back on schedule.
I see the run dataset function in the dataset package but this doesn't seem to work for datasets originating from workbench. There's a good chance I'm setting something up wrong as well.
Any help would be great. Thank you
Best Answers
-
Jarren, as it relates to Workbench, there isn't any way for a Workflow to talk to Workbench, because it's running locally behind your firewall in your environment. That said, your idea of having a workflow notify if you data hasn't updated is a good one.
I believe there is an end point that can update a workbench jobs schedule, and a workflow could hit that end point, but that doesn't solve your problem of unstable db connections. That may be helpful if you want to update the job to run 10 minutes from now, for example.
I'm happy to do some more digging in to that end point if you think it would be helpful.0 -
I was just looking into some remote triggering of Workbench jobs and one of my Domo contacts thought about Workflows as well. He did some asking around with the Domo engineers and was told Workflows would not be able to help in this scenario.
There is a beta of Domo Workbench Enterprise that might be worth looking into. It could provide the capabilities you are looking for.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0
Answers
-
Jarren, as it relates to Workbench, there isn't any way for a Workflow to talk to Workbench, because it's running locally behind your firewall in your environment. That said, your idea of having a workflow notify if you data hasn't updated is a good one.
I believe there is an end point that can update a workbench jobs schedule, and a workflow could hit that end point, but that doesn't solve your problem of unstable db connections. That may be helpful if you want to update the job to run 10 minutes from now, for example.
I'm happy to do some more digging in to that end point if you think it would be helpful.0 -
I was just looking into some remote triggering of Workbench jobs and one of my Domo contacts thought about Workflows as well. He did some asking around with the Domo engineers and was told Workflows would not be able to help in this scenario.
There is a beta of Domo Workbench Enterprise that might be worth looking into. It could provide the capabilities you are looking for.
**Check out my Domo Tips & Tricks Videos
**Make sure to any users posts that helped you.
**Please mark as accepted the ones who solved your issue.0 -
@Zoolander I'd be interested in learning about that end point idea of yours
@MarkSnodgrass Thank you for the reply. I'll take a look at the Domo Workbench Enterprise
0 -
@Jarren - I'll see what I can turn up. It's not an end point of mine, but I know a guy…
0 -
@Jarren - I think, after further research, this is something that should wait for a workbench enhancement. Apparently it would be quite risky to use this end point as you could very easily botch the entire workbench job as it wasn't created for this purpose.
0 -
@Zoolander Sounds good. Thank you for the help!
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 98 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 713 Beast Mode
- 50 App Studio
- 39 Variables
- 669 Automate
- 170 Apps
- 447 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 104 Community Announcements
- 4.8K Archive