turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
gcp_audit_policygcp_bigquery_datasetgcp_bigquery_jobgcp_bigquery_tablegcp_bigtable_instancegcp_cloudfunctions_functiongcp_compute_addressgcp_compute_backend_bucketgcp_compute_backend_servicegcp_compute_diskgcp_compute_disk_metric_read_opsgcp_compute_disk_metric_read_ops_dailygcp_compute_disk_metric_read_ops_hourlygcp_compute_disk_metric_write_opsgcp_compute_disk_metric_write_ops_dailygcp_compute_disk_metric_write_ops_hourlygcp_compute_firewallgcp_compute_forwarding_rulegcp_compute_global_addressgcp_compute_global_forwarding_rulegcp_compute_imagegcp_compute_instancegcp_compute_instance_metric_cpu_utilizationgcp_compute_instance_metric_cpu_utilization_dailygcp_compute_instance_metric_cpu_utilization_hourlygcp_compute_instance_templategcp_compute_machine_typegcp_compute_networkgcp_compute_node_groupgcp_compute_node_templategcp_compute_project_metadatagcp_compute_regiongcp_compute_resource_policygcp_compute_routergcp_compute_snapshotgcp_compute_ssl_policygcp_compute_subnetworkgcp_compute_target_https_proxygcp_compute_target_poolgcp_compute_target_ssl_proxygcp_compute_target_vpn_gatewaygcp_compute_url_mapgcp_compute_vpn_tunnelgcp_compute_zonegcp_dns_managed_zonegcp_dns_policygcp_dns_record_setgcp_iam_policygcp_iam_rolegcp_kms_keygcp_kms_key_ringgcp_kubernetes_clustergcp_kubernetes_node_poolgcp_logging_bucketgcp_logging_exclusiongcp_logging_metricgcp_logging_sinkgcp_monitoring_alert_policygcp_monitoring_groupgcp_monitoring_notification_channelgcp_organizationgcp_projectgcp_project_organization_policygcp_project_servicegcp_pubsub_snapshotgcp_pubsub_subscriptiongcp_pubsub_topicgcp_service_accountgcp_service_account_keygcp_sql_backupgcp_sql_databasegcp_sql_database_instancegcp_sql_database_instance_metric_connectionsgcp_sql_database_instance_metric_connections_dailygcp_sql_database_instance_metric_connections_hourlygcp_sql_database_instance_metric_cpu_utilizationgcp_sql_database_instance_metric_cpu_utilization_dailygcp_sql_database_instance_metric_cpu_utilization_hourlygcp_storage_bucket

Table: gcp_compute_zone

Compute Engine resources are hosted in multiple locations worldwide. These locations are composed of regions and zones. Resources that live in a zone, such as virtual machine instances or zonal persistent disks, are referred to as zonal resources.

Examples

Compute zone basic info

select
name,
id,
region_name,
status
from
gcp_compute_zone;

Get the available cpu platforms in each zone

select
name,
available_cpu_platforms
from
gcp_compute_zone;

Get the zones which are down

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

.inspect gcp_compute_zone

GCP Compute Zone

NameTypeDescription
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.
nametextThe name of the zone.
projecttextThe 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.
statustextStatus of the zone, either UP or DOWN.
titletextTitle of the resource.