Table: gcp_compute_network - Query Google Cloud Platform Compute Networks using SQL

A Google Cloud Platform Compute Network is a virtual version of the traditional physical networks that exist within and between physical data centers. A network provides the communication path between your Compute Engine virtual machine (VM) instances. They are global resources, spanning all regions, and are used to define the network topology, such as subnetworks and network peering connections.

Table Usage Guide

The gcp_compute_network table provides insights into Compute Networks within Google Cloud Platform. As a network engineer or cloud architect, you can use this table to explore network-specific details, including its subnetworks, firewall rules, and routing configurations. This allows you to manage and optimize your network infrastructure effectively, ensuring secure and efficient communication paths within your Google Cloud environment.

Examples

List networks having auto create subnetworks feature disabled

Identify the networks that have the auto-create subnetworks feature turned off. This can be useful for assessing network configurations where manual subnet creation is preferred for more control over network segmentation.

select
  name,
  id,
  auto_create_subnetworks
from
  gcp_compute_network
where
  not auto_create_subnetworks;

select
  name,
  id,
  auto_create_subnetworks
from
  gcp_compute_network
where
  auto_create_subnetworks = 0;

List networks having routing_mode set to REGIONAL

Discover the segments that have their routing mode set to 'REGIONAL' within your network settings. This can be useful in understanding and managing network traffic flow within specific regions.

select
  name,
  id,
  routing_mode
from
  gcp_compute_network
where
  routing_mode = 'REGIONAL';

select
  name,
  id,
  routing_mode
from
  gcp_compute_network
where
  routing_mode = 'REGIONAL';

Subnets counts for each network

Explore which networks have the most subnets, allowing you to understand the distribution of subnets across your networks for better resource management and allocation.

select
  name,
  count(d) as num_subnets
from
  gcp_compute_network as i,
  jsonb_array_elements(subnetworks) as d
group by
  name;

select
  g.name,
  count(d.value) as num_subnets
from
  gcp_compute_network g,
  json_each(g.subnetworks) as d
group by
  g.name;

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

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

steampipe_export_gcp --config '<your_config>' gcp_compute_network