AmazonRedshiftClient.ModifyClusterParameterGroup Method (ModifyClusterParameterGroupRequest)

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.

Note:

For .NET Core this operation is only available in asynchronous form. Please refer to ModifyClusterParameterGroupAsync.

Namespace: Amazon.Redshift
Assembly: AWSSDK.Redshift.dll
Version: 3.x.y.z

Syntax

public virtual ModifyClusterParameterGroupResponse ModifyClusterParameterGroup(
         ModifyClusterParameterGroupRequest request
)

Parameters

request: Type: Amazon.Redshift.Model.ModifyClusterParameterGroupRequest

Container for the necessary parameters to execute the ModifyClusterParameterGroup service method.

Return Value

Type: ModifyClusterParameterGroupResponse

The response from the ModifyClusterParameterGroup service method, as returned by Redshift.

Exceptions

Exception	Condition
ClusterParameterGroupNotFoundException	The parameter group name does not refer to an existing parameter group.
InvalidClusterParameterGroupStateException	The cluster parameter group action can not be completed because another task is in progress that involves the parameter group. Wait a few moments and try the operation again.

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 Framework:
Supported in: 4.5, 4.0, 3.5

AmazonRedshiftClient.ModifyClusterParameterGroup (ModifyClusterParameterGroupRequest)

Method