In our production environment we have two Presto instances, all of them available to be accessed from our Redash servers. However, we would like one Presto instance to not be targeted by scheduled queries, only ad-hoc or on-demand ones.
Aside from user-side preventions, is it possible to at least not triggering scheduled query execution into specific data source while still allowing human-triggered query execution into the same data source?
We have altered the source code of Redash v3.0.0 and build our own version for quite some time, but I have not discovered a reliable way to do this (disable schedule ability for queries targeting specific data source).
But then I heard there’s a pause feature for data sources. But how do I trigger this, it seems API-only? I read that pausing a data source will disable both query execution and query scheduling but I think this can be worked around by commenting out some code in the query handler script.