Farrukh shows you how to
prioritize or separate queries
into different queues

farrukh_redshift_wlm_etl_queues

I want to divide my Amazon Redshift cluster among queries run by different users by putting the queries into separate queues. How do I do that?

You can create query queues in Workload Management (WLM), which allows you to divide ETL queries into separate queues. Queries assigned to the queue execute with a given amount of the total memory available to a cluster. WLM also allows you to adjust the maximum execution time and concurrency of your queues, allowing you to effectively prioritize some queues over others. Queries with no assigned queue are assigned to the default queue instead.

For an in-depth walkthrough for creating query queues, see Tutorial: Configuring Workload Management (WLM) Queues to Improve Query Processing.


Did this page help you? Yes | No

Back to the AWS Support Knowledge Center

Need help? Visit the AWS Support Center

Published: 2017-03-15