Skip to content
AWS for Query.Farm

aws.codedeploy.get_application_revision

Example SQL Queries

SELECT * FROM
aws.codedeploy.get_application_revision
WHERE
"application_name" = 'VALUE'
AND "revision" = 'VALUE';

Description

Gets information about an application revision.

Table Definition

Column NameColumn Data Type
application_name Required Input Column

The name of the application that corresponds to the revision.

VARCHAR
revision Required Input Column

Additional information about the revision, including type and location.

STRUCT(
    "revision_type" VARCHAR,
    "s3_location" STRUCT(
        "bucket" VARCHAR,
        "key" VARCHAR,
        "bundle_type" VARCHAR,
        "version" VARCHAR,
        "e_tag" VARCHAR
    ),
    "git_hub_location" STRUCT(
        "repository" VARCHAR,
        "commit_id" VARCHAR
    ),
    "string" STRUCT(
        "content" VARCHAR,
        "sha256" VARCHAR
    ),
    "app_spec_content" STRUCT(
        "content" VARCHAR,
        "sha256" VARCHAR
    )
)
Show child fields
revision.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.

Show child fields
revision.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.

revision.app_spec_content.sha256

The SHA256 hash value of the revision content.

revision.git_hub_location

Information about the location of application artifacts stored in GitHub.

Show child fields
revision.git_hub_location.commit_id

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

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.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.

revision.s3_location

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

Show child fields
revision.s3_location.bucket

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

revision.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.

revision.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.

revision.s3_location.key

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

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.

revision.string

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

Show child fields
revision.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.

revision.string.sha256

The SHA256 hash value of the revision content.

_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
revision_info

General information about the revision.

STRUCT(
    "description" VARCHAR,
    "deployment_groups" VARCHAR[],
    "first_used_time" TIMESTAMP_S,
    "last_used_time" TIMESTAMP_S,
    "register_time" TIMESTAMP_S
)
Show child fields
revision_info.deployment_groups[]
revision_info.description

A comment about the revision.

revision_info.first_used_time

When the revision was first used by CodeDeploy.

revision_info.last_used_time

When the revision was last used by CodeDeploy.

revision_info.register_time

When the revision was registered with CodeDeploy.