Query: acm_certificate_in_use_by

select
  c.certificate_arn as "ARN",
  in_use as "In Use By"
from
  aws_acm_certificate as c,
  jsonb_array_elements_text(in_use_by) as in_use
where
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and certificate_arn = $1;