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

CreateClusterParameterGroup

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.

Description

A description of the parameter group.

Type: String

Required: Yes

ParameterGroupFamily

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

ParameterGroupName

The name of the cluster parameter group.

Constraints:

  • 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.

Note

This value is stored as a lower-case string.

Type: String

Required: Yes

Tags.Tag.N

A list of tag instances.

Type: Array of Tag objects

Required: No

Response Elements

The following element is returned by the service.

ClusterParameterGroup

Describes a parameter group.

Type: ClusterParameterGroup object

Errors

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

ClusterParameterGroupAlreadyExists

A cluster parameter group with the same name already exists.

HTTP Status Code: 400

ClusterParameterGroupQuotaExceeded

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

InvalidTagFault

The tag is invalid.

HTTP Status Code: 400

TagLimitExceededFault

The request exceeds the limit of 10 tags for the resource.

HTTP Status Code: 400

Example

Sample Request

https://redshift.us-east-1.amazonaws.com/ ?Action=CreateClusterParameterGroup &Description=description my parameter group &ParameterGroupFamily=redshift-1.0 &ParameterGroupName=parametergroup1 &Version=2012-12-01 &x-amz-algorithm=AWS4-HMAC-SHA256 &x-amz-credential=AKIAIOSFODNN7EXAMPLE/20130123/us-east-1/redshift/aws4_request &x-amz-date=20130123T002544Z &x-amz-signedheaders=content-type;host;x-amz-date

Sample Response

<CreateClusterParameterGroupResponse xmlns="http://redshift.amazonaws.com/doc/2012-12-01/"> <CreateClusterParameterGroupResult> <ClusterParameterGroup> <ParameterGroupFamily>redshift-1.0</ParameterGroupFamily> <Description>description my parameter group</Description> <ParameterGroupName>parametergroup1</ParameterGroupName> </ClusterParameterGroup> </CreateClusterParameterGroupResult> <ResponseMetadata> <RequestId>6d6df847-64f3-11e2-bea9-49e0ce183f07</RequestId> </ResponseMetadata> </CreateClusterParameterGroupResponse>

See Also

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