Amazon Redshift
API Reference (API Version 2012-12-01)

The AWS Documentation website is getting a new look!
Try it now and let us know what you think. Switch to the new look >>

You can return to the original look by selecting English in the language selector above.


Sets one or more parameters of the specified parameter group to their default values and sets the source values of the parameters to "engine-default". To reset the entire parameter group specify the ResetAllParameters parameter. For parameter changes to take effect you must reboot any associated clusters.

Request Parameters

For information about the parameters that are common to all actions, see Common Parameters.


The name of the cluster parameter group to be reset.

Type: String

Required: Yes


An array of names of parameters to be reset. If ResetAllParameters option is not used, then at least one parameter name must be supplied.

Constraints: A maximum of 20 parameters can be reset in a single request.

Type: Array of Parameter objects

Required: No


If true, all parameters in the specified parameter group will be reset to their default values.

Default: true

Type: Boolean

Required: No

Response Elements

The following elements are returned by the service.


The name of the cluster parameter group.

Type: String


The status of the parameter group. For example, if you made a change to a parameter group name-value pair, then the change could be pending a reboot of an associated cluster.

Type: String


For information about the errors that are common to all actions, see Common Errors.


The parameter group name does not refer to an existing parameter group.

HTTP Status Code: 404


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.

HTTP Status Code: 400


Sample Request ?Action=ResetClusterParameterGroup &ParameterGroupName=parametergroup1 &Parameters.member.1.ParameterName=extra_float_digits &Version=2012-12-01 &x-amz-algorithm=AWS4-HMAC-SHA256 &x-amz-credential=AKIAIOSFODNN7EXAMPLE/20121208/us-east-1/redshift/aws4_request &x-amz-date=20121208T020847Z &x-amz-signedheaders=content-type;host;x-amz-date

Sample Response

<ResetClusterParameterGroupResponse xmlns=""> <ResetClusterParameterGroupResult> <ParameterGroupStatus>Your parameter group has been updated. Updates to dynamic parameters will be applied immediately. Updates to static parameters will be applied when you reboot the associated Clusters.</ParameterGroupStatus> <ParameterGroupName>parametergroup1</ParameterGroupName> </ResetClusterParameterGroupResult> <ResponseMetadata> <RequestId>625d23c1-40dc-11e2-8a25-eb010998df4e</RequestId> </ResponseMetadata> </ResetClusterParameterGroupResponse>

See Also

For more information about using this API in one of the language-specific AWS SDKs, see the following: