steampipe plugin install awssteampipe plugin install aws

Table: aws_vpc_peering_connection

A VPC peering connection is a networking connection between two VPCs that enables you to route traffic between them using private IPv4 addresses or IPv6 addresses. Instances in either VPC can communicate with each other as if they are within the same network. You can create a VPC peering connection between your own VPCs, or with a VPC in another AWS account. The VPCs can be in different regions (also known as an inter-region VPC peering connection).

Examples

Basic Info

select
  id,
  accepter_owner_id,
  accepter_region,
  accepter_vpc_id,
  expiration_time,
  requester_owner_id,
  requester_region,
  requester_vpc_id
from
  aws_vpc_peering_connection;

List VPC peering connections by approval status

select
  id,
  accepter_vpc_id,
  requester_vpc_id,
  status_code,
  status_message
from
  aws_vpc_peering_connection
where
  status_code = 'pending-acceptance';

List requester VPC connection details

select
  id,
  requester_cidr_block,
  requester_owner_id,
  requester_region,
  requester_vpc_id,
  jsonb_pretty(requester_cidr_block_set) as requester_cidr_block_set,
  jsonb_pretty(requester_ipv6_cidr_block_set) as requester_ipv6_cidr_block_set,
  jsonb_pretty(requester_peering_options) as requester_peering_options
from
  aws_vpc_peering_connection;

List accepter VPC connection details

select
  id,
  accepter_cidr_block,
  accepter_owner_id,
  accepter_region,
  accepter_vpc_id,
  jsonb_pretty(accepter_cidr_block_set) as accepter_cidr_block_set,
  jsonb_pretty(accepter_ipv6_cidr_block_set) as accepter_ipv6_cidr_block_set,
  jsonb_pretty(accepter_peering_options) as accepter_peering_options
from
  aws_vpc_peering_connection;

List VPC peering connections by specific VPC peering connection IDs

select
  id,
  accepter_owner_id,
  accepter_region,
  accepter_vpc_id,
  expiration_time,
  requester_owner_id,
  requester_region,
  requester_vpc_id
from
  aws_vpc_peering_connection
where
  id in ('pcx-0a0403619dd2f3b24', 'pcx-048825e2c43ffd99e');

List VPC peering connections with tag details

select
  id,
  jsonb_pretty(tags) as tags,
  jsonb_pretty(tags_src) as tags_src
from
  aws_vpc_peering_connection;

select
  id,
  tags ->> 'Name' as name
from
  aws_vpc_peering_connection;

List VPC peering connections by specific tag's key

select
  id,
  jsonb_pretty(tags) as tags
from
  aws_vpc_peering_connection,
  jsonb_each(tags)
where
  key = 'turbot:TurbotCreatedPeeringConnection';

List VPC peering connections by specific tag's key & value

select
  id,
  jsonb_pretty(tags) as tags
from
  aws_vpc_peering_connection
where
  tags @> '{"Name": "vpc-0639e12347e5b6bfb <=> vpc-8e1234f5"}';

Control examples

.inspect aws_vpc_peering_connection

AWS VPC Peering Connection

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
accepter_cidr_block	cidr	The IPv4 CIDR block for the accepter VPC.
accepter_cidr_block_set	jsonb	Information about the IPv4 CIDR blocks for the accepter VPC.
accepter_ipv6_cidr_block_set	jsonb	The IPv6 CIDR block for the accepter VPC.
accepter_owner_id	text	The ID of the Amazon Web Services account that owns the accepter VPC.
accepter_peering_options	jsonb	Information about the VPC peering connection options for the accepter VPC.
accepter_region	text	The Region in which the accepter VPC is located.
accepter_vpc_id	text	The ID of the accepter VPC.
account_id	text	The AWS Account ID in which the resource is located.
expiration_time	timestamp with time zone	The time that an unaccepted VPC peering connection will expire.
id	text	The ID of the VPC peering connection.
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.
requester_cidr_block	cidr	The IPv4 CIDR block for the requester VPC.
requester_cidr_block_set	jsonb	Information about the IPv4 CIDR blocks for the requester VPC.
requester_ipv6_cidr_block_set	jsonb	The IPv6 CIDR block for the requester VPC.
requester_owner_id	text	The ID of the Amazon Web Services account that owns the requester VPC.
requester_peering_options	jsonb	Information about the VPC peering connection options for the requester VPC.
requester_region	text	The Region in which the requester VPC is located.
requester_vpc_id	text	The ID of the requester VPC.
status_code	text	The status of the VPC peering connection. Possible values include: 'pending-acceptance', 'failed', 'expired', 'provisioning', 'active', 'deleting', 'deleted' or 'rejected'.
status_message	text	A message that provides more information about the status, if applicable.
tags	jsonb	A map of tags for the resource.
tags_src	jsonb	The tags assigned to the resource.
title	text	Title of the resource.

turbot/aws