Skip to content
AWS for Query.Farm

aws.codepipeline.get_pipeline_state

Example SQL Queries

SELECT * FROM
aws.codepipeline.get_pipeline_state
WHERE
"name" = 'VALUE';

Description

Returns information about the state of a pipeline, including the stages and actions.

Values returned in the revisionId and revisionUrl fields indicate the source revision information, such as the commit ID, for the current state.

Table Definition

Column NameColumn Data Type
name Required Input Column

The name of the pipeline about which you want to get information.

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
created

The date and time the pipeline was created, in timestamp format.

TIMESTAMP_S
pipeline_name

The name of the pipeline for which you want to get the state.

VARCHAR
pipeline_version

The version number of the pipeline.

A newly created pipeline is always assigned a version number of 1.

BIGINT
stage_states

A list of the pipeline stage output information, including stage name, state, most recent run details, whether the stage is disabled, and other data.

STRUCT(
    "stage_name" VARCHAR,
    "inbound_execution" STRUCT(
        "pipeline_execution_id" VARCHAR,
        "status" VARCHAR,
        "type" VARCHAR
    ),
    "inbound_executions" STRUCT(
        "pipeline_execution_id" VARCHAR,
        "status" VARCHAR,
        "type" VARCHAR
    )[],
    "inbound_transition_state" STRUCT(
        "enabled" BOOLEAN,
        "last_changed_by" VARCHAR,
        "last_changed_at" TIMESTAMP_S,
        "disabled_reason" VARCHAR
    ),
    "action_states" STRUCT(
        "action_name" VARCHAR,
        "current_revision" STRUCT(
            "revision_id" VARCHAR,
            "revision_change_id" VARCHAR,
            "created" TIMESTAMP_S
        ),
        "latest_execution" STRUCT(
            "action_execution_id" VARCHAR,
            "status" VARCHAR,
            "summary" VARCHAR,
            "last_status_change" TIMESTAMP_S,
            "token" VARCHAR,
            "last_updated_by" VARCHAR,
            "external_execution_id" VARCHAR,
            "external_execution_url" VARCHAR,
            "percent_complete" BIGINT,
            "error_details" STRUCT(
                "code" VARCHAR,
                "message" VARCHAR
            )
        ),
        "entity_url" VARCHAR,
        "revision_url" VARCHAR
    )[],
    "latest_execution" STRUCT(
        "pipeline_execution_id" VARCHAR,
        "status" VARCHAR,
        "type" VARCHAR
    ),
    "before_entry_condition_state" STRUCT(
        "latest_execution" STRUCT(
            "status" VARCHAR,
            "summary" VARCHAR
        ),
        "condition_states" STRUCT(
            "latest_execution" STRUCT(
                "status" VARCHAR,
                "summary" VARCHAR,
                "last_status_change" TIMESTAMP_S
            ),
            "rule_states" STRUCT(
                "rule_name" VARCHAR,
                "current_revision" STRUCT(
                    "revision_id" VARCHAR,
                    "revision_change_id" VARCHAR,
                    "created" TIMESTAMP_S
                ),
                "latest_execution" STRUCT(
                    "rule_execution_id" VARCHAR,
                    "status" VARCHAR,
                    "summary" VARCHAR,
                    "last_status_change" TIMESTAMP_S,
                    "token" VARCHAR,
                    "last_updated_by" VARCHAR,
                    "external_execution_id" VARCHAR,
                    "external_execution_url" VARCHAR,
                    "error_details" STRUCT(
                        "code" VARCHAR,
                        "message" VARCHAR
                    )
                ),
                "entity_url" VARCHAR,
                "revision_url" VARCHAR
            )[]
        )[]
    ),
    "on_success_condition_state" STRUCT(
        "latest_execution" STRUCT(
            "status" VARCHAR,
            "summary" VARCHAR
        ),
        "condition_states" STRUCT(
            "latest_execution" STRUCT(
                "status" VARCHAR,
                "summary" VARCHAR,
                "last_status_change" TIMESTAMP_S
            ),
            "rule_states" STRUCT(
                "rule_name" VARCHAR,
                "current_revision" STRUCT(
                    "revision_id" VARCHAR,
                    "revision_change_id" VARCHAR,
                    "created" TIMESTAMP_S
                ),
                "latest_execution" STRUCT(
                    "rule_execution_id" VARCHAR,
                    "status" VARCHAR,
                    "summary" VARCHAR,
                    "last_status_change" TIMESTAMP_S,
                    "token" VARCHAR,
                    "last_updated_by" VARCHAR,
                    "external_execution_id" VARCHAR,
                    "external_execution_url" VARCHAR,
                    "error_details" STRUCT(
                        "code" VARCHAR,
                        "message" VARCHAR
                    )
                ),
                "entity_url" VARCHAR,
                "revision_url" VARCHAR
            )[]
        )[]
    ),
    "on_failure_condition_state" STRUCT(
        "latest_execution" STRUCT(
            "status" VARCHAR,
            "summary" VARCHAR
        ),
        "condition_states" STRUCT(
            "latest_execution" STRUCT(
                "status" VARCHAR,
                "summary" VARCHAR,
                "last_status_change" TIMESTAMP_S
            ),
            "rule_states" STRUCT(
                "rule_name" VARCHAR,
                "current_revision" STRUCT(
                    "revision_id" VARCHAR,
                    "revision_change_id" VARCHAR,
                    "created" TIMESTAMP_S
                ),
                "latest_execution" STRUCT(
                    "rule_execution_id" VARCHAR,
                    "status" VARCHAR,
                    "summary" VARCHAR,
                    "last_status_change" TIMESTAMP_S,
                    "token" VARCHAR,
                    "last_updated_by" VARCHAR,
                    "external_execution_id" VARCHAR,
                    "external_execution_url" VARCHAR,
                    "error_details" STRUCT(
                        "code" VARCHAR,
                        "message" VARCHAR
                    )
                ),
                "entity_url" VARCHAR,
                "revision_url" VARCHAR
            )[]
        )[]
    )
)[]
Show child fields
stage_states[]
Show child fields
stage_states[].action_states[]
Show child fields
stage_states[].action_states[].action_name

The name of the action.

stage_states[].action_states[].current_revision

Represents information about the version (or revision) of an action.

Show child fields
stage_states[].action_states[].current_revision.created

The date and time when the most recent version of the action was created, in timestamp format.

stage_states[].action_states[].current_revision.revision_change_id

The unique identifier of the change that set the state to this revision (for example, a deployment ID or timestamp).

stage_states[].action_states[].current_revision.revision_id

The system-generated unique ID that identifies the revision number of the action.

stage_states[].action_states[].entity_url

A URL link for more information about the state of the action, such as a deployment group details page.

stage_states[].action_states[].latest_execution

Represents information about the run of an action.

Show child fields
stage_states[].action_states[].latest_execution.action_execution_id

ID of the workflow action execution in the current stage. Use the GetPipelineState action to retrieve the current action execution details of the current stage.

For older executions, this field might be empty. The action execution ID is available for executions run on or after March 2020.

stage_states[].action_states[].latest_execution.error_details

The details of an error returned by a URL external to Amazon Web Services.

Show child fields
stage_states[].action_states[].latest_execution.error_details.code

The system ID or number code of the error.

stage_states[].action_states[].latest_execution.error_details.message

The text of the error message.

stage_states[].action_states[].latest_execution.external_execution_id

The external ID of the run of the action.

stage_states[].action_states[].latest_execution.external_execution_url

The URL of a resource external to Amazon Web Services that is used when running the action (for example, an external repository URL).

stage_states[].action_states[].latest_execution.last_status_change

The last status change of the action.

stage_states[].action_states[].latest_execution.last_updated_by

The ARN of the user who last changed the pipeline.

stage_states[].action_states[].latest_execution.percent_complete

A percentage of completeness of the action as it runs.

stage_states[].action_states[].latest_execution.status

The status of the action, or for a completed action, the last status of the action.

stage_states[].action_states[].latest_execution.summary

A summary of the run of the action.

stage_states[].action_states[].latest_execution.token

The system-generated token used to identify a unique approval request. The token for each open approval request can be obtained using the GetPipelineState command. It is used to validate that the approval request corresponding to this token is still valid.

stage_states[].action_states[].revision_url

A URL link for more information about the revision, such as a commit details page.

stage_states[].before_entry_condition_state

The state of the entry conditions for a stage.

Show child fields
stage_states[].before_entry_condition_state.condition_states[]
Show child fields
stage_states[].before_entry_condition_state.condition_states[].latest_execution

The state of the latest run of the rule.

Show child fields
stage_states[].before_entry_condition_state.condition_states[].latest_execution.last_status_change

The last status change of the condition.

stage_states[].before_entry_condition_state.condition_states[].latest_execution.status

The status of the run for a condition.

stage_states[].before_entry_condition_state.condition_states[].latest_execution.summary

The summary of information about a run for a condition.

stage_states[].before_entry_condition_state.condition_states[].rule_states[]
Show child fields
stage_states[].before_entry_condition_state.condition_states[].rule_states[].current_revision

The ID of the current revision of the artifact successfully worked on by the job.

Show child fields
stage_states[].before_entry_condition_state.condition_states[].rule_states[].current_revision.created

The date and time when the most recent version of the rule was created, in timestamp format.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].current_revision.revision_change_id

The unique identifier of the change that set the state to this revision (for example, a deployment ID or timestamp).

stage_states[].before_entry_condition_state.condition_states[].rule_states[].current_revision.revision_id

The system-generated unique ID that identifies the revision number of the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].entity_url

A URL link for more information about the state of the action, such as a details page.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution

Represents information about the latest run of an rule.

Show child fields
stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.error_details

Represents information about an error in CodePipeline.

Show child fields
stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.error_details.code

The system ID or number code of the error.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.error_details.message

The text of the error message.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.external_execution_id

The external ID of the run of the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.external_execution_url

The URL of a resource external to Amazon Web Services that is used when running the rule (for example, an external repository URL).

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.last_status_change

The last status change of the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.last_updated_by

The ARN of the user who last changed the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.rule_execution_id

The execution ID for the run of the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.status

The status of the run of the rule, such as FAILED.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.summary

A summary of the run of the rule.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].latest_execution.token

The system-generated token used to identify a unique request.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].revision_url

A URL link for more information about the revision, such as a commit details page.

stage_states[].before_entry_condition_state.condition_states[].rule_states[].rule_name

The name of the rule.

stage_states[].before_entry_condition_state.latest_execution

Represents information about the latest run of a condition for a stage.

Show child fields
stage_states[].before_entry_condition_state.latest_execution.status

The status of a run of a condition for a stage.

stage_states[].before_entry_condition_state.latest_execution.summary

A summary of the run of the condition for a stage.

stage_states[].inbound_execution

Represents information about the run of a stage.

Show child fields
stage_states[].inbound_execution.pipeline_execution_id

The ID of the pipeline execution associated with the stage.

stage_states[].inbound_execution.status

The status of the stage, or for a completed stage, the last status of the stage.

A status of cancelled means that the pipeline’s definition was updated before the stage execution could be completed.

stage_states[].inbound_execution.type

The type of pipeline execution for the stage, such as a rollback pipeline execution.

stage_states[].inbound_executions[]
Show child fields
stage_states[].inbound_executions[].pipeline_execution_id

The ID of the pipeline execution associated with the stage.

stage_states[].inbound_executions[].status

The status of the stage, or for a completed stage, the last status of the stage.

A status of cancelled means that the pipeline’s definition was updated before the stage execution could be completed.

stage_states[].inbound_executions[].type

The type of pipeline execution for the stage, such as a rollback pipeline execution.

stage_states[].inbound_transition_state

The state of the inbound transition, which is either enabled or disabled.

Show child fields
stage_states[].inbound_transition_state.disabled_reason

The user-specified reason why the transition between two stages of a pipeline was disabled.

stage_states[].inbound_transition_state.enabled

Whether the transition between stages is enabled (true) or disabled (false).

stage_states[].inbound_transition_state.last_changed_at

The timestamp when the transition state was last changed.

stage_states[].inbound_transition_state.last_changed_by

The ID of the user who last changed the transition state.

stage_states[].latest_execution

Information about the latest execution in the stage, including its ID and status.

Show child fields
stage_states[].latest_execution.pipeline_execution_id

The ID of the pipeline execution associated with the stage.

stage_states[].latest_execution.status

The status of the stage, or for a completed stage, the last status of the stage.

A status of cancelled means that the pipeline’s definition was updated before the stage execution could be completed.

stage_states[].latest_execution.type

The type of pipeline execution for the stage, such as a rollback pipeline execution.

stage_states[].on_failure_condition_state

The state of the failure conditions for a stage.

Show child fields
stage_states[].on_failure_condition_state.condition_states[]
Show child fields
stage_states[].on_failure_condition_state.condition_states[].latest_execution

The state of the latest run of the rule.

Show child fields
stage_states[].on_failure_condition_state.condition_states[].latest_execution.last_status_change

The last status change of the condition.

stage_states[].on_failure_condition_state.condition_states[].latest_execution.status

The status of the run for a condition.

stage_states[].on_failure_condition_state.condition_states[].latest_execution.summary

The summary of information about a run for a condition.

stage_states[].on_failure_condition_state.condition_states[].rule_states[]
Show child fields
stage_states[].on_failure_condition_state.condition_states[].rule_states[].current_revision

The ID of the current revision of the artifact successfully worked on by the job.

Show child fields
stage_states[].on_failure_condition_state.condition_states[].rule_states[].current_revision.created

The date and time when the most recent version of the rule was created, in timestamp format.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].current_revision.revision_change_id

The unique identifier of the change that set the state to this revision (for example, a deployment ID or timestamp).

stage_states[].on_failure_condition_state.condition_states[].rule_states[].current_revision.revision_id

The system-generated unique ID that identifies the revision number of the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].entity_url

A URL link for more information about the state of the action, such as a details page.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution

Represents information about the latest run of an rule.

Show child fields
stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.error_details

Represents information about an error in CodePipeline.

Show child fields
stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.error_details.code

The system ID or number code of the error.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.error_details.message

The text of the error message.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.external_execution_id

The external ID of the run of the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.external_execution_url

The URL of a resource external to Amazon Web Services that is used when running the rule (for example, an external repository URL).

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.last_status_change

The last status change of the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.last_updated_by

The ARN of the user who last changed the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.rule_execution_id

The execution ID for the run of the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.status

The status of the run of the rule, such as FAILED.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.summary

A summary of the run of the rule.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].latest_execution.token

The system-generated token used to identify a unique request.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].revision_url

A URL link for more information about the revision, such as a commit details page.

stage_states[].on_failure_condition_state.condition_states[].rule_states[].rule_name

The name of the rule.

stage_states[].on_failure_condition_state.latest_execution

Represents information about the latest run of a condition for a stage.

Show child fields
stage_states[].on_failure_condition_state.latest_execution.status

The status of a run of a condition for a stage.

stage_states[].on_failure_condition_state.latest_execution.summary

A summary of the run of the condition for a stage.

stage_states[].on_success_condition_state

The state of the success conditions for a stage.

Show child fields
stage_states[].on_success_condition_state.condition_states[]
Show child fields
stage_states[].on_success_condition_state.condition_states[].latest_execution

The state of the latest run of the rule.

Show child fields
stage_states[].on_success_condition_state.condition_states[].latest_execution.last_status_change

The last status change of the condition.

stage_states[].on_success_condition_state.condition_states[].latest_execution.status

The status of the run for a condition.

stage_states[].on_success_condition_state.condition_states[].latest_execution.summary

The summary of information about a run for a condition.

stage_states[].on_success_condition_state.condition_states[].rule_states[]
Show child fields
stage_states[].on_success_condition_state.condition_states[].rule_states[].current_revision

The ID of the current revision of the artifact successfully worked on by the job.

Show child fields
stage_states[].on_success_condition_state.condition_states[].rule_states[].current_revision.created

The date and time when the most recent version of the rule was created, in timestamp format.

stage_states[].on_success_condition_state.condition_states[].rule_states[].current_revision.revision_change_id

The unique identifier of the change that set the state to this revision (for example, a deployment ID or timestamp).

stage_states[].on_success_condition_state.condition_states[].rule_states[].current_revision.revision_id

The system-generated unique ID that identifies the revision number of the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].entity_url

A URL link for more information about the state of the action, such as a details page.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution

Represents information about the latest run of an rule.

Show child fields
stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.error_details

Represents information about an error in CodePipeline.

Show child fields
stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.error_details.code

The system ID or number code of the error.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.error_details.message

The text of the error message.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.external_execution_id

The external ID of the run of the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.external_execution_url

The URL of a resource external to Amazon Web Services that is used when running the rule (for example, an external repository URL).

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.last_status_change

The last status change of the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.last_updated_by

The ARN of the user who last changed the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.rule_execution_id

The execution ID for the run of the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.status

The status of the run of the rule, such as FAILED.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.summary

A summary of the run of the rule.

stage_states[].on_success_condition_state.condition_states[].rule_states[].latest_execution.token

The system-generated token used to identify a unique request.

stage_states[].on_success_condition_state.condition_states[].rule_states[].revision_url

A URL link for more information about the revision, such as a commit details page.

stage_states[].on_success_condition_state.condition_states[].rule_states[].rule_name

The name of the rule.

stage_states[].on_success_condition_state.latest_execution

Represents information about the latest run of a condition for a stage.

Show child fields
stage_states[].on_success_condition_state.latest_execution.status

The status of a run of a condition for a stage.

stage_states[].on_success_condition_state.latest_execution.summary

A summary of the run of the condition for a stage.

stage_states[].stage_name

The name of the stage.

updated

The date and time the pipeline was last updated, in timestamp format.

TIMESTAMP_S