Skip to content

aws.ec2.get_reserved_instances_exchange_quote

Example SQL Queries

SELECT * FROM
aws.ec2.get_reserved_instances_exchange_quote
WHERE
"reserved_instance_ids" = 'VALUE';

Description

Returns a quote and exchange information for exchanging one or more specified Convertible Reserved Instances for a new Convertible Reserved Instance. If the exchange cannot be performed, the reason is returned in the response. Use AcceptReservedInstancesExchangeQuote to perform the exchange.

Table Definition

Column NameColumn Data Type
reserved_instance_ids Required Input Column

The IDs of the Convertible Reserved Instances to exchange.

VARCHAR[]
Show child fields
reserved_instance_ids[]
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
target_configurations Input Column

The configuration of the target Convertible Reserved Instance to exchange for your current Convertible Reserved Instances.

STRUCT(
"instance_count" BIGINT,
"offering_id" VARCHAR
)[]
Show child fields
target_configurations[]
Show child fields
target_configurations[].instance_count

The number of instances the Convertible Reserved Instance offering can be applied to. This parameter is reserved and cannot be specified in a request

target_configurations[].offering_id

The Convertible Reserved Instance offering ID.

_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 transaction.

VARCHAR
is_valid_exchange

If true, the exchange is valid. If false, the exchange cannot be completed.

BOOLEAN
output_reserved_instances_will_expire_at

The new end date of the reservation term.

TIMESTAMP_S
payment_due

The total true upfront charge for the exchange.

VARCHAR
reserved_instance_value_rollup

The cost associated with the Reserved Instance.

STRUCT(
"hourly_price" VARCHAR,
"remaining_total_value" VARCHAR,
"remaining_upfront_value" VARCHAR
)
Show child fields
reserved_instance_value_rollup.hourly_price

The hourly rate of the reservation.

reserved_instance_value_rollup.remaining_total_value

The balance of the total value (the sum of remainingUpfrontValue + hourlyPrice * number of hours remaining).

reserved_instance_value_rollup.remaining_upfront_value

The remaining upfront cost of the reservation.

reserved_instance_value_set

The configuration of your Convertible Reserved Instances.

STRUCT(
"reservation_value" STRUCT(
"hourly_price" VARCHAR,
"remaining_total_value" VARCHAR,
"remaining_upfront_value" VARCHAR
),
"reserved_instance_id" VARCHAR
)[]
Show child fields
reserved_instance_value_set[]
Show child fields
reserved_instance_value_set[].reservation_value

The total value of the Convertible Reserved Instance that you are exchanging.

Show child fields
reserved_instance_value_set[].reservation_value.hourly_price

The hourly rate of the reservation.

reserved_instance_value_set[].reservation_value.remaining_total_value

The balance of the total value (the sum of remainingUpfrontValue + hourlyPrice * number of hours remaining).

reserved_instance_value_set[].reservation_value.remaining_upfront_value

The remaining upfront cost of the reservation.

reserved_instance_value_set[].reserved_instance_id

The ID of the Convertible Reserved Instance that you are exchanging.

target_configuration_value_rollup

The cost associated with the Reserved Instance.

STRUCT(
"hourly_price" VARCHAR,
"remaining_total_value" VARCHAR,
"remaining_upfront_value" VARCHAR
)
Show child fields
target_configuration_value_rollup.hourly_price

The hourly rate of the reservation.

target_configuration_value_rollup.remaining_total_value

The balance of the total value (the sum of remainingUpfrontValue + hourlyPrice * number of hours remaining).

target_configuration_value_rollup.remaining_upfront_value

The remaining upfront cost of the reservation.

target_configuration_value_set

The values of the target Convertible Reserved Instances.

STRUCT(
"reservation_value" STRUCT(
"hourly_price" VARCHAR,
"remaining_total_value" VARCHAR,
"remaining_upfront_value" VARCHAR
),
"target_configuration" STRUCT(
"instance_count" BIGINT,
"offering_id" VARCHAR
)
)[]
Show child fields
target_configuration_value_set[]
Show child fields
target_configuration_value_set[].reservation_value

The total value of the Convertible Reserved Instances that make up the exchange. This is the sum of the list value, remaining upfront price, and additional upfront cost of the exchange.

Show child fields
target_configuration_value_set[].reservation_value.hourly_price

The hourly rate of the reservation.

target_configuration_value_set[].reservation_value.remaining_total_value

The balance of the total value (the sum of remainingUpfrontValue + hourlyPrice * number of hours remaining).

target_configuration_value_set[].reservation_value.remaining_upfront_value

The remaining upfront cost of the reservation.

target_configuration_value_set[].target_configuration

The configuration of the Convertible Reserved Instances that make up the exchange.

Show child fields
target_configuration_value_set[].target_configuration.instance_count

The number of instances the Convertible Reserved Instance offering can be applied to. This parameter is reserved and cannot be specified in a request

target_configuration_value_set[].target_configuration.offering_id

The ID of the Convertible Reserved Instance offering.

validation_failure_reason

Describes the reason why the exchange cannot be completed.

VARCHAR