steampipe plugin install aws

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
account_idtext=, !=, ~~, ~~*, !~~, !~~*The AWS Account ID in which the resource is located.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
bgp_asntext=The customer gateway's Border Gateway Protocol (BGP) Autonomous System Number (ASN).
certificate_arntextThe Amazon Resource Name (ARN) for the customer gateway certificate.
customer_gateway_idtext=The ID of the customer gateway.
device_nametextThe name of customer gateway device.
ip_addressinet=The Internet-routable IP address of the customer gateway's outside interface.
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.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statetext=The current state of the customer gateway (pending | available | deleting | deleted).
tagsjsonbA map of tags for the resource.
tags_srcjsonbA list of tags that are attached to customer gateway.
titletextTitle of the resource.
typetext=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