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;

Query examples

elastic_beanstalk_applications_for_codepipeline_pipeline

Schema for aws_elastic_beanstalk_application

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
arn	text		The Amazon Resource Name (ARN) of the application.
configuration_templates	jsonb		The names of the configuration templates associated with this application.
date_created	timestamp with time zone		The date when the application was created.
date_updated	timestamp with time zone		The date when the application was last modified.
description	text		User-defined description of the application.
name	text	=	The name of the application.
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_lifecycle_config	jsonb		The lifecycle settings for the application.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tags assigned to the application.
title	text		Title of the resource.
versions	jsonb		The 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