AWS SDK Version 3 for .NET
API Reference

AWS services or capabilities described in AWS Documentation may vary by region/location. Click Getting Started with Amazon AWS to see specific differences applicable to the China (Beijing) Region.

Modifies the parameters of a parameter group.

For more information about parameters and parameter groups, go to Amazon Redshift Parameter Groups in the Amazon Redshift Cluster Management Guide.

Note:

For PCL 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

C#
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
The response from the ModifyClusterParameterGroup service method, as returned by Redshift.

Exceptions

ExceptionCondition
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 response = client.ModifyClusterParameterGroup(new ModifyClusterParameterGroupRequest 
{
    ParameterGroupName = "myclusterparametergroup",
    Parameters = new List {
        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

Portable Class Library:
Supported in: Windows Store Apps
Supported in: Windows Phone 8.1
Supported in: Xamarin Android
Supported in: Xamarin iOS (Unified)
Supported in: Xamarin.Forms

See Also