steampipe plugin install gcp

Table: gcp_compute_zone - Query Google Cloud Compute Engine Zones using SQL

Google Cloud Compute Engine Zones are geographical locations where Google Cloud resources are deployed and managed. Each zone is a deployment area within a region and is designed to be isolated from failures in other zones. Zones are ideal for deploying high availability applications and for distributing resources to provide disaster recovery.

Table Usage Guide

The gcp_compute_zone table provides insights into the zones within Google Cloud Compute Engine. As a Cloud Engineer, you can explore zone-specific details through this table, including the zone's status, region, and available CPU platforms. Utilize it to manage resource allocation and distribution, and to plan for disaster recovery and high availability applications.

Examples

Compute zone basic info

Explore which zones within your Google Cloud Platform's compute engine are active and where they are located. This is useful for understanding the distribution and status of your compute resources.

select
name,
id,
region_name,
status
from
gcp_compute_zone;
select
name,
id,
region_name,
status
from
gcp_compute_zone;

Get the available cpu platforms in each zone

Determine the areas in which different CPU platforms are available in each zone to optimize resource allocation and performance.

select
name,
available_cpu_platforms
from
gcp_compute_zone;
select
name,
available_cpu_platforms
from
gcp_compute_zone;

Get the zones which are down

Explore which zones in your GCP Compute environment are currently down. This is useful for quickly identifying areas of your infrastructure that may be experiencing issues.

select
name,
id,
region_name,
status
from
gcp_compute_zone
where
status = 'DOWN';
select
name,
id,
region_name,
status
from
gcp_compute_zone
where
status = 'DOWN';

Schema for gcp_compute_zone

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
available_cpu_platformsjsonbAvailable cpu/platform selections for the zone.
descriptiontextTextual description of the resource.
idtextThe unique identifier for the zone.
kindtextType of the resource. Always compute#zone for zones.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametext!=, =The name of the zone.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
regiontextFull URL reference to the region which hosts the zone.
region_nametextRegion name which hosts the zone.
self_linktextServer-defined URL for the zone.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustext!=, =Status of the zone, either UP or DOWN.
titletextTitle 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)" -- gcp

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

steampipe_export_gcp --config '<your_config>' gcp_compute_zone