aws redshift describe-cluster-parameters

Returns a detailed list of parameters contained within the specified Amazon Redshift parameter group. AWS CLI reference

1 example 4 options Its page in the AWS CLI reference

Examples

from aws-cli, each command read by CmdID

To retrieve the parameters for a specified cluster parameter group

The following describe-cluster-parameters example retrieves the parameters for the named parameter group. By default, the output is in JSON format.

aws redshift describe-cluster-parameters --parameter-group-name myclusterparametergroupIdentify

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

Its output

{
    "Parameters": [
        {
            "Description": "Sets the display format for date and time values.",
            "DataType": "string",
            "IsModifiable": true,
            "Source": "engine-default",
            "ParameterValue": "ISO, MDY",
            "ParameterName": "datestyle"
        },
        {
            "Description": "Sets the number of digits displayed for floating-point values",
            "DataType": "integer",
            "IsModifiable": true,
            "AllowedValues": "-15-2",
            "Source": "engine-default",
            "ParameterValue": "0",
            "ParameterName": "extra_float_digits"
        }
    ]
}

You can also obtain the same information in text format using the --output text option.

aws redshift describe-cluster-parameters --parameter-group-name myclusterparametergroup --output textIdentify

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

--outputThe formatting style for command output.

Its output

RESPONSEMETADATA    a1b2c3d4-5678-90ab-cdef-EXAMPLE11111
Sets the display format for date and time values.   string  True    engine-default  ISO, MDY        datestyle
Sets the number of digits displayed for floating-point values       integer True    -15-2   engine-default  0       extra_float_digits
This parameter applies a user-defined label to a group of queries that are run during the same session..    string  True    engine-default  default query_group
require ssl for all databaseconnections     boolean True    true,false      engine-default  false   require_ssl
Sets the schema search order for names that are not schema-qualified.       string  True    engine-default  $user, public   search_path
Aborts any statement that takes over the specified number of milliseconds.  integer True    engine-default  0       statement_timeout
wlm json configuration      string  True    engine-default  \[{"query_concurrency":5}]      wlm_json_configuration

For more information, see Amazon Redshift parameter groups in the Amazon Redshift Management Guide.

Options

4 in the AWS CLI reference

--markerAn optional parameter that specifies the starting point to return a set of response records.

--max-recordsThe maximum number of response records to return in each call.

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

--sourceThe parameter types to return.