Query: codepipeline_pipeline_unencrypted_count

select
  count(*) as value,
  'Unencrypted' as label,
  case
    when count(*) > 0 then 'alert' else 'ok' end as "type"
from
  aws_codepipeline_pipeline
where
  encryption_key is null;