Menu
Amazon Redshift
Management Guide (API Version 2012-12-01)

Managing Parameter Groups Using the Console

You can view, create, modify, and delete parameter groups by using the Amazon Redshift console. To initiate these tasks, use the buttons on the Parameter Groups page, as shown in the following screenshot.

You can expand any of the parameter groups in the list to see a summary of the values for parameters and workload management (WLM) configuration. In the following screenshot, the parameter group called custom-parameter-group is expanded to show the summary of parameter values.

Creating a Parameter Group

You can create a parameter group if you want to set parameter values that are different from the default parameter group.

To create a parameter group

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Parameter Groups.

  3. On the Parameter Groups page, choose Create Cluster Parameter Group.

  4. In the Create Cluster Parameter Group dialog box, choose a parameter group family, and then type a parameter group name and a parameter group description. For more information about naming constraints for parameter groups, see Limits in Amazon Redshift.

  5. Choose Create.

Modifying a Parameter Group

You can modify parameters to change the parameter settings and WLM configuration properties.

Note

You cannot modify the default parameter group.

To modify parameters in a parameter group

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Parameter Groups.

  3. On the Parameter Groups page, in the parameter group list, select the row of the parameter group that you want to modify.

  4. To edit the parameters other than the WLM configuration parameter, choose Edit Parameters.

    The Parameters tab opens as shown in the following screenshot.

  5. In the Value box that corresponds to the parameter you want to modify, type a new value. For more information about these parameters, see Amazon Redshift Parameter Groups.

  6. Choose Save Changes.

    Note

    If you modify these parameters in a parameter group that is already associated with a cluster, reboot the cluster for the changes to be applied. For more information, see Rebooting a Cluster.

To modify the WLM configuration in a parameter group

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Workload management.

  3. For Parameter groups, choose the parameter group that you want to modify.

    Note

    You cannot modify the default parameter group.

  4. To edit the WLM configuration, choose Edit.

  5. To enable short query acceleration (SQA), choose Enable short query acceleration.

  6. Do one or more of the following to modify the queue configuration:

    • To create a queue, choose Add Queue.

    • To modify a queue, change property values in the table.

    • To change the order of queues, choose the Up and Down arrow buttons in the table.

    • To delete a queue, choose the Delete button in the queue's row in the table.

  7. To have changes applied to associated clusters after their next reboot, choose Apply dynamic changes after cluster reboot.

    Note

    Some changes require a cluster reboot regardless of this setting. For more information, see WLM Dynamic and Static Properties.

  8. Choose Save.

Creating or Modifying a Query Monitoring Rule Using the Console

You can use the AWS Management Console to create and modify WLM query management rules. Query monitoring rules are part of the WLM configuration parameter for a parameter group. For more information, see WLM Query Monitoring Rules.

When you create a rule, you define the rule name, one or more predicates, and an action.

When you save WLM configuration that includes a rule, you can view the JSON code for the rule definition as part of the JSON for the WLM configuration parameter.

To create a query monitoring rule

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Workload management.

  3. For Parameter groups, choose the parameter group that you want to modify.

    Note

    You cannot modify the default parameter group.

  4. To edit the WLM configuration, choose Edit.

  5. Choose Add queue. A new queue appears, as shown in the following screenshot.

  6. To create a new rule using a predefined template, in the Rules for Queue 1 group, choose Add Rule from Templates. The Rule Templates dialog appears, as shown in the following screenshot.

  7. Choose one or more rule templates. WLM creates one rule for each template you choose. For this example, choose Long running query with high I/O skew and then choose Select.

    A new rule appears with two predicates, as shown in the following screenshot.

  8. Type a Rule name. The name can be up to 32 alphanumeric characters and must not contain spaces or quotation mark characters. For this example, type HighIOskew.

  9. Optionally, modify the predicates.

  10. Choose an Action. Each rule has one action. For this example, choose Hop. Hop terminates the query and WLM routes the query to the next matching queue, if one is available.

  11. Choose Save.

  12. To modify the rules for a queue, choose Edit.

  13. To add a new queue from scratch, choose Add Custom Rule. You can a maximum of five rules per queue, and a total of eight rules for all queues.

  14. Type a Rule name; for example, NestedLoop.

  15. Define a Predicate. Choose a predicate name, an operator, and a value. For this example, choose Nested loop join count (rows). Leave the operator at greater than ( > ), and for the value type 1000. The following screen shot shows the new rule with one predicate.

  16. To add additional predicates, choose the add icon to the right of the predicates. You can have up to three predicates per rule. If all of the predicates are met, WLM triggers the associated action.

  17. Choose an Action. Each rule has one action. For this example, accept the default action, Log. The Log action writes a record to the STL_WLM_RULE_ACTION system table and leaves the query running in the queue.

  18. Choose Done Editing. The queue details collapse.

  19. Choose Save.

  20. Amazon Redshift generates your WLM configuration parameter in JSON format and displays the JSON in a window at the bottom of the screen, as shown in the following screenshot.

Deleting a Parameter Group

You can delete a parameter group if you no longer need it and it is not associated with any clusters. You can only delete custom parameter groups.

To delete a parameter group

  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.

  2. In the navigation pane, choose Parameter Groups.

  3. Select the row of the parameter group that you want to delete, and then choose Delete.

    Note

    You cannot delete the default parameter group.

  4. In the Delete Cluster Parameter Groups dialog box, choose Continue.

Associating a Parameter Group with a Cluster

When you launch a cluster, you must associate it with a parameter group. If you want to change the parameter group later, you can modify the cluster and choose a different parameter group. For more information, see To create a cluster and To modify a cluster.