选择您的 Cookie 首选项

我们使用必要 Cookie 和类似工具提供我们的网站和服务。我们使用性能 Cookie 收集匿名统计数据,以便我们可以了解客户如何使用我们的网站并进行改进。必要 Cookie 无法停用,但您可以单击“自定义”或“拒绝”来拒绝性能 Cookie。

如果您同意,AWS 和经批准的第三方还将使用 Cookie 提供有用的网站功能、记住您的首选项并显示相关内容,包括相关广告。要接受或拒绝所有非必要 Cookie,请单击“接受”或“拒绝”。要做出更详细的选择,请单击“自定义”。

DescribeClusterParameters - Amazon Redshift
此页面尚未翻译为您的语言。 请求翻译

DescribeClusterParameters

Returns a detailed list of parameters contained within the specified Amazon Redshift parameter group. For each parameter the response includes information such as parameter name, description, data type, value, whether the parameter value is modifiable, and so on.

You can specify source filter to retrieve parameters of only specific type. For example, to retrieve parameters that were modified by a user action such as from ModifyClusterParameterGroup, you can specify source equal to user.

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.

ParameterGroupName

The name of a cluster parameter group for which to return details.

Type: String

Length Constraints: Maximum length of 2147483647.

Required: Yes

Marker

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

Length Constraints: Maximum length of 2147483647.

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

Source

The parameter types to return. Specify user to show parameters that are different form the default. Similarly, specify engine-default to show parameters that are the same as the default parameter group.

Default: All parameter types returned.

Valid Values: user | engine-default

Type: String

Length Constraints: Maximum length of 2147483647.

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

Length Constraints: Maximum length of 2147483647.

Parameters.Parameter.N

A list of Parameter instances. Each instance lists the parameters of one cluster parameter group.

Type: Array of Parameter 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

Examples

Example

This example illustrates one usage of DescribeClusterParameters.

Sample Request

https://redshift.us-east-2.amazonaws.com/ ?Action=DescribeClusterParameters &ParameterGroupName=myclusterparametergroup &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

<DescribeClusterParametersResponse xmlns="http://redshift.amazonaws.com/doc/2012-12-01/"> <DescribeClusterParametersResult> <Parameters> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>true,false</AllowedValues> <DataType>boolean</DataType> <Description>Use auto analyze</Description> <Source>engine-default</Source> <ParameterName>auto_analyze</ParameterName> <ParameterValue>true</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <DataType>string</DataType> <Description>Sets the display format for date and time values.</Description> <Source>engine-default</Source> <ParameterName>datestyle</ParameterName> <ParameterValue>ISO, MDY</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>true,false</AllowedValues> <DataType>boolean</DataType> <Description>parameter for audit logging purpose</Description> <Source>engine-default</Source> <ParameterName>enable_user_activity_logging</ParameterName> <ParameterValue>false</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>-15-2</AllowedValues> <DataType>integer</DataType> <Description>Sets the number of digits displayed for floating-point values</Description> <Source>engine-default</Source> <ParameterName>extra_float_digits</ParameterName> <ParameterValue>0</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>0-10</AllowedValues> <DataType>integer</DataType> <Description>The maximum concurrency scaling clusters can be used.</Description> <Source>engine-default</Source> <ParameterName>max_concurrency_scaling_clusters</ParameterName> <ParameterValue>1</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>0-14400000</AllowedValues> <DataType>integer</DataType> <Description>Sets the max cursor result set size</Description> <Source>engine-default</Source> <ParameterName>max_cursor_result_set_size</ParameterName> <ParameterValue>default</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <DataType>string</DataType> <Description>This parameter applies a user-defined label to a group of queries that are run during the same session..</Description> <Source>engine-default</Source> <ParameterName>query_group</ParameterName> <ParameterValue>default</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>true,false</AllowedValues> <DataType>boolean</DataType> <Description>require ssl for all databaseconnections</Description> <Source>engine-default</Source> <ParameterName>require_ssl</ParameterName> <ParameterValue>false</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <DataType>string</DataType> <Description>Sets the schema search order for names that are not schema-qualified.</Description> <Source>engine-default</Source> <ParameterName>search_path</ParameterName> <ParameterValue>$user, public</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>0,100-2147483647</AllowedValues> <DataType>integer</DataType> <Description>Stops any statement that takes over the specified number of milliseconds.</Description> <Source>engine-default</Source> <ParameterName>statement_timeout</ParameterName> <ParameterValue>0</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <AllowedValues>true,false</AllowedValues> <DataType>boolean</DataType> <Description>Use fips ssl library</Description> <Source>engine-default</Source> <ParameterName>use_fips_ssl</ParameterName> <ParameterValue>false</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> <Parameter> <ApplyType>static</ApplyType> <DataType>string</DataType> <Description>wlm json configuration</Description> <Source>engine-default</Source> <ParameterName>wlm_json_configuration</ParameterName> <ParameterValue>[{"auto_wlm":true}]</ParameterValue> <IsModifiable>true</IsModifiable> </Parameter> </Parameters> </DescribeClusterParametersResult> <ResponseMetadata> <RequestId>a22ce073-2831-11ea-a940-1b28a85fd753</RequestId> </ResponseMetadata> </DescribeClusterParametersResponse>

See Also

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

隐私网站条款Cookie 首选项
© 2025, Amazon Web Services, Inc. 或其附属公司。保留所有权利。