User guide

Rules for Configuring WLM by Using the AWS CLI in the Command Line
on the Linux and Mac OS X Operating Systems
• The entire JSON structure must be enclosed in single 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 (").
• 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 for the Linux and Mac OS X 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\"],\"concurrency_level\":7},{\"concur
rency_level\":5}]"}]’
Rules for Configuring WLM by Using the AWS CLI in Windows PowerShell
on Microsoft Windows Operating Systems
• The entire JSON structure must be enclosed in single 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 for Windows PowerShell on Windows
operating systems.
API Version 2012-12-01
71
Amazon Redshift Management Guide
Configuring the wlm_json_configuration Parameter