We have introduced query limits for Redshift clusters to prevent deadlocks and keep the clusters in good shape:
- 5 queries in parallel (further queries will be waiting in a queue for 60 minutes)
- 60 minutes execution time per query
If the query time exceeds 60 minutes, it will be terminated with a user error "Query cancelled on user's request" and/or "An exception occurred while executing".
These limits will take place during the next maintenance window of each cluster (after it reboots).
If you need to change the limits, contact us at support@keboola.com.
EDIT September 22nd: Due to a high number of requests for a higher number of concurrent queries we've increased the limit from 2 to 5 concurrent queries on each cluster.