steampipe plugin install aws

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;

Schema for aws_codepipeline_pipeline

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
account_idtextThe AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) of the pipeline.
artifact_storesjsonbA 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_attimestamp with time zoneThe date and time the pipeline was created.
encryption_keyjsonbThe 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.
nametext=The name of the pipeline.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
role_arntextThe 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.
stagesjsonbThe stage in which to perform the action.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tag key and value pairs associated with this pipeline.
titletextTitle of the resource.
updated_attimestamp with time zoneThe date and time of the last update to the pipeline.
versionbigintThe 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