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 site is in read only mode. Please continue to browse, but replying, likes,
and other actions are disabled for now.
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.