turbot/aws_insights

Query: codepipeline_pipeline_stages

Usage

powerpipe query aws_insights.query.codepipeline_pipeline_stages

SQL

select
s ->> 'Name' as "Name",
a as "Actions"
from
aws_codepipeline_pipeline,
jsonb_array_elements(stages) as s,
jsonb_array_elements(s -> 'Actions') as a
where
arn = $1
and region = split_part($1, ':', 4)
and account_id = split_part($1, ':', 5);

Dashboards

The query is used in the dashboards: