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.

Important Notes

You must specify service_namespace in a where clause in order to use this table.
For supported values of the service namespace, please refer Service Namespace.
This table supports optional quals. Queries with optional quals are optimised to use additional filtering provided by the AWS API function. Optional quals are supported for the following columns:
- resource_id
- scalable_dimension

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'
  );

Control examples

Schema for aws_appautoscaling_target

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
creation_time	timestamp with time zone		The Unix timestamp for when the scalable target was created.
max_capacity	bigint		The maximum value to scale to in response to a scale-out activity.
min_capacity	bigint		The minimum value to scale to in response to a scale-in activity.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text		The AWS Region in which the resource is located.
resource_id	text	=	The identifier of the resource associated with the scalable target.
role_arn	text		The ARN of an IAM role that allows Application Auto Scaling to modify the scalable target on your behalf.
scalable_dimension	text	=	The scalable dimension associated with the scalable target. This string consists of the service namespace, resource type, and scaling property.
scalable_target_arn	text		The ARN of the scalable target.
service_namespace	text	=	The namespace of the AWS service that provides the resource, or a custom-resource.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
suspended_state	jsonb		Specifies whether the scaling activities for a scalable target are in a suspended state.
title	text		Title 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