turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
On This Page
Get Involved

Table: gcp_compute_target_vpn_gateway

A virtual private network lets you securely connect your Google Compute Engine resources to your own private network.

Target VPN gateway basic info

select
name,
id,
self_link,
kind
from
gcp_compute_target_vpn_gateway;

List of all tunnels connected with the gateway

select
gateway.name as vpn_gateway_name,
tunnel.peer_ip,
tunnel.name as tunnel_name
from
gcp_compute_target_vpn_gateway as gateway,
jsonb_array_elements_text(tunnels) as t
join gcp_compute_vpn_tunnel as tunnel
on t = tunnel.self_link;

.inspect gcp_compute_target_vpn_gateway

GCP Compute Target VPN Gateway

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
creation_timestamptimestamp without time zoneThe creation timestamp of the resource.
descriptiontextA user-specified, human-readable description of the target vpn gateway.
forwarding_rulesjsonbA list of URLs to the ForwardingRule resources.
idbigintThe unique identifier for the resource.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextA friendly name that identifies the resource.
networktextThe URL of the network to which this VPN gateway is attached.
projecttextThe GCP Project in which the resource is located.
regiontextThe URL of the region where the target VPN gateway resides.
self_linktextThe server-defined URL for the resource.
statustextSpecifies the status of the VPN gateway.
titletextTitle of the resource.
tunnelsjsonbA list of URLs to VpnTunnel resources.