CreateClusterParameterGroup - Amazon Redshift


Creates an Amazon Redshift parameter group.

Creating parameter groups is independent of creating clusters. You can associate a cluster with a parameter group when you create the cluster. You can also associate an existing cluster with a parameter group after the cluster is created by using ModifyCluster.

Parameters in the parameter group define specific behavior that applies to the databases you create on the cluster. For more information about parameters and parameter groups, go to Amazon Redshift Parameter Groups in the Amazon Redshift Cluster Management Guide.

Request Parameters

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


A description of the parameter group.

Type: String

Required: Yes


The Amazon Redshift engine version to which the cluster parameter group applies. The cluster engine version determines the set of parameters.

To get a list of valid parameter group family names, you can call DescribeClusterParameterGroups. By default, Amazon Redshift returns a list of all the parameter groups that are owned by your AWS account, including the default parameter groups for each Amazon Redshift engine version. The parameter group family names associated with the default parameter groups provide you the valid values. For example, a valid family name is "redshift-1.0".

Type: String

Required: Yes


The name of the cluster parameter group.


  • Must be 1 to 255 alphanumeric characters or hyphens

  • First character must be a letter.

  • Cannot end with a hyphen or contain two consecutive hyphens.

  • Must be unique withing your AWS account.


This value is stored as a lower-case string.

Type: String

Required: Yes


A list of tag instances.

Type: Array of Tag objects

Required: No

Response Elements

The following element is returned by the service.


Describes a parameter group.

Type: ClusterParameterGroup object


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


A cluster parameter group with the same name already exists.

HTTP Status Code: 400


The request would result in the user exceeding the allowed number of cluster parameter groups. For information about increasing your quota, go to Limits in Amazon Redshift in the Amazon Redshift Cluster Management Guide.

HTTP Status Code: 400


The tag is invalid.

HTTP Status Code: 400


You have exceeded the number of tags allowed.

HTTP Status Code: 400


Sample Request ?Action=CreateClusterParameterGroup &ParameterGroupName=myclusterparametergroup &ParameterGroupFamily=redshift-1.0 &Description=My+first+cluster+parameter+group &SignatureMethod=HmacSHA256&SignatureVersion=4 &Version=2012-12-01 &X-Amz-Algorithm=AWS4-HMAC-SHA256 &X-Amz-Credential=AKIAIOSFODNN7EXAMPLE/20190817/us-east-2/redshift/aws4_request &X-Amz-Date=20190825T160000Z &X-Amz-SignedHeaders=content-type;host;user-agent;x-amz-content-sha256;x-amz-date &X-Amz-Signature=0aa1234bb5cc678ddddd901ee2ff3aa45678b90c12d345e6ff789012345a6b7b

Sample Response

<CreateClusterParameterGroupResponse xmlns=""> <CreateClusterParameterGroupResult> <ClusterParameterGroup> <ParameterGroupName>myclusterparametergroup</ParameterGroupName> <Description>My first cluster parameter group</Description> <ParameterGroupFamily>redshift-1.0</ParameterGroupFamily> <Tags/> </ClusterParameterGroup> </CreateClusterParameterGroupResult> <ResponseMetadata> <RequestId>d52df43b-281e-11ea-8314-974e2ba81189</RequestId> </ResponseMetadata> </CreateClusterParameterGroupResponse>

See Also

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