1**Example 1: To describe the parameters in a DB cluster parameter group** 2 3The following ``describe-db-cluster-parameters`` example retrieves details about the parameters in a DB cluster parameter group. :: 4 5 aws rds describe-db-cluster-parameters \ 6 --db-cluster-parameter-group-name mydbclusterpg 7 8Output:: 9 10 { 11 "Parameters": [ 12 { 13 "ParameterName": "allow-suspicious-udfs", 14 "Description": "Controls whether user-defined functions that have only an xxx symbol for the main function can be loaded", 15 "Source": "engine-default", 16 "ApplyType": "static", 17 "DataType": "boolean", 18 "AllowedValues": "0,1", 19 "IsModifiable": false, 20 "ApplyMethod": "pending-reboot", 21 "SupportedEngineModes": [ 22 "provisioned" 23 ] 24 }, 25 { 26 "ParameterName": "aurora_lab_mode", 27 "ParameterValue": "0", 28 "Description": "Enables new features in the Aurora engine.", 29 "Source": "engine-default", 30 "ApplyType": "static", 31 "DataType": "boolean", 32 "AllowedValues": "0,1", 33 "IsModifiable": true, 34 "ApplyMethod": "pending-reboot", 35 "SupportedEngineModes": [ 36 "provisioned" 37 ] 38 }, 39 ...some output truncated... 40 ] 41 } 42 43**Example 2: To list only the parameter names in a DB cluster parameter group** 44 45The following ``describe-db-cluster-parameters`` example retrieves only the names of the parameters in a DB cluster parameter group. :: 46 47 aws rds describe-db-cluster-parameters \ 48 --db-cluster-parameter-group-name default.aurora-mysql5.7 \ 49 --query 'Parameters[].{ParameterName:ParameterName}' 50 51Output:: 52 53 [ 54 { 55 "ParameterName": "allow-suspicious-udfs" 56 }, 57 { 58 "ParameterName": "aurora_binlog_read_buffer_size" 59 }, 60 { 61 "ParameterName": "aurora_binlog_replication_max_yield_seconds" 62 }, 63 { 64 "ParameterName": "aurora_binlog_use_large_read_buffer" 65 }, 66 { 67 "ParameterName": "aurora_lab_mode" 68 }, 69 70 ...some output truncated... 71 } 72 ] 73 74**Example 3: To describe only the modifiable parameters in a DB cluster parameter group** 75 76The following ``describe-db-cluster-parameters`` example retrieves the names of only the parameters that you can modify in a DB cluster parameter group. :: 77 78 aws rds describe-db-cluster-parameters \ 79 --db-cluster-parameter-group-name default.aurora-mysql5.7 \ 80 --query 'Parameters[].{ParameterName:ParameterName,IsModifiable:IsModifiable} | [?IsModifiable == `true`]' 81 82Output:: 83 84 [ 85 { 86 "ParameterName": "aurora_binlog_read_buffer_size", 87 "IsModifiable": true 88 }, 89 { 90 "ParameterName": "aurora_binlog_replication_max_yield_seconds", 91 "IsModifiable": true 92 }, 93 { 94 "ParameterName": "aurora_binlog_use_large_read_buffer", 95 "IsModifiable": true 96 }, 97 { 98 "ParameterName": "aurora_lab_mode", 99 "IsModifiable": true 100 }, 101 102 ...some output truncated... 103 } 104 ] 105 106**Example 4: To describe only the modifable Boolean parameters in a DB cluster parameter group** 107 108The following ``describe-db-cluster-parameters`` example retrieves the names of only the parameters that you can modify in a DB cluster parameter group and that have a Boolean data type. :: 109 110 aws rds describe-db-cluster-parameters \ 111 --db-cluster-parameter-group-name default.aurora-mysql5.7 \ 112 --query 'Parameters[].{ParameterName:ParameterName,DataType:DataType,IsModifiable:IsModifiable} | [?DataType == `boolean`] | [?IsModifiable == `true`]' 113 114Output:: 115 116 [ 117 { 118 "DataType": "boolean", 119 "ParameterName": "aurora_binlog_use_large_read_buffer", 120 "IsModifiable": true 121 }, 122 { 123 "DataType": "boolean", 124 "ParameterName": "aurora_lab_mode", 125 "IsModifiable": true 126 }, 127 { 128 "DataType": "boolean", 129 "ParameterName": "autocommit", 130 "IsModifiable": true 131 }, 132 { 133 "DataType": "boolean", 134 "ParameterName": "automatic_sp_privileges", 135 "IsModifiable": true 136 }, 137 ...some output truncated... 138 } 139 ] 140 141For more information, see `Working with DB Parameter Groups and DB Cluster Parameter Groups <https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/USER_WorkingWithParamGroups.html>`__ in the *Amazon Aurora User Guide*. 142