steampipe plugin install aws

Table: aws_route53_domain - Query AWS Route 53 Domains using SQL

The AWS Route 53 Domain service is a scalable and highly available domain name system (DNS) web service. It is designed to give developers and businesses an extremely reliable and cost-effective way to route end users to Internet applications by translating human readable names like www.example.com into the numeric IP addresses like 192.0.2.1 that computers use to connect to each other. Route 53 effectively connects user requests to infrastructure running in AWS, such as Amazon EC2 instances, ELB load balancers, or Amazon S3 buckets, and can also be used to route users to infrastructure outside of AWS.

Table Usage Guide

The aws_route53_domain table in Steampipe allows you to query detailed information about domain names registered with Route 53, a scalable Domain Name System (DNS) web service in AWS. This table provides you, as a DevOps engineer, with domain-specific details such as domain name, status, expiration date, and associated tags. You can utilize this table to retrieve details about domain names, including their registration, renewal, and transfer status, and also to verify the associated tags. The schema outlines various attributes of the domain, including the domain name, auto renew, transfer lock, expiry date, and associated tags.

Examples

Basic info

Determine the status of domain renewals in your AWS Route53 service to anticipate and manage upcoming expiration dates. This query is useful for maintaining domain continuity and avoiding unexpected service disruptions.

select
domain_name,
auto_renew,
expiration_date
from
aws_route53_domain;
select
domain_name,
auto_renew,
expiration_date
from
aws_route53_domain;

List domains with auto-renewal enabled

Discover the domains that have the auto-renewal feature enabled to understand the areas that may need attention for timely renewals, thus preventing any potential service disruptions. This can be particularly useful in managing domain registrations and ensuring continuity of web services.

select
domain_name,
auto_renew,
expiration_date
from
aws_route53_domain
where
auto_renew;
select
domain_name,
auto_renew,
expiration_date
from
aws_route53_domain
where
auto_renew = 1;

List domains with transfer lock enabled

Explore which domains have the transfer lock feature enabled, which is useful for maintaining domain security by preventing unauthorized transfers. This can be particularly beneficial for organizations looking to safeguard their domains from potential cyber threats or unauthorized changes.

select
domain_name,
expiration_date,
transfer_lock
from
aws_route53_domain
where
transfer_lock;
select
domain_name,
expiration_date,
transfer_lock
from
aws_route53_domain
where
transfer_lock = 1;

Schema for aws_route53_domain

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
abuse_contact_emailtextEmail address to contact to report incorrect contact information for a domain,to report that the domain is being used to send spam, to report that someone is cyber squatting on a domain name, or report some other type of abuse.
abuse_contact_phonetextPhone number for reporting abuse.
account_idtextThe AWS Account ID in which the resource is located.
admin_contactjsonbProvides details about the domain administrative contact.
admin_privacybooleanSpecifies whether contact information is concealed from WHOIS queries.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
arntextThe Amazon Resource Name (ARN) specifying the domain.
auto_renewbooleanIndicates whether the domain is automatically renewed upon expiration.
creation_datetimestamp with time zoneThe date when the domain was created as found in the response to a WHOIS query.
domain_nametext=The name of the domain.
expiration_datetimestamp with time zoneThe date when the registration for the domain is set to expire. The date and time is in Unix time format and Coordinated Universal time (UTC).
nameserversjsonbThe name of the domain.
partitiontextThe AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
regiontextThe AWS Region in which the resource is located.
registrant_contactjsonbProvides details about the domain registrant.
registrant_privacybooleanSpecifies whether contact information is concealed from WHOIS queries.
registrar_nametextName of the registrar of the domain as identified in the registry. Domains with a .com, .net, or .org TLD are registered by Amazon Registrar.
registrar_urltextWeb address of the registrar.
registry_domain_idtextReserved for future use.
resellertextReseller of the domain. Domains registered or transferred using Route 53 domains will have Amazon as the reseller.
status_listjsonbAn array of domain name status codes, also known as Extensible Provisioning Protocol (EPP) status codes.
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags assigned to the resource.
tech_contactjsonbProvides details about the domain technical contact.
tech_privacybooleanSpecifies whether contact information is concealed from WHOIS queries.
titletextTitle of the resource.
transfer_lockbooleanIndicates whether a domain is locked from unauthorized transfer to another party.
updated_datetimestamp with time zoneThe last updated date of the domain as found in the response to a WHOIS query.The date and time is in Unix time format and Coordinated Universal time (UTC).
who_is_servertextThe fully qualified name of the WHOIS server that can answer the WHOIS query for the domain.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_route53_domain