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
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
In the navigation pane, choose Parameter Groups.
On the Parameter Groups page, choose Create Cluster Parameter Group.
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.
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
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
In the navigation pane, choose Parameter Groups.
On the Parameter Groups page, in the parameter group list, select the row of the parameter group that you want to modify.
To edit the parameters other than the WLM configuration parameter, choose Edit Parameters.
The Parameters tab opens as shown in the following screenshot.
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.
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
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
In the navigation pane, choose Parameter Groups.
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.
To edit properties in the WLM configuration parameter, choose Edit WLM. The WLM tab opens as shown in the following screenshot.
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.
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.
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
Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshift/.
In the navigation pane, choose Parameter Groups.
Select the row of the parameter group that you want to delete, and then choose Delete.
Note
You cannot delete the default parameter group.
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.
