steampipe plugin install awssteampipe plugin install aws

Table: aws_route53_record

A Route 53 record contains authoritative DNS information for a specified DNS name. DNS records are most commonly used to map a name to an IP Address

You must specify a single zone_id in a where or join clause in order to use this table.

We recommend specifying the name and type columns when querying zones with a large number of records to reduce the query time.

Examples

Basic info

select
  name,
  type,
  records,
  alias_target
from
  aws_route53_record
where
  zone_id = 'Z09145482OD83AIAO253B';

List all test.com records in a zone

select
  name,
  type,
  record
from
  aws_route53_record,
  jsonb_array_elements_text(records) as record
where
  zone_id = 'Z09145482OD83AIAO253B'
  and name = 'test.com.';

List all NS records in a zone

select
  name,
  type,
  record
from
  aws_route53_record,
  jsonb_array_elements_text(records) as record
where
  zone_id = 'Z09145482OD83AIAO253B'
  and type = 'NS';

Get test.com NS record in a zone

select
  name,
  type,
  record
from
  aws_route53_record,
  jsonb_array_elements_text(records) as record
where
  zone_id = 'Z09145482OD83AIAO253B'
  and name = 'test.com.'
  and type = 'NS';

Count records by type

select
  type,
  count(*)
from
  aws_route53_record
where
  zone_id = 'Z09145482OD83AIAO253B'
group by
  type
order by
  count desc;

List geo-location routing information

select
  name,
  type,
  records,
  alias_target,
  geo_location ->> 'ContinentCode' as continent,
  geo_location ->> 'CountryCode' as country,
  geo_location ->> 'SubdivisionCode' as subdivision
from
  aws_route53_record
where
  zone_id = 'Z09145482OD83AIAO253B'
  and geo_location is not null
order by
  name;

Count of records by name and type

select
  name,
  type,
  count(*)
from
  aws_route53_record
  left join jsonb_array_elements_text(records) as record on true
where
  zone_id = 'Z09145482OD83AIAO253B'
group by
  name,
  type;

List all records in all zones

select
  r.name,
  r.type,
  r.records,
  r.alias_target
from
  aws_route53_zone as z,
  aws_route53_record as r
where
  r.zone_id = z.id;

Control examples

.inspect aws_route53_record

AWS Route53 Record

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
account_id	text	The AWS Account ID in which the resource is located.
akas	jsonb	Array of globally unique identifier strings (also known as) for the resource.
alias_target	jsonb	Alias resource record sets only: Information about the AWS resource, such as a CloudFront distribution or an Amazon S3 bucket, that you want to route traffic to.
failover	text	Failover resource record sets only: To configure failover, you add the Failover element to two resource record sets. For one resource record set, you specify PRIMARY as the value for Failover; for the other resource record set, you specify SECONDARY. In addition, you include the HealthCheckId element and specify the health check that you want Amazon Route 53 to perform for each resource record set.
geo_location	jsonb	Geolocation resource record sets only: A complex type that lets you control how Amazon Route 53 responds to DNS queries based on the geographic origin of the query. For example, if you want all queries from Africa to be routed to a web server with an IP address of 192.0.2.111, create a resource record set with a Type of A and a ContinentCode of AF.
health_check_id	text	The health check the record should be associated with.
latency_region	text	An AWS region from which to measure latency
multi_value_answer	boolean	Multivalue answer resource record sets only: To route traffic approximately randomly to multiple resources, such as web servers, create one multivalue answer record for each resource and specify true for MultiValueAnswer.
name	text	The name of the record.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
records	jsonb	If the health check or hosted zone was created by another service, an optional description that can be provided by the other service.
region	text	The AWS Region in which the resource is located.
set_identifier	text	Unique identifier to differentiate records with routing policies from one another.
title	text	Title of the resource.
traffic_policy_instance_id	text	The ID of the traffic policy instance that Route 53 created this resource record set for.
ttl	text	The resource record cache time to live (TTL), in seconds.
type	text	The record type. Valid values are A, AAAA, CAA, CNAME, MX, NAPTR, NS, PTR, SOA, SPF, SRV and TXT.
weight	bigint	Weighted resource record sets only: Among resource record sets that have the same combination of DNS name and type, a value that determines the proportion of DNS queries that Amazon Route 53 responds to using the current resource record set. Route 53 calculates the sum of the weights for the resource record sets that have the same combination of DNS name and type. Route 53 then responds to queries based on the ratio of a resource's weight to the total.
zone_id	text	The ID of the hosted zone to contain this record.

turbot/aws