Skip to content
AWS for Query.Farm

aws.rds.describe_db_engine_versions

Example SQL Queries

SELECT * FROM
aws.rds.describe_db_engine_versions;

Description

Describes the properties of specific versions of DB engines.

Table Definition

Column NameColumn Data Type
db_parameter_group_family Input Column

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

VARCHAR
default_only Input Column

Specifies whether to return only the default version of the specified engine or the engine and major version combination.

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

A filter that specifies one or more DB engine versions to describe.

Supported filters:

  • db-parameter-group-family - Accepts parameter groups family names. The results list only includes information about the DB engine versions for these parameter group families.

  • engine - Accepts engine names. The results list only includes information about the DB engine versions for these engines.

  • engine-mode - Accepts DB engine modes. The results list only includes information about the DB engine versions for these engine modes. Valid DB engine modes are the following:

    • global

    • multimaster

    • parallelquery

    • provisioned

    • serverless

  • engine-version - Accepts engine versions. The results list only includes information about the DB engine versions for these engine versions.

  • status - Accepts engine version statuses. The results list only includes information about the DB engine versions for these statuses. Valid statuses are the following:

    • available

    • deprecated 

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[]
include_all Input Column

Specifies whether to also list the engine versions that aren't available. The default is to list only available engine versions.

BOOLEAN
list_supported_character_sets Input Column

Specifies whether to list the supported character sets for each engine version.

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

For RDS Custom, the default is not to list supported character sets. If you enable this parameter, RDS Custom returns no results.

BOOLEAN
list_supported_timezones Input Column

Specifies whether to list the supported time zones for each engine version.

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

For RDS Custom, the default is not to list supported time zones. If you enable this parameter, RDS Custom returns no results.

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
create_time

The creation time of the DB engine version.

TIMESTAMP_S
custom_db_engine_version_manifest

JSON string that lists the installation files and parameters that RDS Custom uses to create a custom engine version (CEV). RDS Custom applies the patches in the order in which they're listed in the manifest. You can set the Oracle home, Oracle base, and UNIX/Linux user and group using the installation parameters. For more information, see JSON fields in the CEV manifest in the Amazon RDS User Guide. 

VARCHAR
database_installation_files_s3_bucket_name

The name of the Amazon S3 bucket that contains your database installation files.

VARCHAR
database_installation_files_s3_prefix

The Amazon S3 directory that contains the database installation files. If not specified, then no prefix is assumed.

VARCHAR
db_engine_description

The description of the database engine.

VARCHAR
db_engine_media_type

A value that indicates the source media provider of the AMI based on the usage operation. Applicable for RDS Custom for SQL Server.

VARCHAR
db_engine_version_arn

The ARN of the custom engine version.

VARCHAR
db_engine_version_description

The description of the database engine version.

VARCHAR
default_character_set

The default character set for new instances of this engine version, if the CharacterSetName parameter of the CreateDBInstance API isn't specified.

STRUCT(
    "character_set_name" VARCHAR,
    "character_set_description" VARCHAR
)
Show child fields
default_character_set.character_set_description

The description of the character set.

default_character_set.character_set_name

The name of the character set.

exportable_log_types

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

VARCHAR[]
Show child fields
exportable_log_types[]
image

The EC2 image

STRUCT(
    "image_id" VARCHAR,
    "status" VARCHAR
)
Show child fields
image.image_id

A value that indicates the ID of the AMI.

image.status

A value that indicates the status of a custom engine version (CEV).

kms_key_id

The Amazon Web Services KMS key identifier for an encrypted CEV. This parameter is required for RDS Custom, but optional for Amazon RDS.

VARCHAR
major_engine_version

The major engine version of the CEV.

VARCHAR
status

The status of the DB engine version, either available or deprecated.

VARCHAR
supported_ca_certificate_identifiers

A list of the supported CA certificate identifiers.

For more information, see Using SSL/TLS to encrypt a connection to a DB instance in the Amazon RDS User Guide and Using SSL/TLS to encrypt a connection to a DB cluster in the Amazon Aurora User Guide.

VARCHAR[]
Show child fields
supported_ca_certificate_identifiers[]
supported_character_sets

A list of the character sets supported by this engine for the CharacterSetName parameter of the CreateDBInstance operation.

STRUCT(
    "character_set_name" VARCHAR,
    "character_set_description" VARCHAR
)[]
Show child fields
supported_character_sets[]
Show child fields
supported_character_sets[].character_set_description

The description of the character set.

supported_character_sets[].character_set_name

The name of the character set.

supported_engine_modes

A list of the supported DB engine modes.

VARCHAR[]
Show child fields
supported_engine_modes[]
supported_feature_names

A list of features supported by the DB engine.

The supported features vary by DB engine and DB engine version.

To determine the supported features for a specific DB engine and DB engine version using the CLI, use the following command:

aws rds describe-db-engine-versions --engine <engine_name> --engine-version <engine_version>

For example, to determine the supported features for RDS for PostgreSQL version 13.3 using the CLI, use the following command:

aws rds describe-db-engine-versions --engine postgres --engine-version 13.3

The supported features are listed under SupportedFeatureNames in the output.

VARCHAR[]
Show child fields
supported_feature_names[]
supported_nchar_character_sets

A list of the character sets supported by the Oracle DB engine for the NcharCharacterSetName parameter of the CreateDBInstance operation.

STRUCT(
    "character_set_name" VARCHAR,
    "character_set_description" VARCHAR
)[]
Show child fields
supported_nchar_character_sets[]
Show child fields
supported_nchar_character_sets[].character_set_description

The description of the character set.

supported_nchar_character_sets[].character_set_name

The name of the character set.

supported_timezones

A list of the time zones supported by this engine for the Timezone parameter of the CreateDBInstance action.

STRUCT(
    "timezone_name" VARCHAR
)[]
Show child fields
supported_timezones[]
Show child fields
supported_timezones[].timezone_name

The name of the time zone.

supports_babelfish

Indicates whether the engine version supports Babelfish for Aurora PostgreSQL.

BOOLEAN
supports_certificate_rotation_without_restart

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

BOOLEAN
supports_global_databases

Indicates whether you can use Aurora global databases with a specific DB engine version.

BOOLEAN
supports_integrations

Indicates whether the DB engine version supports zero-ETL integrations with Amazon Redshift.

BOOLEAN
supports_limitless_database

Indicates whether the DB engine version supports Aurora Limitless Database.

BOOLEAN
supports_local_write_forwarding

Indicates whether the DB engine version supports forwarding write operations from reader DB instances to the writer DB instance in the DB cluster. By default, write operations aren't allowed on reader DB instances.

Valid for: Aurora DB clusters only

BOOLEAN
supports_log_exports_to_cloudwatch_logs

Indicates whether the engine version supports exporting the log types specified by ExportableLogTypes to CloudWatch Logs.

BOOLEAN
supports_parallel_query

Indicates whether you can use Aurora parallel query with a specific DB engine version.

BOOLEAN
supports_read_replica

Indicates whether the database engine version supports read replicas.

BOOLEAN
tag_list

A list of tags.

For more information, see Tagging Amazon RDS resources in the Amazon RDS User Guide or Tagging Amazon Aurora and Amazon RDS resources in the Amazon Aurora User Guide. 

STRUCT(
    "key" VARCHAR,
    "value" VARCHAR
)[]
Show child fields
tag_list[]
Show child fields
tag_list[].key

A key is the required name of the tag. The string value can be from 1 to 128 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").

tag_list[].value

A value is the optional value of the tag. The string value can be from 1 to 256 Unicode characters in length and can't be prefixed with aws: or rds:. The string can only contain only the set of Unicode letters, digits, white-space, '_', '.', ':', '/', '=', '+', '-', '@' (Java regex: "^([\\p{L}\\p{Z}\\p{N}_.:/=+\\-@]*)$").

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,
    "supported_engine_modes" VARCHAR[],
    "supports_parallel_query" BOOLEAN,
    "supports_global_databases" BOOLEAN,
    "supports_babelfish" BOOLEAN,
    "supports_limitless_database" BOOLEAN,
    "supports_local_write_forwarding" BOOLEAN,
    "supports_integrations" BOOLEAN
)[]
Show child fields
valid_upgrade_target[]
Show child fields
valid_upgrade_target[].auto_upgrade

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

This parameter is dynamic, and is set by RDS.

valid_upgrade_target[].description

The version of the database engine that a DB 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

Indicates whether upgrading to the target version requires upgrading the major version of the database engine.

valid_upgrade_target[].supported_engine_modes[]
valid_upgrade_target[].supports_babelfish

Indicates whether you can use Babelfish for Aurora PostgreSQL with the target engine version.

valid_upgrade_target[].supports_global_databases

Indicates whether you can use Aurora global databases with the target engine version.

valid_upgrade_target[].supports_integrations

Indicates whether the DB engine version supports zero-ETL integrations with Amazon Redshift.

valid_upgrade_target[].supports_limitless_database

Indicates whether the DB engine version supports Aurora Limitless Database.

valid_upgrade_target[].supports_local_write_forwarding

Indicates whether the target engine version supports forwarding write operations from reader DB instances to the writer DB instance in the DB cluster. By default, write operations aren't allowed on reader DB instances.

Valid for: Aurora DB clusters only

valid_upgrade_target[].supports_parallel_query

Indicates whether you can use Aurora parallel query with the target engine version.