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.
Source:: Amazon AWS