Skip to content
AWS for Query.Farm

aws.appconfig.get_deployment

Example SQL Queries

SELECT * FROM
aws.appconfig.get_deployment
WHERE
"application_id" = 'VALUE'
AND "environment_id" = 'VALUE'
AND "deployment_number" = 'VALUE';

Description

Retrieves information about a configuration deployment.

Table Definition

Column NameColumn Data Type
application_id Required Input Column

The ID of the application that was deployed.

VARCHAR
deployment_number Required Input Column

The sequence number of the deployment.

BIGINT
environment_id Required Input Column

The ID of the environment that was deployed.

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
applied_extensions

A list of extensions that were processed as part of the deployment. The extensions that were previously associated to the configuration profile, environment, or the application when StartDeployment was called.

STRUCT(
    "extension_id" VARCHAR,
    "extension_association_id" VARCHAR,
    "version_number" BIGINT,
    "parameters" MAP(VARCHAR, VARCHAR)
)[]
Show child fields
applied_extensions[]
Show child fields
applied_extensions[].extension_association_id

The system-generated ID for the association.

applied_extensions[].extension_id

The system-generated ID of the extension.

applied_extensions[].parameters

One or more parameters for the actions called by the extension.

applied_extensions[].version_number

The extension version number.

completed_at

The time the deployment completed. 

TIMESTAMP_S
configuration_location_uri

Information about the source location of the configuration.

VARCHAR
configuration_name

The name of the configuration.

VARCHAR
configuration_profile_id

The ID of the configuration profile that was deployed.

VARCHAR
configuration_version

The configuration version that was deployed.

VARCHAR
deployment_duration_in_minutes

Total amount of time the deployment lasted.

BIGINT
deployment_strategy_id

The ID of the deployment strategy that was deployed.

VARCHAR
description

The description of the deployment.

VARCHAR
event_log

A list containing all events related to a deployment. The most recent events are displayed first.

STRUCT(
    "event_type" VARCHAR,
    "triggered_by" VARCHAR,
    "description" VARCHAR,
    "action_invocations" STRUCT(
        "extension_identifier" VARCHAR,
        "action_name" VARCHAR,
        "uri" VARCHAR,
        "role_arn" VARCHAR,
        "error_message" VARCHAR,
        "error_code" VARCHAR,
        "invocation_id" VARCHAR
    )[],
    "occurred_at" TIMESTAMP_S
)[]
Show child fields
event_log[]
Show child fields
event_log[].action_invocations[]
Show child fields
event_log[].action_invocations[].action_name

The name of the action.

event_log[].action_invocations[].error_code

The error code when an extension invocation fails.

event_log[].action_invocations[].error_message

The error message when an extension invocation fails.

event_log[].action_invocations[].extension_identifier

The name, the ID, or the Amazon Resource Name (ARN) of the extension.

event_log[].action_invocations[].invocation_id

A system-generated ID for this invocation.

event_log[].action_invocations[].role_arn

An Amazon Resource Name (ARN) for an Identity and Access Management assume role.

event_log[].action_invocations[].uri

The extension URI associated to the action point in the extension definition. The URI can be an Amazon Resource Name (ARN) for one of the following: an Lambda function, an Amazon Simple Queue Service queue, an Amazon Simple Notification Service topic, or the Amazon EventBridge default event bus.

event_log[].description

A description of the deployment event. Descriptions include, but are not limited to, the following:

  • The Amazon Web Services account or the Amazon CloudWatch alarm ARN that initiated a rollback.

  • The percentage of hosts that received the deployment.

  • A recommendation to attempt a new deployment (in the case of an internal error).

event_log[].event_type

The type of deployment event. Deployment event types include the start, stop, or completion of a deployment; a percentage update; the start or stop of a bake period; and the start or completion of a rollback.

event_log[].occurred_at

The date and time the event occurred.

event_log[].triggered_by

The entity that triggered the deployment event. Events can be triggered by a user, AppConfig, an Amazon CloudWatch alarm, or an internal error.

final_bake_time_in_minutes

The amount of time that AppConfig monitored for alarms before considering the deployment to be complete and no longer eligible for automatic rollback.

BIGINT
growth_factor

The percentage of targets to receive a deployed configuration during each interval.

DOUBLE
growth_type

The algorithm used to define how percentage grew over time.

VARCHAR
kms_key_arn

The Amazon Resource Name of the Key Management Service key used to encrypt configuration data. You can encrypt secrets stored in Secrets Manager, Amazon Simple Storage Service (Amazon S3) objects encrypted with SSE-KMS, or secure string parameters stored in Amazon Web Services Systems Manager Parameter Store. 

VARCHAR
kms_key_identifier

The Key Management Service key identifier (key ID, key alias, or key ARN) provided when the resource was created or updated.

VARCHAR
percentage_complete

The percentage of targets for which the deployment is available.

DOUBLE
started_at

The time the deployment started.

TIMESTAMP_S
state

The state of the deployment.

VARCHAR
version_label

A user-defined label for an AppConfig hosted configuration version.

VARCHAR