Limit maximum time of query execution for a particular group in redshift?

Question

I have a group of users in Redshift. I would like to limit the maximum time of their query execution to some particular value.

Something similar to statement_timeout, but no one would need to write set statement_timeout to 1000; before each session, and no one can overwrite this value.

Answer 1

You can do this via WLM queues. A specific group of users can be assigned to a queue and given a WLM timeout.

FWIW, I've not found WLM (WorkLoad Management) to be worth the added complexity and potentially idle resource.