db_major_engine_versions

Creates, updates, deletes, gets or lists a db_major_engine_versions resource.

Overview

Name	db_major_engine_versions
Type	Resource
Id	aws.rds.db_major_engine_versions

Fields

The following fields are returned by SELECT queries:

describe_db_major_engine_versions

Name	Datatype	Description
engine	string	The name of the database engine.
major_engine_version	string	The major version number of the database engine.
supported_engine_lifecycles	string	A list of the lifecycles supported by this engine for the DescribeDBMajorEngineVersions operation.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
describe_db_major_engine_versions	select	region	Engine, MajorEngineVersion, Marker, MaxRecords	Describes the properties of specific major versions of DB engines.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)
Engine	string	The database engine to return major version details for. Valid Values: aurora-mysql aurora-postgresql custom-sqlserver-ee custom-sqlserver-se custom-sqlserver-web db2-ae db2-ce 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	A specific database major engine version to return details for. Example: 8.4
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.
MaxRecords	integer	The maximum number of records to include in the response. If more than the MaxRecords value is available, a pagination token called a marker is included in the response so you can retrieve the remaining results. Default: 100

SELECT examples

describe_db_major_engine_versions

Describes the properties of specific major versions of DB engines.

SELECT
engine,
major_engine_version,
supported_engine_lifecycles
FROM aws.rds.db_major_engine_versions
WHERE region = '{{ region }}' -- required
AND Engine = '{{ Engine }}'
AND MajorEngineVersion = '{{ MajorEngineVersion }}'
AND Marker = '{{ Marker }}'
AND MaxRecords = '{{ MaxRecords }}'
;