Skip to content

aws.ec2.describe_reserved_instances_modifications

Example SQL Queries

SELECT * FROM
aws.ec2.describe_reserved_instances_modifications;

Description

Describes the modifications made to your Reserved Instances. If no parameter is specified, information about all your Reserved Instances modification requests is returned. If a modification ID is specified, only information about the specific modification is returned.

For more information, see Modify Reserved Instances 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
filters Input Column

One or more filters.

  • client-token - The idempotency token for the modification request.

  • create-date - The time when the modification request was created.

  • effective-date - The time when the modification becomes effective.

  • modification-result.reserved-instances-id - The ID for the Reserved Instances created as part of the modification request. This ID is only available when the status of the modification is fulfilled.

  • modification-result.target-configuration.availability-zone - The Availability Zone for the new Reserved Instances.

  • modification-result.target-configuration.instance-count - The number of new Reserved Instances.

  • modification-result.target-configuration.instance-type - The instance type of the new Reserved Instances.

  • reserved-instances-id - The ID of the Reserved Instances modified.

  • reserved-instances-modification-id - The ID of the modification request.

  • status - The status of the Reserved Instances modification request (processing | fulfilled | failed).

  • status-message - The reason for the status.

  • update-date - The time when the modification request was last updated.

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

IDs for the submitted modification request.

VARCHAR[]
Show child fields
reserved_instances_modification_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
client_token

A unique, case-sensitive key supplied by the client to ensure that the request is idempotent. For more information, see Ensuring Idempotency.

VARCHAR
create_date

The time when the modification request was created.

TIMESTAMP_S
effective_date

The time for the modification to become effective.

TIMESTAMP_S
modification_results

Contains target configurations along with their corresponding new Reserved Instance IDs.

STRUCT(
"reserved_instances_id" VARCHAR,
"target_configuration" STRUCT(
"availability_zone" VARCHAR,
"instance_count" BIGINT,
"instance_type" VARCHAR,
"platform" VARCHAR,
"scope" VARCHAR
)
)[]
Show child fields
modification_results[]
Show child fields
modification_results[].reserved_instances_id

The ID for the Reserved Instances that were created as part of the modification request. This field is only available when the modification is fulfilled.

modification_results[].target_configuration

The target Reserved Instances configurations supplied as part of the modification request.

Show child fields
modification_results[].target_configuration.availability_zone

The Availability Zone for the modified Reserved Instances.

modification_results[].target_configuration.instance_count

The number of modified Reserved Instances.

This is a required field for a request.

modification_results[].target_configuration.instance_type

The instance type for the modified Reserved Instances.

modification_results[].target_configuration.platform

The network platform of the modified Reserved Instances.

modification_results[].target_configuration.scope

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

reserved_instances_ids

The IDs of one or more Reserved Instances.

STRUCT(
"reserved_instances_id" VARCHAR
)[]
Show child fields
reserved_instances_ids[]
Show child fields
reserved_instances_ids[].reserved_instances_id

The ID of the Reserved Instance.

reserved_instances_modification_id

A unique ID for the Reserved Instance modification.

VARCHAR
status

The status of the Reserved Instances modification request.

VARCHAR
status_message

The reason for the status.

VARCHAR
update_date

The time when the modification request was last updated.

TIMESTAMP_S