Query: acm_certificate_key_usage

select
  usage ->> 'Name' as "Usage Name",
  key_algorithm as "Key Algorithm"
from
  aws_acm_certificate as c,
  jsonb_array_elements(extended_key_usages) as usage
where
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and certificate_arn = $1;