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 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.

    Note

    You cannot modify the default parameter group.

  4. To edit properties in the WLM configuration parameter, choose Edit WLM. The WLM tab opens as shown in the following screenshot.

  5. 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.

  6. Choose one of the following options to specify when to apply your WLM property changes to any clusters associated with this parameter group:

    • To have changes applied to associated clusters after their next reboot, choose After cluster reboot.

    • To immediately apply changes to any associated clusters, choose Immediately.

      Note

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

  7. Choose Save.

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.