steampipe plugin install aws

Table: aws_elastic_beanstalk_application - Query AWS Elastic Beanstalk Applications using SQL

The AWS Elastic Beanstalk Application is a component of AWS's platform-as-a-service (PaaS) offering, Elastic Beanstalk. It allows developers to deploy and manage applications in multiple languages without worrying about the infrastructure that runs those applications. The Elastic Beanstalk Application handles capacity provisioning, load balancing, and automatic scaling, among other tasks, enabling developers to focus on their application code.

Table Usage Guide

The aws_elastic_beanstalk_application table in Steampipe provides you with information about applications within AWS Elastic Beanstalk. This table enables you, as a DevOps engineer, to query application-specific details, including application ARN, description, date created, date updated, and associated metadata. You can utilize this table to gather insights on applications, such as application versions, configurations, associated environments, and more. The schema outlines for you the various attributes of the Elastic Beanstalk application, including the resource lifecycles, configurations, and associated tags.

Examples

Basic info

Explore the applications in your AWS Elastic Beanstalk environment to understand their creation and update timeline, as well as the different versions available. This can help in managing the applications better by keeping track of their versions and update history.

select
name,
arn,
description,
date_created,
date_updated,
versions
from
aws_elastic_beanstalk_application;
select
name,
arn,
description,
date_created,
date_updated,
versions
from
aws_elastic_beanstalk_application;

Get resource life cycle configuration details for each application

Determine the life cycle configurations of your applications to understand the roles assigned and the rules set for version management. This can help in optimizing resource usage and maintaining application health.

select
name,
resource_lifecycle_config ->> 'ServiceRole' as role,
resource_lifecycle_config -> 'VersionLifecycleConfig' ->> 'MaxAgeRule' as max_age_rule,
resource_lifecycle_config -> 'VersionLifecycleConfig' ->> 'MaxCountRule' as max_count_rule
from
aws_elastic_beanstalk_application;
select
name,
json_extract(resource_lifecycle_config, '$.ServiceRole') as role,
json_extract(
resource_lifecycle_config,
'$.VersionLifecycleConfig.MaxAgeRule'
) as max_age_rule,
json_extract(
resource_lifecycle_config,
'$.VersionLifecycleConfig.MaxCountRule'
) as max_count_rule
from
aws_elastic_beanstalk_application;

Schema for aws_elastic_beanstalk_application

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) of the application.
configuration_templatesjsonbThe names of the configuration templates associated with this application.
date_createdtimestamp with time zoneThe date when the application was created.
date_updatedtimestamp with time zoneThe date when the application was last modified.
descriptiontextUser-defined description of the application.
nametext=The name of the application.
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_lifecycle_configjsonbThe lifecycle settings for the application.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags assigned to the application.
titletextTitle of the resource.
versionsjsonbThe names of the versions for this application.

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_elastic_beanstalk_application