Skip to content
AWS for Query.Farm

aws.ec2.describe_reserved_instances_offerings

Example SQL Queries

SELECT * FROM
aws.ec2.describe_reserved_instances_offerings;

Description

Describes Reserved Instance offerings that are available for purchase. With Reserved Instances, you purchase the right to launch instances for a period of time. During that time period, you do not receive insufficient capacity errors, and you pay a lower usage rate than the rate charged for On-Demand instances for the actual time used.

If you have listed your own Reserved Instances for sale in the Reserved Instance Marketplace, they will be excluded from these results. This is to ensure that you do not purchase your own Reserved Instances.

For more information, see Sell in the Reserved Instance Marketplace in the Amazon EC2 User Guide.

The order of the elements in the response, including those within nested structures, might vary. Applications should not assume the elements appear in a particular order.

Table Definition

Column NameColumn Data Type
availability_zone Input Column

The Availability Zone in which the Reserved Instance can be used.

VARCHAR
dry_run Input Column

Checks whether you have the required permissions for the action, without actually making the request, and provides an error response. If you have the required permissions, the error response is DryRunOperation. Otherwise, it is UnauthorizedOperation.

BOOLEAN
filters Input Column

One or more filters.

  • availability-zone - The Availability Zone where the Reserved Instance can be used.

  • duration - The duration of the Reserved Instance (for example, one year or three years), in seconds (31536000 | 94608000).

  • fixed-price - The purchase price of the Reserved Instance (for example, 9800.0).

  • instance-type - The instance type that is covered by the reservation.

  • marketplace - Set to true to show only Reserved Instance Marketplace offerings. When this filter is not used, which is the default behavior, all offerings from both Amazon Web Services and the Reserved Instance Marketplace are listed.

  • product-description - The Reserved Instance product platform description (Linux/UNIX | Linux with SQL Server Standard | Linux with SQL Server Web | Linux with SQL Server Enterprise | SUSE Linux | Red Hat Enterprise Linux | Red Hat Enterprise Linux with HA | Windows | Windows with SQL Server Standard | Windows with SQL Server Web | Windows with SQL Server Enterprise).

  • reserved-instances-offering-id - The Reserved Instances offering ID.

  • scope - The scope of the Reserved Instance (Availability Zone or Region).

  • usage-price - The usage price of the Reserved Instance, per hour (for example, 0.84).

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_marketplace Input Column

Include Reserved Instance Marketplace offerings in the response.

BOOLEAN
instance_tenancy Input Column

The tenancy of the instance.

VARCHAR
instance_type Input Column

The instance type on which the Reserved Instance can be used.

VARCHAR
max_duration Input Column

The maximum duration (in seconds) to filter when searching for offerings.

Default: 94608000 (3 years)

BIGINT
max_instance_count Input Column

The maximum number of instances to filter when searching for offerings.

Default: 20

BIGINT
min_duration Input Column

The minimum duration (in seconds) to filter when searching for offerings.

Default: 2592000 (1 month)

BIGINT
offering_class Input Column

If convertible it can be exchanged for Reserved Instances of the same or higher monetary value, with different configurations. If standard, it is not possible to perform an exchange.

VARCHAR
offering_type Input Column

The Reserved Instance offering type.

VARCHAR
product_description Input Column

The Reserved Instance product platform description.

VARCHAR
reserved_instances_offering_ids Input Column

One or more Reserved Instances offering IDs.

VARCHAR[]
Show child fields
reserved_instances_offering_ids[]
_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
currency_code

The currency of the Reserved Instance offering you are purchasing. It's specified using ISO 4217 standard currency codes. At this time, the only supported currency is USD.

VARCHAR
duration

The duration of the Reserved Instance, in seconds.

BIGINT
fixed_price

The purchase price of the Reserved Instance.

DOUBLE
marketplace

Indicates whether the offering is available through the Reserved Instance Marketplace (resale) or Amazon Web Services. If it's a Reserved Instance Marketplace offering, this is true.

BOOLEAN
pricing_details

The pricing details of the Reserved Instance offering.

STRUCT(
    "count" BIGINT,
    "price" DOUBLE
)[]
Show child fields
pricing_details[]
Show child fields
pricing_details[].count

The number of reservations available for the price.

pricing_details[].price

The price per instance.

recurring_charges

The recurring charge tag assigned to the resource.

STRUCT(
    "amount" DOUBLE,
    "frequency" VARCHAR
)[]
Show child fields
recurring_charges[]
Show child fields
recurring_charges[].amount

The amount of the recurring charge.

recurring_charges[].frequency

The frequency of the recurring charge.

reserved_instances_offering_id

The ID of the Reserved Instance offering. This is the offering ID used in GetReservedInstancesExchangeQuote to confirm that an exchange can be made.

VARCHAR
scope

Whether the Reserved Instance is applied to instances in a Region or an Availability Zone.

VARCHAR
usage_price

The usage price of the Reserved Instance, per hour.

DOUBLE