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_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_region

Compute Engine resources are hosted in multiple locations worldwide. These locations are composed of regions and zones. A region is a specific geographical location where users can host their resources.

Examples

List of compute regions which are down

select
name,
id,
status
from
gcp_compute_region
where
status = 'DOWN';

Get the quota info for a region (us-west1)

select
name,
q -> 'metric' as quota_metric,
q -> 'limit' as quota_limit
from
gcp_compute_region,
jsonb_array_elements(quotas) as q
where
name = 'us-west1'
order by
quota_metric;

Get the available zone info of each region

select
name,
zone_names
from
gcp_compute_region;

Count the available zone in each region

select
name,
jsonb_array_length(zone_names) as zone_count
from
gcp_compute_region;

.inspect gcp_compute_region

GCP Compute Region

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
descriptiontextTextual description of the resource.
idtextThe unique identifier for the region.
kindtextType of the resource. Always compute#region for regions.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
nametextThe name of the region.
projecttextThe GCP Project in which the resource is located.
quotasjsonbQuotas assigned to this region.
self_linktextServer-defined URL for the region.
statustextStatus of the region, either UP or DOWN.
titletextTitle of the resource.
zone_namesjsonbA list of zones available in this region, in the form of zone_id.
zonesjsonbA list of zones available in this region, in the form of resource URLs.