turbot/aws_insights

Query: ecr_repository_tagging

Usage

powerpipe query aws_insights.query.ecr_repository_tagging

Steampipe Tables

SQL

with num_tags as (
select
cardinality(
array(
select
jsonb_object_keys(tags)
)
) as num_tag_keys
from
aws_ecr_repository
where
arn = $1
)
select
'Tags' as label,
num_tag_keys as value,
case
when num_tag_keys > 0 then 'ok'
else 'alert'
end as type
from
num_tags;

Dashboards

The query is used in the dashboards: