Skip to content
AWS for Query.Farm

aws.codepipeline.list_action_types

Example SQL Queries

SELECT * FROM
aws.codepipeline.list_action_types;

Description

Gets a summary of all CodePipeline action types associated with your account.

Table Definition

Column NameColumn Data Type
action_owner_filter Input Column

Filters the list of action types to those created by a specified entity.

VARCHAR
region_filter Input Column

The Region to filter on for the list of action types.

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
action_configuration_properties

The configuration properties for the action type.

STRUCT(
    "name" VARCHAR,
    "required" BOOLEAN,
    "key" BOOLEAN,
    "secret" BOOLEAN,
    "queryable" BOOLEAN,
    "description" VARCHAR,
    "type" VARCHAR
)[]
Show child fields
action_configuration_properties[]
Show child fields
action_configuration_properties[].description

The description of the action configuration property that is displayed to users.

action_configuration_properties[].key

Whether the configuration property is a key.

action_configuration_properties[].name

The name of the action configuration property.

action_configuration_properties[].queryable

Indicates that the property is used with PollForJobs. When creating a custom action, an action can have up to one queryable property. If it has one, that property must be both required and not secret.

If you create a pipeline with a custom action type, and that custom action contains a queryable property, the value for that configuration property is subject to other restrictions. The value must be less than or equal to twenty (20) characters. The value can contain only alphanumeric characters, underscores, and hyphens.

action_configuration_properties[].required

Whether the configuration property is a required value.

action_configuration_properties[].secret

Whether the configuration property is secret. Secrets are hidden from all calls except for GetJobDetails, GetThirdPartyJobDetails, PollForJobs, and PollForThirdPartyJobs.

When updating a pipeline, passing * * * * * without changing any other values of the action preserves the previous value of the secret.

action_configuration_properties[].type

The type of the configuration property.

id

Represents information about an action type.

STRUCT(
    "category" VARCHAR,
    "owner" VARCHAR,
    "provider" VARCHAR,
    "version" VARCHAR
)
Show child fields
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

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.

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.

id.version

A string that describes the action version.

input_artifact_details

The details of the input artifact for the action, such as its commit ID.

STRUCT(
    "minimum_count" BIGINT,
    "maximum_count" BIGINT
)
Show child fields
input_artifact_details.maximum_count

The maximum number of artifacts allowed for the action type.

input_artifact_details.minimum_count

The minimum number of artifacts allowed for the action type.

output_artifact_details

The details of the output artifact of the action, such as its commit ID.

STRUCT(
    "minimum_count" BIGINT,
    "maximum_count" BIGINT
)
Show child fields
output_artifact_details.maximum_count

The maximum number of artifacts allowed for the action type.

output_artifact_details.minimum_count

The minimum number of artifacts allowed for the action type.

settings

The settings for the action type.

STRUCT(
    "third_party_configuration_url" VARCHAR,
    "entity_url_template" VARCHAR,
    "execution_url_template" VARCHAR,
    "revision_url_template" VARCHAR
)
Show child fields
settings.entity_url_template

The URL returned to the CodePipeline console that provides a deep link to the resources of the external system, such as the configuration page for a CodeDeploy deployment group. This link is provided as part of the action display in the pipeline.

settings.execution_url_template

The URL returned to the CodePipeline console that contains a link to the top-level landing page for the external system, such as the console page for CodeDeploy. This link is shown on the pipeline view page in the CodePipeline console and provides a link to the execution entity of the external action.

settings.revision_url_template

The URL returned to the CodePipeline console that contains a link to the page where customers can update or change the configuration of the external action.

settings.third_party_configuration_url

The URL of a sign-up page where users can sign up for an external service and perform initial configuration of the action provided by that service.