steampipe plugin install awssteampipe plugin install aws

Table: aws_route53_resolver_endpoint

The AWS Route 53 Resolver endpoints in a Virtual Private Cloud (VPC) that is used for DNS management.

Examples

List all endpoints

select
  name,
  id,
  direction,
  ip_address_count status
from
  aws_route53_resolver_endpoint;

Get a specific endpoint

select
  name,
  id,
  direction,
  ip_address_count status
from
  aws_route53_resolver_endpoint
where
  id = 'rslvr-out-ebb7db0b7498463eb';

List unhealthy endpoints

select
  name,
  id,
  direction,
  status,
  status_message
from
  aws_route53_resolver_endpoint
where
  status = 'ACTION_NEEDED';

Get IP address details for each endpoint

select
  name,
  p ->> 'Ip' as ip,
  p ->> 'Status' as status,
  p ->> 'SubnetId' as subnet_id
from
  aws_route53_resolver_endpoint,
  jsonb_array_elements(ip_addresses) as p;

Control examples

.inspect aws_route53_resolver_endpoint

AWS Route53 Resolver Endpoint

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.
arn	text	The ARN (Amazon Resource Name) for the Resolver endpoint.
creation_time	text	The date and time that the endpoint was created, in Unix time format and Coordinated Universal Time (UTC).
creator_request_id	text	A unique string that identifies the request that created the Resolver endpoint.The CreatorRequestId allows failed requests to be retried without the risk of executing the operation twice.
direction	text	Indicates whether the Resolver endpoint allows inbound or outbound DNS queries.
host_vpc_id	text	The ID of the VPC that you want to create the Resolver endpoint in.
id	text	The ID of the Resolver endpoint.
ip_address_count	bigint	The number of IP addresses that the Resolver endpoint can use for DNS queries.
ip_addresses	jsonb	Information about the IP addresses in your VPC that DNS queries originate from (for outbound endpoints) or that you forward DNS queries to (for inbound endpoints).
modification_time	text	The date and time that the endpoint was last modified, in Unix time format and Coordinated Universal Time (UTC).
name	text	The name that you assigned to the Resolver endpoint when you submitted a CreateResolverEndpoint.
partition	text	The AWS partition in which the resource is located (aws, aws-cn, or aws-us-gov).
region	text	The AWS Region in which the resource is located.
security_group_ids	jsonb	The ID of one or more security groups that control access to this VPC.
status	text	A code that specifies the current status of the Resolver endpoint.
status_message	text	A detailed description of the status of the Resolver endpoint.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	A list of tags assigned to the Resolver endpoint.
title	text	Title of the resource.

turbot/aws

Table: aws_route53_resolver_endpoint

Examples

List all endpoints

Get a specific endpoint

List unhealthy endpoints

Get IP address details for each endpoint

Control examples

.inspect aws_route53_resolver_endpoint

Steampipe

Resources

Community