Skip to content

aws.codepipeline.list_action_executions

Example SQL Queries

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

Description

Lists the action executions that have occurred in a pipeline.

Table Definition

Column NameColumn Data Type
pipeline_name Required Input Column

The name of the pipeline for which you want to list action execution history.

VARCHAR
filter Input Column

Input information used to filter action execution history.

STRUCT(
"pipeline_execution_id" VARCHAR,
"latest_in_pipeline_execution" STRUCT(
"pipeline_execution_id" VARCHAR,
"start_time_range" VARCHAR
)
)
Show child fields
filter.latest_in_pipeline_execution

The latest execution in the pipeline.

Filtering on the latest execution is available for executions run on or after February 08, 2024.

Show child fields
filter.latest_in_pipeline_execution.pipeline_execution_id

The execution ID for the latest execution in the pipeline.

filter.latest_in_pipeline_execution.start_time_range

The start time to filter on for the latest execution in the pipeline. Valid options:

  • All

  • Latest

filter.pipeline_execution_id

The pipeline execution ID used to filter action execution history.

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

The action execution ID.

VARCHAR
action_name

The name of the action.

VARCHAR
input

Input details for the action execution, such as role ARN, Region, and input artifacts.

STRUCT(
"action_type_id" STRUCT(
"category" VARCHAR,
"owner" VARCHAR,
"provider" VARCHAR,
"version" VARCHAR
),
"configuration" MAP(VARCHAR, VARCHAR),
"resolved_configuration" MAP(VARCHAR, VARCHAR),
"role_arn" VARCHAR,
"region" VARCHAR,
"input_artifacts" STRUCT(
"name" VARCHAR,
"s3location" STRUCT(
"bucket" VARCHAR,
"key" VARCHAR
)
)[],
"namespace" VARCHAR
)
Show child fields
input.action_type_id

Represents information about an action type.

Show child fields
input.action_type_id.category

A category defines what kind of action can be taken in the stage, and constrains the provider type for the action. Valid categories are limited to one of the following values.

  • Source

  • Build

  • Test

  • Deploy

  • Invoke

  • Approval

input.action_type_id.owner

The creator of the action being called. There are three valid values for the Owner field in the action category section within your pipeline structure: AWS, ThirdParty, and Custom. For more information, see Valid Action Types and Providers in CodePipeline.

input.action_type_id.provider

The provider of the service being called by the action. Valid providers are determined by the action category. For example, an action in the Deploy category type might have a provider of CodeDeploy, which would be specified as CodeDeploy. For more information, see Valid Action Types and Providers in CodePipeline.

input.action_type_id.version

A string that describes the action version.

input.configuration

Configuration data for an action execution.

input.input_artifacts[]
Show child fields
input.input_artifacts[].name

The artifact object name for the action execution.

input.input_artifacts[].s3location

The Amazon S3 artifact location for the action execution.

Show child fields
input.input_artifacts[].s3location.bucket

The Amazon S3 artifact bucket for an action's artifacts.

input.input_artifacts[].s3location.key

The artifact name.

input.namespace

The variable namespace associated with the action. All variables produced as output by this action fall under this namespace.

input.region

The Amazon Web Services Region for the action, such as us-east-1.

input.resolved_configuration

Configuration data for an action execution with all variable references replaced with their real values for the execution.

input.role_arn

The ARN of the IAM service role that performs the declared action. This is assumed through the roleArn for the pipeline.

last_update_time

The last update time of the action execution.

TIMESTAMP_S
output

Output details for the action execution, such as the action execution result.

STRUCT(
"output_artifacts" STRUCT(
"name" VARCHAR,
"s3location" STRUCT(
"bucket" VARCHAR,
"key" VARCHAR
)
)[],
"execution_result" STRUCT(
"external_execution_id" VARCHAR,
"external_execution_summary" VARCHAR,
"external_execution_url" VARCHAR,
"error_details" STRUCT(
"code" VARCHAR,
"message" VARCHAR
)
),
"output_variables" MAP(VARCHAR, VARCHAR)
)
Show child fields
output.execution_result

Execution result information listed in the output details for an action execution.

Show child fields
output.execution_result.error_details

Represents information about an error in CodePipeline.

Show child fields
output.execution_result.error_details.code

The system ID or number code of the error.

output.execution_result.error_details.message

The text of the error message.

output.execution_result.external_execution_id

The action provider's external ID for the action execution.

output.execution_result.external_execution_summary

The action provider's summary for the action execution.

output.execution_result.external_execution_url

The deepest external link to the external resource (for example, a repository URL or deployment endpoint) that is used when running the action.

output.output_artifacts[]
Show child fields
output.output_artifacts[].name

The artifact object name for the action execution.

output.output_artifacts[].s3location

The Amazon S3 artifact location for the action execution.

Show child fields
output.output_artifacts[].s3location.bucket

The Amazon S3 artifact bucket for an action's artifacts.

output.output_artifacts[].s3location.key

The artifact name.

output.output_variables

The outputVariables field shows the key-value pairs that were output as part of that execution.

pipeline_execution_id

The pipeline execution ID for the action execution.

VARCHAR
pipeline_version

The version of the pipeline where the action was run.

BIGINT
stage_name

The name of the stage that contains the action.

VARCHAR
start_time

The start time of the action execution.

TIMESTAMP_S
status

The status of the action execution. Status categories are InProgress, Succeeded, and Failed.

VARCHAR
updated_by

The ARN of the user who changed the pipeline execution details.

VARCHAR