Skip to content
AWS for Query.Farm

aws.codedeploy.get_deployment_instance

Example SQL Queries

SELECT * FROM
aws.codedeploy.get_deployment_instance
WHERE
"deployment_id" = 'VALUE'
AND "instance_id" = 'VALUE';

Description

Gets information about an instance as part of a deployment.

Table Definition

Column NameColumn Data Type
deployment_id Required Input Column

The unique ID of a deployment. 

VARCHAR
instance_id Required Input Column

The unique ID of an instance in the deployment group. 

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
instance_summary

Information about the instance. 

STRUCT(
    "deployment_id" VARCHAR,
    "instance_id" VARCHAR,
    "status" VARCHAR,
    "last_updated_at" TIMESTAMP_S,
    "lifecycle_events" STRUCT(
        "lifecycle_event_name" VARCHAR,
        "diagnostics" STRUCT(
            "error_code" VARCHAR,
            "script_name" VARCHAR,
            "message" VARCHAR,
            "log_tail" VARCHAR
        ),
        "start_time" TIMESTAMP_S,
        "end_time" TIMESTAMP_S,
        "status" VARCHAR
    )[],
    "instance_type" VARCHAR
)
Show child fields
instance_summary.deployment_id

The unique ID of a deployment.

instance_summary.instance_id

The instance ID.

instance_summary.instance_type

Information about which environment an instance belongs to in a blue/green deployment.

  • BLUE: The instance is part of the original environment.

  • GREEN: The instance is part of the replacement environment.

instance_summary.last_updated_at

A timestamp that indicates when the instance information was last updated.

instance_summary.lifecycle_events[]
Show child fields
instance_summary.lifecycle_events[].diagnostics

Diagnostic information about the deployment lifecycle event.

Show child fields
instance_summary.lifecycle_events[].diagnostics.error_code

The associated error code:

  • Success: The specified script ran.

  • ScriptMissing: The specified script was not found in the specified location.

  • ScriptNotExecutable: The specified script is not a recognized executable file type.

  • ScriptTimedOut: The specified script did not finish running in the specified time period.

  • ScriptFailed: The specified script failed to run as expected.

  • UnknownError: The specified script did not run for an unknown reason.

instance_summary.lifecycle_events[].diagnostics.log_tail

The last portion of the diagnostic log.

If available, CodeDeploy returns up to the last 4 KB of the diagnostic log.

instance_summary.lifecycle_events[].diagnostics.message

The message associated with the error.

instance_summary.lifecycle_events[].diagnostics.script_name

The name of the script.

instance_summary.lifecycle_events[].end_time

A timestamp that indicates when the deployment lifecycle event ended.

instance_summary.lifecycle_events[].lifecycle_event_name

The deployment lifecycle event name, such as ApplicationStop, BeforeInstall, AfterInstall, ApplicationStart, or ValidateService.

instance_summary.lifecycle_events[].start_time

A timestamp that indicates when the deployment lifecycle event started.

instance_summary.lifecycle_events[].status

The deployment lifecycle event status:

  • Pending: The deployment lifecycle event is pending.

  • InProgress: The deployment lifecycle event is in progress.

  • Succeeded: The deployment lifecycle event ran successfully.

  • Failed: The deployment lifecycle event has failed.

  • Skipped: The deployment lifecycle event has been skipped.

  • Unknown: The deployment lifecycle event is unknown.

instance_summary.status

The deployment status for this instance:

  • Pending: The deployment is pending for this instance.

  • In Progress: The deployment is in progress for this instance.

  • Succeeded: The deployment has succeeded for this instance.

  • Failed: The deployment has failed for this instance.

  • Skipped: The deployment has been skipped for this instance.

  • Unknown: The deployment status is unknown for this instance.