Query: acm_certificate_domain_validation_options

select
  option ->> 'DomainName' as "Domain Name",
  option ->> 'ResourceRecord' as "Resource Record",
  option ->> 'ValidationDomain' as "Validation Domain",
  option -> 'ValidationEmails' as "Validation Emails",
  option ->> 'ValidationMethod' as "Validation Method",
  option ->> 'ValidationStatus' as "Validation Status"
from
  aws_acm_certificate as c,
  jsonb_array_elements(domain_validation_options) as option
where
  account_id = split_part($1, ':', 5)
  and region = split_part($1, ':', 4)
  and certificate_arn = $1;