Skip to content
AWS for Query.Farm

aws.docdb.describe_db_engine_versions

Example SQL Queries

SELECT * FROM
aws.docdb.describe_db_engine_versions;

Description

Returns a list of the available engines.

Table Definition

Column NameColumn Data Type
db_parameter_group_family Input Column

The name of the parameter group family for the database engine.

VARCHAR
default_only Input Column

Indicates that only the default version of the specified engine or engine and major version combination is returned.

BOOLEAN
engine Input Column

The name of the database engine.

VARCHAR
engine_version Input Column

The version number of the database engine.

VARCHAR
filters Input Column

This parameter is not currently supported.

STRUCT(
    "name" VARCHAR,
    "values" VARCHAR[]
)[]
Show child fields
filters[]
Show child fields
filters[].name

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

filters[].values[]
list_supported_character_sets Input Column

If this parameter is specified and the requested engine supports the CharacterSetName parameter for CreateDBInstance, the response includes a list of supported character sets for each engine version. 

BOOLEAN
list_supported_timezones Input Column

If this parameter is specified and the requested engine supports the TimeZone parameter for CreateDBInstance, the response includes a list of supported time zones for each engine version. 

BOOLEAN
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

_aws_region Input Column

The AWS region to use.

VARCHAR
db_engine_description

The description of the database engine.

VARCHAR
db_engine_version_description

The description of the database engine version.

VARCHAR
exportable_log_types

The types of logs that the database engine has available for export to Amazon CloudWatch Logs.

VARCHAR[]
Show child fields
exportable_log_types[]
supported_ca_certificate_identifiers

A list of the supported CA certificate identifiers.

For more information, see Updating Your Amazon DocumentDB TLS Certificates and Encrypting Data in Transit in the Amazon DocumentDB Developer Guide.

VARCHAR[]
Show child fields
supported_ca_certificate_identifiers[]
supports_certificate_rotation_without_restart

Indicates whether the engine version supports rotating the server certificate without rebooting the DB instance.

BOOLEAN
supports_log_exports_to_cloudwatch_logs

A value that indicates whether the engine version supports exporting the log types specified by ExportableLogTypes to CloudWatch Logs.

BOOLEAN
valid_upgrade_target

A list of engine versions that this database engine version can be upgraded to.

STRUCT(
    "engine" VARCHAR,
    "engine_version" VARCHAR,
    "description" VARCHAR,
    "auto_upgrade" BOOLEAN,
    "is_major_version_upgrade" BOOLEAN
)[]
Show child fields
valid_upgrade_target[]
Show child fields
valid_upgrade_target[].auto_upgrade

A value that indicates whether the target version is applied to any source DB instances that have AutoMinorVersionUpgrade set to true.

valid_upgrade_target[].description

The version of the database engine that an instance can be upgraded to.

valid_upgrade_target[].engine

The name of the upgrade target database engine.

valid_upgrade_target[].engine_version

The version number of the upgrade target database engine.

valid_upgrade_target[].is_major_version_upgrade

A value that indicates whether a database engine is upgraded to a major version.