Table: aws_codepipeline_pipeline - Query AWS CodePipeline Pipeline using SQL

The AWS CodePipeline is a fully managed continuous delivery service that helps you automate your release pipelines for fast and reliable application and infrastructure updates. CodePipeline automates the build, test, and deploy phases of your release process every time there is a code change, based on the release model you define. This enables you to rapidly and reliably deliver features and updates.

Table Usage Guide

The aws_codepipeline_pipeline table in Steampipe provides you with information about pipelines within AWS CodePipeline. This table allows you, as a DevOps engineer, to query pipeline-specific details, including pipeline names, statuses, stages, and associated metadata. You can utilize this table to gather insights on pipelines, such as pipeline execution history, pipeline settings, and more. The schema outlines the various attributes of the pipeline for you, including the pipeline ARN, creation date, stages, and associated tags.

Examples

Basic info

Discover the segments that are part of the AWS CodePipeline service. This information can be useful for auditing, tracking resource usage, and understanding your overall AWS environment.

select
  name,
  arn,
  tags_src,
  region,
  account_id
from
  aws_codepipeline_pipeline;

select
  name,
  arn,
  tags_src,
  region,
  account_id
from
  aws_codepipeline_pipeline;

List unencrypted pipelines

Discover the segments that have unencrypted pipelines in the AWS CodePipeline service to enhance your security measures. This helps in identifying potential security risks and taking necessary actions to protect your data.

select
  name,
  arn,
  encryption_key
from
  aws_codepipeline_pipeline
where
  encryption_key is null;

select
  name,
  arn,
  encryption_key
from
  aws_codepipeline_pipeline
where
  encryption_key is null;

Query examples

Schema for aws_codepipeline_pipeline

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The AWS Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
arn	text		The Amazon Resource Name (ARN) of the pipeline.
artifact_stores	jsonb		A mapping of artifactStore objects and their corresponding AWS Regions. There must be an artifact store for the pipeline Region and for each cross-region action in the pipeline.
created_at	timestamp with time zone		The date and time the pipeline was created.
encryption_key	jsonb		The encryption key used to encrypt the data in the artifact store, such as an AWS Key Management Service (AWS KMS) key. If this is undefined, the default key for Amazon S3 is used.
execution_mode	text		The method that the pipeline will use to handle multiple executions.
name	text	=	The name of the pipeline.
partition	text		The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
pipeline_type	text		The pipeline type.
region	text		The AWS Region in which the resource is located.
role_arn	text		The Amazon Resource Name (ARN) for AWS CodePipeline to use to either perform actions with no actionRoleArn, or to use to assume roles for actions with an actionRoleArn.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
stages	jsonb		The stage in which to perform the action.
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tag key and value pairs associated with this pipeline.
title	text		Title of the resource.
triggers	jsonb		The trigger configuration specifying a type of event, such as Git tags, that starts the pipeline.
updated_at	timestamp with time zone		The date and time of the last update to the pipeline.
variables	jsonb		A list that defines the pipeline variables for a pipeline resource.
version	bigint		The version number of the pipeline.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_codepipeline_pipeline