one user two resource groups

Question

we have two resource groups that swap resource allocation at a certain time at night and in the morning.  
  
We have asked the dba to place a certain user in the high resource allocation resource group at night and the high resource resource group in the morning so it always has high resource.  They instead added the user to both resource groups.  
  
1.

AWS-User-0226321 · Accepted Answer

Are you using Manual WLM configuration, or Auto? I recommend using the Automatic WLM which makes sure that the cluster is fully utilized and gives you additional benefits such as automatic concurrency management and query priorities. (https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html)  
  
In any case, in your situation, the order in which the queries are routed to the right queue is determined by the order in which they are defined in the configuration. So it will use the first match in that order.   
  
If you need to disambiguate between the two queues, you can use query groups. That way, you have control from your application over which queue to run in by setting the right query group.   
  
https://docs.aws.amazon.com/redshift/latest/dg/automatic-wlm.html#wlm-auto-defining-query-queues-query-groups

mjmebes · Answer

got kicked out before finishing.  is this a good practice and what resources would the user get

mjmebes · Answer

thanks for the reply.  i'm not a dba but i think they are setting things manually.  i think i will try to get them to flip the group for the user based on time of day so there is no ambiguity.  
  
thanks  
again

one user two resource groups

Add your answer

Relevant content