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

DescribeClusterParameterGroups

Returns a list of Amazon Redshift parameter groups, including parameter groups you created and the default parameter group. For each parameter group, the response includes the parameter group name, description, and parameter group family name. You can optionally specify a name to retrieve the description of a specific parameter group.

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

If you specify both tag keys and tag values in the same request, Amazon Redshift returns all parameter groups that match any combination of the specified keys and values. For example, if you have owner and environment for tag keys, and admin and test for tag values, all parameter groups that have any combination of those values are returned.

If both tag keys and values are omitted from the request, parameter groups are returned regardless of whether they have tag keys or values associated with them.

Request Parameters

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

Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeClusterParameterGroups request exceed the value specified in MaxRecords, AWS returns a value in the Marker field of the response. You can retrieve the next set of response records by providing the returned marker value in the Marker parameter and retrying the request.

Type: String

Required: No

MaxRecords

The maximum number of response records to return in each call. If the number of remaining response records exceeds the specified MaxRecords value, a value is returned in a marker field of the response. You can retrieve the next set of records by retrying the command with the returned marker value.

Default: 100

Constraints: minimum 20, maximum 100.

Type: Integer

Required: No

ParameterGroupName

The name of a specific parameter group for which to return details. By default, details about all parameter groups and the default parameter group are returned.

Type: String

Required: No

TagKeys.TagKey.N

A tag key or keys for which you want to return all matching cluster parameter groups that are associated with the specified key or keys. For example, suppose that you have parameter groups that are tagged with keys called owner and environment. If you specify both of these tag keys in the request, Amazon Redshift returns a response with the parameter groups that have either or both of these tag keys associated with them.

Type: Array of strings

Required: No

TagValues.TagValue.N

A tag value or values for which you want to return all matching cluster parameter groups that are associated with the specified tag value or values. For example, suppose that you have parameter groups that are tagged with values called admin and test. If you specify both of these tag values in the request, Amazon Redshift returns a response with the parameter groups that have either or both of these tag values associated with them.

Type: Array of strings

Required: No

Response Elements

The following elements are returned by the service.

Marker

A value that indicates the starting point for the next set of response records in a subsequent request. If a value is returned in a response, you can retrieve the next set of records by providing this returned marker value in the Marker parameter and retrying the command. If the Marker field is empty, all response records have been retrieved for the request.

Type: String

ParameterGroups.ClusterParameterGroup.N

A list of ClusterParameterGroup instances. Each instance describes one cluster parameter group.

Type: Array of ClusterParameterGroup objects

Errors

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

ClusterParameterGroupNotFound

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

HTTP Status Code: 404

InvalidTagFault

The tag is invalid.

HTTP Status Code: 400

Example

Sample Request

https://redshift.us-east-1.amazonaws.com/
    ?Action=DescribeClusterParameterGroups
    &Version=2012-12-01
    &x-amz-algorithm=AWS4-HMAC-SHA256
    &x-amz-credential=AKIAIOSFODNN7EXAMPLE/20130123/us-east-1/redshift/aws4_request
    &x-amz-date=20130123T004002Z
    &x-amz-signedheaders=content-type;host;x-amz-date

Sample Response

<DescribeClusterParameterGroupsResponse xmlns="http://redshift.amazonaws.com/doc/2012-12-01/">
  <DescribeClusterParameterGroupsResult>
    <ParameterGroups>
      <ClusterParameterGroup>
        <ParameterGroupFamily>redshift-1.0</ParameterGroupFamily>
        <Description>Default parameter group for redshift-1.0</Description>
        <ParameterGroupName>default.redshift-1.0</ParameterGroupName>
      </ClusterParameterGroup>
      <ClusterParameterGroup>
        <ParameterGroupFamily>redshift-1.0</ParameterGroupFamily>
        <Description>description my parameter group</Description>
        <ParameterGroupName>parametergroup1</ParameterGroupName>
      </ClusterParameterGroup>
    </ParameterGroups>
  </DescribeClusterParameterGroupsResult>
  <ResponseMetadata>
    <RequestId>6d28788b-64f5-11e2-b343-393adc3f0a21</RequestId>
  </ResponseMetadata>
</DescribeClusterParameterGroupsResponse>

See Also

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