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
  certificate_arn = $1;