User guide

"q2_second_property_name":"q2_second_property_value",
...
}
...
]"
}
]
In the preceding example, the representative properties that begin with q1 are objects in an array for the
first queue. Each of these objects is a name/value pair; name and value together set the WLM properties
for the first queue.The representative properties that begin with q2 are objects in an array for the second
queue. If you require more queues, you add another array for each additional queue and set the properties
for each object.
Configuring WLM by Using the AWS CLI
To configure Amazon Redshift parameters by using the AWS CLI, you use the
modify-cluster-parameter-group command for a specific parameter group.You specify the
parameter group to modify in parameter-group-name.You use the parameters parameter (for the
modify-cluster-parameter-group command) to specify name/value pairs for each parameter that
you want to modify in the parameter group. Separate each parameter from others with a space if you
modify multiple parameters in the same command.
The parameters parameter (for the modify-cluster-parameter-group command) uses the following
syntax, where parameter_name and parameter_value are each replaced with an actual parameter
to modify and a value for that parameter.
--parameters ParameterName=parameter_name,ParameterValue=parameter_value
The following example shows how to configure the statement_timeout and
enable_user_activity_logging parameters for the myclusterparametergroup parameter group.
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=statement_timeout,ParameterValue=20000 Parameter
Name=enable_user_activity_logging,ParameterValue=true
The wlm_json_configuration parameter requires a specific format when you use the AWS CLI.The
format that you use depends on your client operating system. Operating systems have different ways to
enclose the JSON structure so it's passed correctly from the command line. For details on how to construct
the appropriate command in the Linux, Mac OS X, and Windows operating systems, see the sections
following.
For more information about the differences in enclosing JSON data structures in the AWS CLI in general,
see Quoting Strings in the AWS Command Line Interface User Guide. For more information about workload
management, go to Implementing Workload Management in the Amazon Redshift Developer Guide.
API Version 2012-12-01
70
Amazon Redshift Management Guide
Configuring the wlm_json_configuration Parameter