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

DescribeDefaultClusterParameters

Returns a list of parameter settings for the specified parameter group family.

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.

ParameterGroupFamily

The name of the cluster parameter group family.

Type: String

Required: Yes

Marker

An optional parameter that specifies the starting point to return a set of response records. When the results of a DescribeDefaultClusterParameters 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

Response Elements

The following element is returned by the service.

DefaultClusterParameters

Describes the default cluster parameters for a parameter group family.

Type: DefaultClusterParameters object

Errors

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

Example

Sample Request

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

Sample Response

<DescribeDefaultClusterParametersResponse xmlns="http://redshift.amazonaws.com/doc/2012-12-01/"> <DescribeDefaultClusterParametersResult> <DefaultClusterParameters> <ParameterGroupFamily>redshift-1.0</ParameterGroupFamily> <Parameters> <Parameter> <ParameterValue>ISO, MDY</ParameterValue> <DataType>string</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>Sets the display format for date and time values.</Description> <ParameterName>datestyle</ParameterName> </Parameter> <Parameter> <ParameterValue>0</ParameterValue> <DataType>integer</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>Sets the number of digits displayed for floating-point values</Description> <AllowedValues>-15-2</AllowedValues> <ParameterName>extra_float_digits</ParameterName> </Parameter> <Parameter> <ParameterValue>default</ParameterValue> <DataType>string</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>This parameter applies a user-defined label to a group of queries that are run during the same session..</Description> <ParameterName>query_group</ParameterName> </Parameter> <Parameter> <ParameterValue>false</ParameterValue> <DataType>boolean</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>require ssl for all databaseconnections</Description> <AllowedValues>true,false</AllowedValues> <ParameterName>require_ssl</ParameterName> </Parameter> <Parameter> <ParameterValue>$user, public</ParameterValue> <DataType>string</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>Sets the schema search order for names that are not schema-qualified.</Description> <ParameterName>search_path</ParameterName> </Parameter> <Parameter> <ParameterValue>0</ParameterValue> <DataType>integer</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>Aborts any statement that takes over the specified number of milliseconds.</Description> <ParameterName>statement_timeout</ParameterName> </Parameter> <Parameter> <ParameterValue>[{&quot;query_concurrency&quot;:5}]</ParameterValue> <DataType>string</DataType> <Source>engine-default</Source> <IsModifiable>true</IsModifiable> <Description>wlm json configuration</Description> <ParameterName>wlm_json_configuration</ParameterName> </Parameter> </Parameters> </DefaultClusterParameters> </DescribeDefaultClusterParametersResult> <ResponseMetadata> <RequestId>396df00b-40c4-11e2-82cf-0b45b05c0221</RequestId> </ResponseMetadata> </DescribeDefaultClusterParametersResponse>

See Also

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