Skip to content
AWS for Query.Farm

aws.ec2.describe_capacity_reservation_fleets

Example SQL Queries

SELECT * FROM
aws.ec2.describe_capacity_reservation_fleets;

Description

Describes one or more Capacity Reservation Fleets.

Table Definition

Column NameColumn Data Type
capacity_reservation_fleet_ids Input Column

The IDs of the Capacity Reservation Fleets to describe.

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

One or more filters.

  • state - The state of the Fleet (submitted | modifying | active | partially_fulfilled | expiring | expired | cancelling | cancelled | failed).

  • instance-match-criteria - The instance matching criteria for the Fleet. Only open is supported.

  • tenancy - The tenancy of the Fleet (default | dedicated).

  • allocation-strategy - The allocation strategy used by the Fleet. Only prioritized is supported.

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[]
_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
allocation_strategy

The strategy used by the Capacity Reservation Fleet to determine which of the specified instance types to use. For more information, see For more information, see Allocation strategy in the Amazon EC2 User Guide.

VARCHAR
capacity_reservation_fleet_arn

The ARN of the Capacity Reservation Fleet.

VARCHAR
capacity_reservation_fleet_id

The ID of the Capacity Reservation Fleet.

VARCHAR
create_time

The date and time at which the Capacity Reservation Fleet was created.

TIMESTAMP_S
end_date

The date and time at which the Capacity Reservation Fleet expires.

TIMESTAMP_S
instance_match_criteria

Indicates the type of instance launches that the Capacity Reservation Fleet accepts. All Capacity Reservations in the Fleet inherit this instance matching criteria.

Currently, Capacity Reservation Fleets support open instance matching criteria only. This means that instances that have matching attributes (instance type, platform, and Availability Zone) run in the Capacity Reservations automatically. Instances do not need to explicitly target a Capacity Reservation Fleet to use its reserved capacity.

VARCHAR
instance_type_specifications

Information about the instance types for which to reserve the capacity.

STRUCT(
    "capacity_reservation_id" VARCHAR,
    "availability_zone_id" VARCHAR,
    "instance_type" VARCHAR,
    "instance_platform" VARCHAR,
    "availability_zone" VARCHAR,
    "total_instance_count" BIGINT,
    "fulfilled_capacity" DOUBLE,
    "ebs_optimized" BOOLEAN,
    "create_date" TIMESTAMP_S,
    "weight" DOUBLE,
    "priority" BIGINT
)[]
Show child fields
instance_type_specifications[]
Show child fields
instance_type_specifications[].availability_zone

The Availability Zone in which the Capacity Reservation reserves capacity.

instance_type_specifications[].availability_zone_id

The ID of the Availability Zone in which the Capacity Reservation reserves capacity.

instance_type_specifications[].capacity_reservation_id

The ID of the Capacity Reservation.

instance_type_specifications[].create_date

The date and time at which the Capacity Reservation was created.

instance_type_specifications[].ebs_optimized

Indicates whether the Capacity Reservation reserves capacity for EBS-optimized instance types.

instance_type_specifications[].fulfilled_capacity

The number of capacity units fulfilled by the Capacity Reservation. For more information, see Total target capacity in the Amazon EC2 User Guide.

instance_type_specifications[].instance_platform

The type of operating system for which the Capacity Reservation reserves capacity.

instance_type_specifications[].instance_type

The instance type for which the Capacity Reservation reserves capacity.

instance_type_specifications[].priority

The priority of the instance type in the Capacity Reservation Fleet. For more information, see Instance type priority in the Amazon EC2 User Guide.

instance_type_specifications[].total_instance_count

The total number of instances for which the Capacity Reservation reserves capacity.

instance_type_specifications[].weight

The weight of the instance type in the Capacity Reservation Fleet. For more information, see Instance type weight in the Amazon EC2 User Guide.

state

The state of the Capacity Reservation Fleet. Possible states include:

  • submitted - The Capacity Reservation Fleet request has been submitted and Amazon Elastic Compute Cloud is preparing to create the Capacity Reservations.

  • modifying - The Capacity Reservation Fleet is being modified. The Fleet remains in this state until the modification is complete.

  • active - The Capacity Reservation Fleet has fulfilled its total target capacity and it is attempting to maintain this capacity. The Fleet remains in this state until it is modified or deleted.

  • partially_fulfilled - The Capacity Reservation Fleet has partially fulfilled its total target capacity. There is insufficient Amazon EC2 to fulfill the total target capacity. The Fleet is attempting to asynchronously fulfill its total target capacity.

  • expiring - The Capacity Reservation Fleet has reach its end date and it is in the process of expiring. One or more of its Capacity reservations might still be active.

  • expired - The Capacity Reservation Fleet has reach its end date. The Fleet and its Capacity Reservations are expired. The Fleet can't create new Capacity Reservations.

  • cancelling - The Capacity Reservation Fleet is in the process of being cancelled. One or more of its Capacity reservations might still be active.

  • cancelled - The Capacity Reservation Fleet has been manually cancelled. The Fleet and its Capacity Reservations are cancelled and the Fleet can't create new Capacity Reservations.

  • failed - The Capacity Reservation Fleet failed to reserve capacity for the specified instance types.

VARCHAR
tags

The tags assigned to the Capacity Reservation Fleet.

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

The key of the tag.

Constraints: Tag keys are case-sensitive and accept a maximum of 127 Unicode characters. May not begin with aws:.

tags[].value

The value of the tag.

Constraints: Tag values are case-sensitive and accept a maximum of 256 Unicode characters.

tenancy

The tenancy of the Capacity Reservation Fleet. Tenancies include:

  • default - The Capacity Reservation Fleet is created on hardware that is shared with other Amazon Web Services accounts.

  • dedicated - The Capacity Reservation Fleet is created on single-tenant hardware that is dedicated to a single Amazon Web Services account.

VARCHAR
total_fulfilled_capacity

The capacity units that have been fulfilled.

DOUBLE
total_target_capacity

The total number of capacity units for which the Capacity Reservation Fleet reserves capacity. For more information, see Total target capacity in the Amazon EC2 User Guide.

BIGINT