Query: ecr_repository_tagging

with num_tags as (
  select
    cardinality(array(select jsonb_object_keys(tags))) as num_tag_keys
  from
    aws_ecr_repository
  where
    arn = $1
    and region = split_part($1, ':', 4)
    and account_id = split_part($1, ':', 5)
)
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;