Container for the parameters to the ModifyClusterParameterGroup operation. Modifies the parameters of a parameter group. For the parameters parameter, it can't contain ASCII characters.
For more information about parameters and parameter groups, go to Amazon Redshift Parameter Groups in the Amazon Redshift Cluster Management Guide.
Inheritance Hierarchy
Amazon.Runtime.AmazonWebServiceRequest
Amazon.Redshift.AmazonRedshiftRequest
Amazon.Redshift.Model.ModifyClusterParameterGroupRequest
Namespace: Amazon.Redshift.Model
Assembly: AWSSDK.Redshift.dll
Version: 3.x.y.z
Syntax
public class ModifyClusterParameterGroupRequest : AmazonRedshiftRequest IAmazonWebServiceRequest
The ModifyClusterParameterGroupRequest type exposes the following members
Constructors
| Name | Description | |
|---|---|---|
|
ModifyClusterParameterGroupRequest() |
Properties
| Name | Type | Description | |
|---|---|---|---|
|
|
ParameterGroupName | System.String |
Gets and sets the property ParameterGroupName. The name of the parameter group to be modified. |
|
|
Parameters | System.Collections.Generic.List<Amazon.Redshift.Model.Parameter> |
Gets and sets the property Parameters. An array of parameters to be modified. A maximum of 20 parameters can be modified in a single request. For each parameter to be modified, you must supply at least the parameter name and parameter value; other name-value pairs of the parameter are optional. For the workload management (WLM) configuration, you must supply all the name-value pairs in the wlm_json_configuration parameter. |
Examples
This example shows how to modify the parameter group wlm_json_configuration parameter for workload management.
To modify a paramter group
var client = new AmazonRedshiftClient();
var response = client.ModifyClusterParameterGroup(new ModifyClusterParameterGroupRequest
{
ParameterGroupName = "myclusterparametergroup",
Parameters = new List<Parameter> {
new Parameter {
ApplyType = "dynamic",
ParameterName = "wlm_json_configuration",
ParameterValue = "[{\"query_group\":[\"report\"], \"query_group_wild_card\":1, \"query_concurrency\":4, \"max_execution_time\":20000, \"memory_percent_to_use\":25, \"rules\": [{\"rule_name\": \"rule_1\", \"predicate\": [{\"metric_name\": \"query_cpu_time\", \"operator\": \">\", \"value\": 1000000}, {\"metric_name\": \"query_blocks_read\", \"operator\": \">\", \"value\": 1000}], \"action\": \"log\"}] }, {\"user_group\":[\"admin\",\"dba\"], \"user_group_wild_card\":0, \"query_concurrency\":5, \"memory_percent_to_use\":40, \"rules\": [{\"rule_name\": \"rule_2\", \"predicate\": [{\"metric_name\": \"query_execution_time\", \"operator\": \">\", \"value\": 10000}, {\"metric_name\": \"scan_row_count\", \"operator\": \">\", \"value\": 1000000000}], \"action\": \"hop\"}] }, {\"query_concurrency\":5, \"memory_percent_to_use\":35 } ]"
}
}
});
string parameterGroupName = response.ParameterGroupName;
string parameterGroupStatus = response.ParameterGroupStatus;
Version Information
.NET Core App:
Supported in: 3.1
.NET Standard:
Supported in: 2.0
.NET Framework:
Supported in: 4.5, 4.0, 3.5