Skip to content
AWS for Query.Farm

aws.elasticbeanstalk.describe_application_versions

Example SQL Queries

SELECT * FROM
aws.elasticbeanstalk.describe_application_versions;

Description

Retrieve a list of application versions.

Table Definition

Column NameColumn Data Type
application_name Input Column

The name of the application to which the application version belongs.

VARCHAR
version_labels Input Column

Specify a version label to show a specific application version.

VARCHAR[]
Show child fields
version_labels[]
_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
application_version_arn

The Amazon Resource Name (ARN) of the application version.

VARCHAR
build_arn

Reference to the artifact from the AWS CodeBuild build.

VARCHAR
date_created

The creation date of the application version.

TIMESTAMP_S
date_updated

The last modified date of the application version.

TIMESTAMP_S
description

The description of the application version.

VARCHAR
source_build_information

If the version's source code was retrieved from AWS CodeCommit, the location of the source code for the application version.

STRUCT(
    "source_type" VARCHAR,
    "source_repository" VARCHAR,
    "source_location" VARCHAR
)
Show child fields
source_build_information.source_location

The location of the source code, as a formatted string, depending on the value of SourceRepository

  • For CodeCommit, the format is the repository name and commit ID, separated by a forward slash. For example, my-git-repo/265cfa0cf6af46153527f55d6503ec030551f57a.

  • For S3, the format is the S3 bucket name and object key, separated by a forward slash. For example, my-s3-bucket/Folders/my-source-file.

source_build_information.source_repository

Location where the repository is stored.

  • CodeCommit

  • S3

source_build_information.source_type

The type of repository.

  • Git

  • Zip

source_bundle

The storage location of the application version's source bundle in Amazon S3.

STRUCT(
    "s3_bucket" VARCHAR,
    "s3_key" VARCHAR
)
Show child fields
source_bundle.s3_bucket

The Amazon S3 bucket where the data is located.

source_bundle.s3_key

The Amazon S3 key where the data is located.

status

The processing status of the application version. Reflects the state of the application version during its creation. Many of the values are only applicable if you specified True for the Process parameter of the CreateApplicationVersion action. The following list describes the possible values.

  • Unprocessed – Application version wasn't pre-processed or validated. Elastic Beanstalk will validate configuration files during deployment of the application version to an environment.

  • Processing – Elastic Beanstalk is currently processing the application version.

  • Building – Application version is currently undergoing an AWS CodeBuild build.

  • Processed – Elastic Beanstalk was successfully pre-processed and validated.

  • Failed – Either the AWS CodeBuild build failed or configuration files didn't pass validation. This application version isn't usable.

VARCHAR
version_label

A unique identifier for the application version.

VARCHAR