Skip to content
AWS for Query.Farm

aws.codedeploy.list_application_revisions

Example SQL Queries

SELECT * FROM
aws.codedeploy.list_application_revisions
WHERE
"application_name" = 'VALUE';

Description

Lists information about revisions for an application.

Table Definition

Column NameColumn Data Type
application_name Required Input Column

The name of an CodeDeploy application associated with the user or Amazon Web Services account. 

VARCHAR
deployed Input Column

Whether to list revisions based on whether the revision is the target revision of a deployment group:

  • include: List revisions that are target revisions of a deployment group.

  • exclude: Do not list revisions that are target revisions of a deployment group.

  • ignore: List all revisions.

VARCHAR
s3_bucket Input Column

An Amazon S3 bucket name to limit the search for revisions.

If set to null, all of the user's buckets are searched. 

VARCHAR
s3_key_prefix Input Column

A key prefix for the set of Amazon S3 objects to limit the search for revisions. 

VARCHAR
sort_by Input Column

The column name to use to sort the list results:

  • registerTime: Sort by the time the revisions were registered with CodeDeploy.

  • firstUsedTime: Sort by the time the revisions were first used in a deployment.

  • lastUsedTime: Sort by the time the revisions were last used in a deployment.

If not specified or set to null, the results are returned in an arbitrary order. 

VARCHAR
sort_order Input Column

The order in which to sort the list results:

  • ascending: ascending order.

  • descending: descending order.

If not specified, the results are sorted in ascending order.

If set to null, the results are sorted in an arbitrary order.

VARCHAR
_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
app_spec_content

The content of an AppSpec file for an Lambda or Amazon ECS deployment. The content is formatted as JSON or YAML and stored as a RawString. 

STRUCT(
    "content" VARCHAR,
    "sha256" VARCHAR
)
Show child fields
app_spec_content.content

The YAML-formatted or JSON-formatted revision string.

For an Lambda deployment, the content includes a Lambda function name, the alias for its original version, and the alias for its replacement version. The deployment shifts traffic from the original version of the Lambda function to the replacement version.

For an Amazon ECS deployment, the content includes the task name, information about the load balancer that serves traffic to the container, and more.

For both types of deployments, the content can specify Lambda functions that run at specified hooks, such as BeforeInstall, during a deployment.

app_spec_content.sha256

The SHA256 hash value of the revision content.

git_hub_location

Information about the location of application artifacts stored in GitHub.

STRUCT(
    "repository" VARCHAR,
    "commit_id" VARCHAR
)
Show child fields
git_hub_location.commit_id

The SHA1 commit ID of the GitHub commit that represents the bundled artifacts for the application revision.

git_hub_location.repository

The GitHub account and repository pair that stores a reference to the commit that represents the bundled artifacts for the application revision.

Specified as account/repository.

revision_type

The type of application revision:

  • S3: An application revision stored in Amazon S3.

  • GitHub: An application revision stored in GitHub (EC2/On-premises deployments only).

  • String: A YAML-formatted or JSON-formatted string (Lambda deployments only).

  • AppSpecContent: An AppSpecContent object that contains the contents of an AppSpec file for an Lambda or Amazon ECS deployment. The content is formatted as JSON or YAML stored as a RawString.

VARCHAR
s3_location

Information about the location of a revision stored in Amazon S3. 

STRUCT(
    "bucket" VARCHAR,
    "key" VARCHAR,
    "bundle_type" VARCHAR,
    "version" VARCHAR,
    "e_tag" VARCHAR
)
Show child fields
s3_location.bucket

The name of the Amazon S3 bucket where the application revision is stored.

s3_location.bundle_type

The file type of the application revision. Must be one of the following:

  • tar: A tar archive file.

  • tgz: A compressed tar archive file.

  • zip: A zip archive file.

  • YAML: A YAML-formatted file.

  • JSON: A JSON-formatted file.

s3_location.e_tag

The ETag of the Amazon S3 object that represents the bundled artifacts for the application revision.

If the ETag is not specified as an input parameter, ETag validation of the object is skipped.

s3_location.key

The name of the Amazon S3 object that represents the bundled artifacts for the application revision.

s3_location.version

A specific version of the Amazon S3 object that represents the bundled artifacts for the application revision.

If the version is not specified, the system uses the most recent version by default.

string

Information about the location of an Lambda deployment revision stored as a RawString.

STRUCT(
    "content" VARCHAR,
    "sha256" VARCHAR
)
Show child fields
string.content

The YAML-formatted or JSON-formatted revision string. It includes information about which Lambda function to update and optional Lambda functions that validate deployment lifecycle events.

string.sha256

The SHA256 hash value of the revision content.