User guide

Note

For readability purposes, the example is displayed on two lines, but in the actual AWS CLI this

would be one line.

aws redshift modify-cluster-parameter-group --parameter-group-name mycluster

parametergroup

--parameters '[{\"ParameterName\":\"wlm_json_configuration\", \"Parameter

Value\":\"[{\\\"query_group\\\":[\\\"test\\\"],\\\"concur

rency_level\\\":7},{\\\"concurrency_level\\\":5}]\"}]’

Rules for Configuring WLM by Using the Command Prompt on Windows

Operating Systems

• The entire JSON structure must be enclosed in double-quotation marks (") and brackets ([ ]).

• All parameter names and parameter values must be enclosed in double quotation marks (").

• Within the ParameterValue value, you must enclose the entire nested structure in double-quotation

marks (") and brackets ([ ]).

• Within the nested structure, each of the properties and values for each queue must be enclosed in

curly braces ({ }).

• Within the nested structure, you must use the backslash (\) escape character before each

double-quotation mark (") and its backslash (\) escape character.This requirement means that you will

use three backslashes and a double quotation mark to make sure that the properties are passed in

correctly (\\\:).

• For name/value pairs, a colon (:) separates each property from its value.

• Each name/value pair is separated from another by a comma (,).

• Multiple queues are separated by a comma (,) between the end of one queue's curly brace (}) and the

beginning of the next queue's curly brace ({).

The following example shows how to configure two queues with different properties for a cluster parameter

group named myclusterparametergroup. This example works when using the command prompt on

Windows operating systems.

Note

For readability purposes, the example is displayed on two lines, but in the actual AWS CLI this

would be one line.

aws redshift modify-cluster-parameter-group --parameter-group-name mycluster

parametergroup

--parameters "[{\"ParameterName\":\"wlm_json_configuration\", \"Parameter

Value\":\"[{\\\"query_group\\\":[\\\"test\\\"],\\\"concur

rency_level\\\":7},{\\\"concurrency_level\\\":5}]\"}]"

Managing Parameter Groups Using the Console

Topics

• Creating a Parameter Group (p. 73)

• Modifying a Parameter Group (p. 74)

• Deleting a Parameter Group (p. 76)

• Associating a Parameter Group with a Cluster (p. 77)

API Version 2012-12-01

Amazon Redshift Management Guide

Managing Parameter Groups Using the Console