Skip to content

aws.codepipeline.list_pipeline_executions

Example SQL Queries

SELECT * FROM
aws.codepipeline.list_pipeline_executions
WHERE
"pipeline_name" = 'VALUE';

Description

Gets a summary of the most recent executions for a pipeline.

When applying the filter for pipeline executions that have succeeded in the stage, the operation returns all executions in the current pipeline version beginning on February 1, 2024.

Table Definition

Column NameColumn Data Type
pipeline_name Required Input Column

The name of the pipeline for which you want to get execution summary information.

VARCHAR
filter Input Column

The pipeline execution to filter on.

STRUCT(
"succeeded_in_stage" STRUCT(
"stage_name" VARCHAR
)
)
Show child fields
filter.succeeded_in_stage

Filter for pipeline executions where the stage was successful in the current pipeline version.

Show child fields
filter.succeeded_in_stage.stage_name

The name of the stage for filtering for pipeline executions where the stage was successful in the current pipeline version.

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

The method that the pipeline will use to handle multiple executions. The default mode is SUPERSEDED.

VARCHAR
execution_type

Type of the pipeline execution.

VARCHAR
last_update_time

The date and time of the last change to the pipeline execution, in timestamp format.

TIMESTAMP_S
pipeline_execution_id

The ID of the pipeline execution.

VARCHAR
rollback_metadata

The metadata for the stage execution to be rolled back.

STRUCT(
"rollback_target_pipeline_execution_id" VARCHAR
)
Show child fields
rollback_metadata.rollback_target_pipeline_execution_id

The pipeline execution ID to which the stage will be rolled back.

source_revisions

A list of the source artifact revisions that initiated a pipeline execution.

STRUCT(
"action_name" VARCHAR,
"revision_id" VARCHAR,
"revision_summary" VARCHAR,
"revision_url" VARCHAR
)[]
Show child fields
source_revisions[]
Show child fields
source_revisions[].action_name

The name of the action that processed the revision to the source artifact.

source_revisions[].revision_id

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

source_revisions[].revision_summary

Summary information about the most recent revision of the artifact. For GitHub and CodeCommit repositories, the commit message. For Amazon S3 buckets or actions, the user-provided content of a codepipeline-artifact-revision-summary key specified in the object metadata.

source_revisions[].revision_url

The commit ID for the artifact revision. For artifacts stored in GitHub or CodeCommit repositories, the commit ID is linked to a commit details page.

start_time

The date and time when the pipeline execution began, in timestamp format.

TIMESTAMP_S
status

The status of the pipeline execution.

  • InProgress: The pipeline execution is currently running.

  • Stopped: The pipeline execution was manually stopped. For more information, see Stopped Executions.

  • Stopping: The pipeline execution received a request to be manually stopped. Depending on the selected stop mode, the execution is either completing or abandoning in-progress actions. For more information, see Stopped Executions.

  • Succeeded: The pipeline execution was completed successfully.

  • Superseded: While this pipeline execution was waiting for the next stage to be completed, a newer pipeline execution advanced and continued through the pipeline instead. For more information, see Superseded Executions.

  • Failed: The pipeline execution was not completed successfully.

VARCHAR
status_summary

Status summary for the pipeline.

VARCHAR
stop_trigger

The interaction that stopped a pipeline execution.

STRUCT(
"reason" VARCHAR
)
Show child fields
stop_trigger.reason

The user-specified reason the pipeline was stopped.

trigger

The interaction or event that started a pipeline execution, such as automated change detection or a StartPipelineExecution API call.

STRUCT(
"trigger_type" VARCHAR,
"trigger_detail" VARCHAR
)
Show child fields
trigger.trigger_detail

Detail related to the event that started a pipeline execution, such as the webhook ARN of the webhook that triggered the pipeline execution or the user ARN for a user-initiated start-pipeline-execution CLI command.

trigger.trigger_type

The type of change-detection method, command, or user interaction that started a pipeline execution.