Table: alicloud_vpc_vpn_customer_gateway - Query Alibaba Cloud VPN Customer Gateways using SQL

In Alibaba Cloud, a VPN customer gateway represents the on-premises gateway device used to establish secure VPN connections with a Virtual Private Cloud (VPC). It holds the public IP address and identification details of the customer's network endpoint.

Table Usage Guide

The alicloud_vpc_vpn_customer_gateway table helps network engineers and cloud administrators query detailed information about customer gateways configured for VPN connections in Alibaba Cloud. Use this table to retrieve attributes such as customer gateway ID, name, IP address, description, and creation time. This information is essential for setting up and maintaining site-to-site VPN tunnels, ensuring secure hybrid cloud connectivity.

Examples

Basic info

Explore the details of your VPN customer gateway in Alibaba Cloud's VPC service. This query can be used to understand when and why each gateway was created, aiding in resource management and auditing processes.

select
  name,
  customer_gateway_id,
  description,
  create_time
from
  alicloud_vpc_vpn_customer_gateway;

select
  name,
  customer_gateway_id,
  description,
  create_time
from
  alicloud_vpc_vpn_customer_gateway;

Get the IP address of each customer gateway

Explore which customer gateways are associated with specific IP addresses to better manage network connections and troubleshoot potential issues. This query is beneficial for maintaining secure and efficient connectivity within your virtual private cloud (VPC).

select
  name,
  customer_gateway_id,
  ip_address
from
  alicloud_vpc_vpn_customer_gateway;

select
  name,
  customer_gateway_id,
  ip_address
from
  alicloud_vpc_vpn_customer_gateway;

Schema for alicloud_vpc_vpn_customer_gateway

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
account_id	text	=, !=, ~~, ~~, !~~, !~~	The Alicloud Account ID in which the resource is located.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
asn	bigint		Specifies the ASN of the customer gateway.
create_time	timestamp with time zone		The time when the customer gateway was created.
customer_gateway_id	text	=	The ID of the customer gateway.
description	text		The description of the customer gateway.
ip_address	inet		The IP address of the customer gateway.
name	text		The name of the customer gateway.
region	text		The Alicloud region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.

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)" -- alicloud

You can pass the configuration to the command with the --config argument:

steampipe_export_alicloud --config '<your_config>' alicloud_vpc_vpn_customer_gateway