ODBC DataSet From Workbench - Remote Job Trigger
Not sure if there is a good way to do this, given the fact that the workbench is usually behind a firewall. It could be nice to be able to select a bunch of DataSets in the Domo web interface and flag them to request a refresh via the attached Domo workbench job. I imagine this would have to be achieved via a polling request initiated by the Workbench to check for jobs whose target DataSets have a refresh request.
My use case is that occasionally one of my data backups fails due to other circumstances and this results in the failure of dozens of daily Workbench jobs that rely on the backup. I fix the backup issue and now have to manually run those dozens of backup jobs individually if I want to update the data for today.
Some additional features needed to support this:
- Batch Select DataSets to perform bulk action (really nice to have)
- Single/Bulk action to refresh DataSets (exists for many connectors as a single action but you need to click in to the detail view. Not available for DataSets sourced from a Workbench job currently)
- Sort by status so that failing DataSets show up first (pretty nice to have and I think it's requested elsewhere on this forum).
Alternatively, I could imagine that some kind of bulk retry operation could be part of the Workbench interface. This lacks the appeal of normalizing Web DataSet capabilities, but it might be a good idea in its own right.