Table: aws_route53_vpc_association_authorization - Query AWS Route53 for other-account VPCs using SQL

Amazon Route 53 is a highly available and scalable Domain Name System (DNS) web service.

Table Usage Guide

The aws_route53_vpc_association_authorization table in Steampipe provides you with information VPCs in other AWS accounts that are authorized to be associated with a specified hosted_zone_id.

Examples

Basic info

Check which other-account VPCs are authorized

select
  hosted_zone_id,
  vpc_id,
  vpc_region
from
  aws_route53_vpc_association_authorization
where
  hosted_zone_id = 'Z3M3LMPEXAMPLE';

select
  hosted_zone_id,
  vpc_id,
  vpc_region
from
  aws_route53_vpc_association_authorization
where
  hosted_zone_id = 'Z3M3LMPEXAMPLE';

Sort VPCs descending by region name

select
  hosted_zone_id,
  vpc_id,
  vpc_region
from
  aws_route53_vpc_association_authorization
where
  hosted_zone_id = 'Z3M3LMPEXAMPLE'
order by
  vpc_region desc;

select
  hosted_zone_id,
  vpc_id,
  vpc_region
from
  aws_route53_vpc_association_authorization
where
  hosted_zone_id = 'Z3M3LMPEXAMPLE'
order by
  vpc_region desc;

Retrieve VPC Association Authorizations for available Hosted Zones

You can combine multiple tables to query or get fields such as the zone domain name (something the AWS API does not provide by default).

select
  auth.hosted_zone_id,
  z.name,
  auth.vpc_id,
  auth.vpc_region
from
  aws_route53_vpc_association_authorization auth
  inner join aws_route53_zone z on auth.hosted_zone_id = z.id
where
  z.name = 'mycooldomain.xyz';

select
  auth.hosted_zone_id,
  z.name,
  auth.vpc_id,
  auth.vpc_region
from
  aws_route53_vpc_association_authorization auth
  inner join aws_route53_zone z on auth.hosted_zone_id = z.id
where
  z.name = 'mycooldomain.xyz';

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_vpc_association_authorization