Managing parameter groups using the console - Amazon Redshift

Managing parameter groups using the console

You can view, create, modify, and delete parameter groups on the Amazon Redshift console.

You can view any of your parameter groups to see a summary of the values for parameters and workload management (WLM) configuration. Group parameters appear on the Parameters tab, and Workload queues appear on the Workload Management tab.

Creating a parameter group

If you want to set parameter values that are different from the default parameter group, you can create your own 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/redshiftv2/.

  2. On the navigation menu, choose Configurations, then choose Workload management to display the Workload management page.

  3. Choose Create to display the Create parameter group window.

  4. Enter a value for Parameter group name and Description.

  5. Choose Create to create the parameter group.

Modifying a parameter group

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

Note

You can't modify the default parameter group.

To modify a parameter group
  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

  2. On the navigation menu, choose Configurations, then choose Workload management to display the Workload management page.

  3. Choose the parameter group that you want to modify to display the details page, with tabs for Parameters and Workload management.

  4. Choose the Parameters tab to view the current parameter settings.

  5. Choose Edit parameters to enable changing settings for these parameters:

    • auto_analyze

    • auto_mv

    • datestyle

    • enable_case_sensitive_identifier

    • enable_user_activity_logging

    • extra_float_digits

    • max_concurrency_scaling_clusters

    • max_cursor_result_set_size

    • query_group

    • require_ssl

    • search_path

    • statement_timeout

    • use_fips_ssl

    For more information about these parameters, see Amazon Redshift parameter groups.

  6. Enter your changes and then choose Save to update the parameter group.

To modify the WLM configuration for a parameter group
  1. Sign in to the AWS Management Console and open the Amazon Redshift console at https://console.aws.amazon.com/redshiftv2/.

  2. On the navigation menu, choose Configurations, then choose Workload management to display the Workload management page.

  3. Choose the parameter group that you want to modify to display the details page with tabs for Parameters and Workload management.

  4. Choose the Workload management tab to view the current WLM configuration.

  5. Choose Edit workload queues to edit the WLM configuration,

  6. (Optional) Select Enable short query acceleration to enable short query acceleration (SQA).

    When you enable SQA, Maximum run time for short queries (1 to 20 seconds) is set to Dynamic by default. To set the maximum runtime to a fixed value, choose a value of 1–20.

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

    • Choose Switch WLM mode to choose between Automatic WLM and Manual WLM.

      With Automatic WLM, the Memory and Concurrency on main values are set to auto.

    • To create a queue, choose Edit workload queues, then choose Add Queue.

    • To modify a queue, change property values in the table. Depending on the type of queue, properties can include the following:

      • Queue name can be changed.

      • Memory (%)

      • Concurrency on main cluster

      • Concurrency scaling mode can be off or auto

      • Timeout (ms)

      • User groups

      • Query groups

      • User roles

      For more information about these properties, see Properties for the wlm_json_configuration parameter.

      Important

      If you change a queue name, the QueueName dimension value of WLM queue metrics (such as, WLMQueueLength, WLMQueueWaitTime, WLMQueriesCompletedPerSecond, WLMQueryDuration, WLMRunningQueries, and so on) also changes. So, if you change the name of a queue, you might need to change CloudWatch alarms you have set up.

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

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

  8. (Optional) Select Defer dynamic changes until reboot to have the changes applied to clusters after their next reboot.

    Note

    Some changes require a cluster reboot regardless of this setting. For more information, see WLM dynamic and static properties.

  9. Choose Save.

Creating or modifying a query monitoring rule using the console

You can use the Amazon Redshift console to create and modify WLM query monitoring rules. Query monitoring rules are part of the WLM configuration parameter for a parameter group. If you modify a query monitoring rule (QMR), the change happens automatically without the need to modify the cluster. 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/redshiftv2/.

  2. On the navigation menu, choose Configurations, then choose Workload management to display the Workload management page.

  3. Choose the parameter group that you want to modify to display the details page with tabs for Parameters and Workload management.

  4. Choose the Workload management tab, and choose Edit workload queues to edit the WLM configuration,

  5. Add a new rule either by using a predefined template or from scratch.

    To use a predefined template, do the following:

    1. Choose Add rule from template in the Query monitoring rules group. The list of rule templates is displayed.

    2. Choose one or more rule templates. When you choose Save, WLM creates one rule for each template that you choose.

    3. Enter or confirm values for the rule, including Rule names, Predicates and Actions.

    4. Choose Save.

    To add a new rule from scratch, do the following:

    1. To add additional predicates, choose Add predicate. You can have up to three predicates for each rule. If all of the predicates are met, WLM triggers the associated action.

    2. Choose an Action. Each rule has one action.

    3. Choose Save.

Amazon Redshift generates your WLM configuration parameter in JSON format and displays it in the JSON section.

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

  2. On the navigation menu, choose Configurations, then choose Workload management to display the Workload management page.

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

    Note

    You can't delete the default parameter group.

  4. Choose Delete and confirm that you want to delete the parameter group.

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.