steampipe plugin install aws

Table: aws_appautoscaling_target - Query AWS Application Auto Scaling Targets using SQL

The AWS Application Auto Scaling Targets are used to manage scalable targets within AWS services. These targets can be any resource that can scale in or out, such as an Amazon ECS service, an Amazon EC2 Spot Fleet request, or an Amazon RDS read replica. The Application Auto Scaling service automatically adjusts the resource's capacity to maintain steady, predictable performance at the lowest possible cost.

Table Usage Guide

The aws_appautoscaling_target table in Steampipe provides you with information about each target within AWS Application Auto Scaling. This table allows you, as a DevOps engineer, to query target-specific details, including the service namespace, scalable dimension, resource ID, and the associated scaling policies. You can utilize this table to gather insights on scaling targets, such as the min and max capacity, role ARN, and more. The schema outlines the various attributes of the scaling target for you, including the resource ID, scalable dimension, creation time, and associated tags.

Examples

Basic info

Explore the creation timeline of resources within the AWS DynamoDB service, which can help in understanding their scalability dimensions and facilitate efficient resource management.

select
service_namespace,
scalable_dimension,
resource_id,
creation_time
from
aws_appautoscaling_target
where
service_namespace = 'dynamodb';
select
service_namespace,
scalable_dimension,
resource_id,
creation_time
from
aws_appautoscaling_target
where
service_namespace = 'dynamodb';

List targets for DynamoDB tables with read or write auto scaling enabled

Determine the areas in which auto-scaling is enabled for read or write operations in DynamoDB tables. This is useful in managing resources efficiently and optimizing cost by ensuring that scaling only occurs when necessary.

select
resource_id,
scalable_dimension
from
aws_appautoscaling_target
where
service_namespace = 'dynamodb'
and scalable_dimension = 'dynamodb:table:ReadCapacityUnits'
or scalable_dimension = 'dynamodb:table:WriteCapacityUnits';
select
resource_id,
scalable_dimension
from
aws_appautoscaling_target
where
service_namespace = 'dynamodb'
and (
scalable_dimension = 'dynamodb:table:ReadCapacityUnits'
or scalable_dimension = 'dynamodb:table:WriteCapacityUnits'
);

Schema for aws_appautoscaling_target

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
creation_timetimestamp with time zoneThe Unix timestamp for when the scalable target was created.
max_capacitybigintThe maximum value to scale to in response to a scale-out activity.
min_capacitybigintThe minimum value to scale to in response to a scale-in activity.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
resource_idtext=The identifier of the resource associated with the scalable target.
role_arntextThe ARN of an IAM role that allows Application Auto Scaling to modify the scalable target on your behalf.
scalable_dimensiontext=The scalable dimension associated with the scalable target. This string consists of the service namespace, resource type, and scaling property.
service_namespacetext=The namespace of the AWS service that provides the resource, or a custom-resource.
suspended_statejsonbSpecifies whether the scaling activities for a scalable target are in a suspended state.
titletextTitle of the resource.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_appautoscaling_target