Posted On: Sep 25, 2023

Amazon Redshift now adds support for role-based access control in workload management (WLM). With this support, when your Amazon Redshift users run queries in the database, their queries are routed to the query queue that is associated with their user role. 

In Amazon Redshift, you can use WLM to define the number of query queues that are available, and how queries are routed to those queues for processing. Role-based access control (RBAC) is used to manage database permissions; RBAC simplifies the management of security permissions in Amazon Redshift by granting permissions to user roles and then assigning the role to the user. The support of user roles in WLM extends the RBAC capability to the workload management, so you no longer need to use user groups in order to manage a query queue for a different user. You can configure WLM by using the Amazon Redshift console, the AWS CLI and the Amazon Redshift API. 

The feature of user roles support in WLM is available in commercial and AWS GovCloud (US) Regions where Amazon Redshift is available. To learn more, visit the Amazon Redshift management guide and blog.