RDS / Client / describe_option_groups

describe_option_groups#

RDS.Client.describe_option_groups(**kwargs)#

Describes the available option groups.

See also: AWS API Documentation

Request Syntax

response = client.describe_option_groups(
    OptionGroupName='string',
    Filters=[
        {
            'Name': 'string',
            'Values': [
                'string',
            ]
        },
    ],
    Marker='string',
    MaxRecords=123,
    EngineName='string',
    MajorEngineVersion='string'
)
Parameters:
  • OptionGroupName (string) – The name of the option group to describe. Can’t be supplied together with EngineName or MajorEngineVersion.

  • Filters (list) –

    This parameter isn’t currently supported.

    • (dict) –

      A filter name and value pair that is used to return a more specific list of results from a describe operation. Filters can be used to match a set of resources by specific criteria, such as IDs. The filters supported by a describe operation are documented with the describe operation.

      Note

      Currently, wildcards are not supported in filters.

      The following actions can be filtered:

      • DescribeDBClusterBacktracks

      • DescribeDBClusterEndpoints

      • DescribeDBClusters

      • DescribeDBInstances

      • DescribeDBRecommendations

      • DescribeDBShardGroups

      • DescribePendingMaintenanceActions

      • Name (string) – [REQUIRED]

        The name of the filter. Filter names are case-sensitive.

      • Values (list) – [REQUIRED]

        One or more filter values. Filter values are case-sensitive.

        • (string) –

  • Marker (string) – An optional pagination token provided by a previous DescribeOptionGroups request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

  • MaxRecords (integer) –

    The maximum number of records to include in the response. If more records exist than the specified MaxRecords value, a pagination token called a marker is included in the response so that you can retrieve the remaining results.

    Default: 100

    Constraints: Minimum 20, maximum 100.

  • EngineName (string) –

    A filter to only include option groups associated with this database engine.

    Valid Values:

    • db2-ae

    • db2-se

    • mariadb

    • mysql

    • oracle-ee

    • oracle-ee-cdb

    • oracle-se2

    • oracle-se2-cdb

    • postgres

    • sqlserver-ee

    • sqlserver-se

    • sqlserver-ex

    • sqlserver-web

  • MajorEngineVersion (string) – Filters the list of option groups to only include groups associated with a specific database engine version. If specified, then EngineName must also be specified.

Return type:

dict

Returns:

Response Syntax

{
    'OptionGroupsList': [
        {
            'OptionGroupName': 'string',
            'OptionGroupDescription': 'string',
            'EngineName': 'string',
            'MajorEngineVersion': 'string',
            'Options': [
                {
                    'OptionName': 'string',
                    'OptionDescription': 'string',
                    'Persistent': True|False,
                    'Permanent': True|False,
                    'Port': 123,
                    'OptionVersion': 'string',
                    'OptionSettings': [
                        {
                            'Name': 'string',
                            'Value': 'string',
                            'DefaultValue': 'string',
                            'Description': 'string',
                            'ApplyType': 'string',
                            'DataType': 'string',
                            'AllowedValues': 'string',
                            'IsModifiable': True|False,
                            'IsCollection': True|False
                        },
                    ],
                    'DBSecurityGroupMemberships': [
                        {
                            'DBSecurityGroupName': 'string',
                            'Status': 'string'
                        },
                    ],
                    'VpcSecurityGroupMemberships': [
                        {
                            'VpcSecurityGroupId': 'string',
                            'Status': 'string'
                        },
                    ]
                },
            ],
            'AllowsVpcAndNonVpcInstanceMemberships': True|False,
            'VpcId': 'string',
            'OptionGroupArn': 'string',
            'SourceOptionGroup': 'string',
            'SourceAccountId': 'string',
            'CopyTimestamp': datetime(2015, 1, 1)
        },
    ],
    'Marker': 'string'
}

Response Structure

  • (dict) –

    List of option groups.

    • OptionGroupsList (list) –

      List of option groups.

      • (dict) –

        • OptionGroupName (string) –

          Specifies the name of the option group.

        • OptionGroupDescription (string) –

          Provides a description of the option group.

        • EngineName (string) –

          Indicates the name of the engine that this option group can be applied to.

        • MajorEngineVersion (string) –

          Indicates the major engine version associated with this option group.

        • Options (list) –

          Indicates what options are available in the option group.

          • (dict) –

            The details of an option.

            • OptionName (string) –

              The name of the option.

            • OptionDescription (string) –

              The description of the option.

            • Persistent (boolean) –

              Indicates whether this option is persistent.

            • Permanent (boolean) –

              Indicates whether this option is permanent.

            • Port (integer) –

              If required, the port configured for this option to use.

            • OptionVersion (string) –

              The version of the option.

            • OptionSettings (list) –

              The option settings for this option.

              • (dict) –

                Option settings are the actual settings being applied or configured for that option. It is used when you modify an option group or describe option groups. For example, the NATIVE_NETWORK_ENCRYPTION option has a setting called SQLNET.ENCRYPTION_SERVER that can have several different values.

                • Name (string) –

                  The name of the option that has settings that you can set.

                • Value (string) –

                  The current value of the option setting.

                • DefaultValue (string) –

                  The default value of the option setting.

                • Description (string) –

                  The description of the option setting.

                • ApplyType (string) –

                  The DB engine specific parameter type.

                • DataType (string) –

                  The data type of the option setting.

                • AllowedValues (string) –

                  The allowed values of the option setting.

                • IsModifiable (boolean) –

                  Indicates whether the option setting can be modified from the default.

                • IsCollection (boolean) –

                  Indicates whether the option setting is part of a collection.

            • DBSecurityGroupMemberships (list) –

              If the option requires access to a port, then this DB security group allows access to the port.

              • (dict) –

                This data type is used as a response element in the following actions:

                • ModifyDBInstance

                • RebootDBInstance

                • RestoreDBInstanceFromDBSnapshot

                • RestoreDBInstanceToPointInTime

                • DBSecurityGroupName (string) –

                  The name of the DB security group.

                • Status (string) –

                  The status of the DB security group.

            • VpcSecurityGroupMemberships (list) –

              If the option requires access to a port, then this VPC security group allows access to the port.

              • (dict) –

                This data type is used as a response element for queries on VPC security group membership.

                • VpcSecurityGroupId (string) –

                  The name of the VPC security group.

                • Status (string) –

                  The membership status of the VPC security group.

                  Currently, the only valid status is active.

        • AllowsVpcAndNonVpcInstanceMemberships (boolean) –

          Indicates whether this option group can be applied to both VPC and non-VPC instances. The value true indicates the option group can be applied to both VPC and non-VPC instances.

        • VpcId (string) –

          If AllowsVpcAndNonVpcInstanceMemberships is false, this field is blank. If AllowsVpcAndNonVpcInstanceMemberships is true and this field is blank, then this option group can be applied to both VPC and non-VPC instances. If this field contains a value, then this option group can only be applied to instances that are in the VPC indicated by this field.

        • OptionGroupArn (string) –

          Specifies the Amazon Resource Name (ARN) for the option group.

        • SourceOptionGroup (string) –

          Specifies the name of the option group from which this option group is copied.

        • SourceAccountId (string) –

          Specifies the Amazon Web Services account ID for the option group from which this option group is copied.

        • CopyTimestamp (datetime) –

          Indicates when the option group was copied.

    • Marker (string) –

      An optional pagination token provided by a previous request. If this parameter is specified, the response includes only records beyond the marker, up to the value specified by MaxRecords.

Exceptions

Examples

This example lists information for all option groups for the specified DB engine.

response = client.describe_option_groups(
    EngineName='mysql',
    MajorEngineVersion='5.6',
)

print(response)

Expected Output:

{
    'ResponseMetadata': {
        '...': '...',
    },
}