Query: acm_certificate_transparency_logging_status

select
  case when certificate_transparency_logging_preference = 'ENABLED' then 'Enabled' else 'Disabled' end as value,
  'Transparency Logging' as label,
  case when certificate_transparency_logging_preference = 'ENABLED' then 'ok' else 'alert' end as "type"
from
  aws_acm_certificate
where
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and certificate_arn = $1;