Table: aws_vpc_customer_gateway - Query AWS VPC Customer Gateway using SQL

The AWS VPC Customer Gateway is a component of Amazon Virtual Private Cloud (Amazon VPC). It represents a physical device or software application in your remote network with which you create a Site-to-Site VPN connection. The customer gateway provides the information to AWS about your customer gateway device for the Site-to-Site VPN connection.

Table Usage Guide

The aws_vpc_customer_gateway table in Steampipe provides you with information about each Customer Gateway in a Virtual Private Cloud (VPC). This table allows you as a network administrator, security analyst, or DevOps engineer to query gateway-specific details, including its type, state, and associated metadata. You can utilize this table to gather insights on gateways, such as the type of routing (static or dynamic) it supports, its BGP ASN, and more. The schema outlines the various attributes of the Customer Gateway for you, including the gateway ID, creation time, IP address, and associated tags.

Examples

Customer gateway basic detail

Explore the basic details of your customer gateways in your AWS VPC to understand their types, states, and other attributes. This can help in managing your network resources and ensuring the proper functioning of your VPC.

select
  customer_gateway_id,
  type,
  state,
  bgp_asn,
  certificate_arn,
  device_name,
  ip_address
from
  aws_vpc_customer_gateway;

select
  customer_gateway_id,
  type,
  state,
  bgp_asn,
  certificate_arn,
  device_name,
  ip_address
from
  aws_vpc_customer_gateway;

Count of customer gateways by certificate_arn

Analyze the distribution of customer gateways in your AWS Virtual Private Cloud (VPC) based on their types. This can be useful for understanding your network infrastructure and identifying potential areas for optimization or redundancy reduction.

select
  type,
  count(customer_gateway_id) as customer_gateway_id_count
from
  aws_vpc_customer_gateway
group by
  type;

select
  type,
  count(customer_gateway_id) as customer_gateway_id_count
from
  aws_vpc_customer_gateway
group by
  type;

Schema for aws_vpc_customer_gateway

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
bgp_asn	text	=	The customer gateway's Border Gateway Protocol (BGP) Autonomous System Number (ASN).
certificate_arn	text		The Amazon Resource Name (ARN) for the customer gateway certificate.
customer_gateway_id	text	=	The ID of the customer gateway.
device_name	text		The name of customer gateway device.
ip_address	inet	=	The Internet-routable IP address of the customer gateway's outside interface.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
state	text	=	The current state of the customer gateway (pending \| available \| deleting \| deleted).
tags	jsonb		A map of tags for the resource.
tags_src	jsonb		A list of tags that are attached to customer gateway.
title	text		Title of the resource.
type	text	=	The type of VPN connection the customer gateway supports (ipsec.1).

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_vpc_customer_gateway