Skip to content
AWS for Query.Farm

aws.codepipeline.list_rule_executions

Example SQL Queries

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

Description

Lists the rule executions that have occurred in a pipeline configured for conditions with rules.

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

Input information used to filter rule 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 field that specifies to filter on 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 rule 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
input

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

STRUCT(
    "rule_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
        )
    )[]
)
Show child fields
input.configuration

Configuration data for a rule execution, such as the resolved values for that run.

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.region

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

input.resolved_configuration

Configuration data for a rule 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 rule. This is assumed through the roleArn for the pipeline.

input.rule_type_id

The ID for the rule type, which is made up of the combined values for category, owner, provider, and version.

Show child fields
input.rule_type_id.category

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

  • INVOKE

  • Approval

  • Rule

input.rule_type_id.owner

The creator of the rule being called. The valid value for the Owner field in the rule category is AWS.

input.rule_type_id.provider

The provider of the service being called by the rule. Valid providers are determined by the rulecategory. For example, a managed rule in the Rule category type has an owner of AWS, which would be specified as AWS.

input.rule_type_id.version

A string that describes the rule version.

last_update_time

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

TIMESTAMP_S
output

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

STRUCT(
    "execution_result" STRUCT(
        "external_execution_id" VARCHAR,
        "external_execution_summary" VARCHAR,
        "external_execution_url" VARCHAR,
        "error_details" STRUCT(
            "code" VARCHAR,
            "message" VARCHAR
        )
    )
)
Show child fields
output.execution_result

Execution result information listed in the output details for a rule 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 external ID for the rule execution.

output.execution_result.external_execution_summary

The external provider summary for the rule 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 rule.

pipeline_execution_id

The ID of the pipeline execution in the stage where the rule was run. Use the GetPipelineState action to retrieve the current pipelineExecutionId of the stage.

VARCHAR
pipeline_version

The version number of the pipeline with the stage where the rule was run.

BIGINT
rule_execution_id

The ID of the run for the rule.

VARCHAR
rule_name

The name of the rule that was run in the stage.

VARCHAR
stage_name

The name of the stage where the rule was run.

VARCHAR
start_time

The start time of the rule execution.

TIMESTAMP_S
status

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

VARCHAR
updated_by

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

VARCHAR