We have a bunch of queries that we want to execute after our data warehouse ingest at night and before people start working and might want the current data. Currently I manually try to randomize the schedule times so I don’t have a bunch of computationally taxing queries being executed all at the same time, which in some cases could lead to failure. I suspect I’m not doing a great job of randomization. It would be great if I could either see a visualization of the scheduled queries on a timeline, or, probably better, if you could pick a time range (e.g. 1am-6am) and it would auto-distribute the execution.
This isn’t part of the application right now but you can likely create something similar using our API. Schedules are stored on the
/query object and would be pretty straightforward to visualize.