Table: aws_route53_hosted_zones

This table shows data for Amazon Route 53 Hosted Zones.

https://docs.aws.amazon.com/Route53/latest/APIReference/API_HostedZone.html (opens in a new tab)

The primary key for this table is arn.

Relations

The following tables depend on aws_route53_hosted_zones:

• aws_route53_hosted_zone_query_logging_configs
• aws_route53_hosted_zone_resource_record_sets
• aws_route53_hosted_zone_traffic_policy_instances

Columns

Example Queries

These SQL queries are sampled from CloudQuery policies and are compatible with PostgreSQL.

Unused Route 53 hosted zones

SELECT
  'Unused Route 53 hosted zones' AS title,
  account_id,
  arn AS resource_id,
  'fail' AS status
FROM
  aws_route53_hosted_zones
WHERE
  resource_record_set_count = 0;