Skip to content

aws.autoscaling.describe_warm_pool

Example SQL Queries

SELECT * FROM
aws.autoscaling.describe_warm_pool
WHERE
"auto_scaling_group_name" = 'VALUE';

Description

Gets information about a warm pool and its instances.

For more information, see Warm pools for Amazon EC2 Auto Scaling in the Amazon EC2 Auto Scaling User Guide.

Table Definition

Column NameColumn Data Type
auto_scaling_group_name Required Input Column

The name of the Auto Scaling group.

VARCHAR
_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
instances

The instances that are currently in the warm pool.

STRUCT(
"instance_id" VARCHAR,
"instance_type" VARCHAR,
"availability_zone" VARCHAR,
"lifecycle_state" VARCHAR,
"health_status" VARCHAR,
"launch_configuration_name" VARCHAR,
"launch_template" STRUCT(
"launch_template_id" VARCHAR,
"launch_template_name" VARCHAR,
"version" VARCHAR
),
"protected_from_scale_in" BOOLEAN,
"weighted_capacity" VARCHAR
)[]
Show child fields
instances[]
Show child fields
instances[].availability_zone

The Availability Zone in which the instance is running.

instances[].health_status

The last reported health status of the instance. Healthy means that the instance is healthy and should remain in service. Unhealthy means that the instance is unhealthy and that Amazon EC2 Auto Scaling should terminate and replace it.

instances[].instance_id

The ID of the instance.

instances[].instance_type

The instance type of the EC2 instance.

instances[].launch_configuration_name

The launch configuration associated with the instance.

instances[].launch_template

The launch template for the instance.

Show child fields
instances[].launch_template.launch_template_id

The ID of the launch template. To get the template ID, use the Amazon EC2 DescribeLaunchTemplates API operation. New launch templates can be created using the Amazon EC2 CreateLaunchTemplate API.

Conditional: You must specify either a LaunchTemplateId or a LaunchTemplateName.

instances[].launch_template.launch_template_name

The name of the launch template. To get the template name, use the Amazon EC2 DescribeLaunchTemplates API operation. New launch templates can be created using the Amazon EC2 CreateLaunchTemplate API.

Conditional: You must specify either a LaunchTemplateId or a LaunchTemplateName.

instances[].launch_template.version

The version number, $Latest, or $Default. To get the version number, use the Amazon EC2 DescribeLaunchTemplateVersions API operation. New launch template versions can be created using the Amazon EC2 CreateLaunchTemplateVersion API. If the value is $Latest, Amazon EC2 Auto Scaling selects the latest version of the launch template when launching instances. If the value is $Default, Amazon EC2 Auto Scaling selects the default version of the launch template when launching instances. The default value is $Default.

instances[].lifecycle_state

A description of the current lifecycle state. The Quarantined state is not used. For more information, see Amazon EC2 Auto Scaling instance lifecycle in the Amazon EC2 Auto Scaling User Guide.

instances[].protected_from_scale_in

Indicates whether the instance is protected from termination by Amazon EC2 Auto Scaling when scaling in.

instances[].weighted_capacity

The number of capacity units contributed by the instance based on its instance type.

Valid Range: Minimum value of 1. Maximum value of 999.

warm_pool_configuration

The warm pool configuration details.

STRUCT(
"max_group_prepared_capacity" BIGINT,
"min_size" BIGINT,
"pool_state" VARCHAR,
"status" VARCHAR,
"instance_reuse_policy" STRUCT(
"reuse_on_scale_in" BOOLEAN
)
)
Show child fields
warm_pool_configuration.instance_reuse_policy

The instance reuse policy.

Show child fields
warm_pool_configuration.instance_reuse_policy.reuse_on_scale_in

Specifies whether instances in the Auto Scaling group can be returned to the warm pool on scale in.

warm_pool_configuration.max_group_prepared_capacity

The maximum number of instances that are allowed to be in the warm pool or in any state except Terminated for the Auto Scaling group.

warm_pool_configuration.min_size

The minimum number of instances to maintain in the warm pool.

warm_pool_configuration.pool_state

The instance state to transition to after the lifecycle actions are complete.

warm_pool_configuration.status

The status of a warm pool that is marked for deletion.