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_network

A Virtual Private Cloud (VPC) network is a virtual version of a physical network, implemented inside of Google's production network.

Examples

List networks having auto create subnetworks feature disabled

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

List networks having routing_mode set to REGIONAL

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

Subnets counts for each network

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

.inspect gcp_compute_network

GCP Compute Network

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
auto_create_subnetworksbooleanWhen set to true, the VPC network is created in auto mode. When set to false, the VPC network is created in custom mode.
creation_timestamptimestamp without time zoneCreation timestamp in RFC3339 text format.
descriptiontextAn optional description of this resource. Provide this field when you create the resource.
gateway_ipv4inetThe gateway address for default routing out of the network, selected by GCP
iddouble precisionThe unique identifier for the resource. This identifier is defined by the server.
ipv4_rangecidrThe range of internal addresses that are legal on this network. Deprecated in favor of subnet mode networks. This range is a CIDR specification, for example: 192.168.0.0/16. Provided by the client when the network is created.
kindtextType of the resource. Always compute#network for networks.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
mtubigintMaximum Transmission Unit in bytes. The minimum value for this field is 1460 and the maximum value is 1500 bytes.
nametextName of the resource. Provided by the client when the resource is created.
peeringsjsonbA list of network peerings for the resource. NetworkPeering: A network peering attached to a network resource. The message includes the peering name, peer network, peering state, and a flag indicating whether Google Compute Engine should automatically create routes for the peering
projecttextThe GCP Project in which the resource is located.
routing_modetextThe network-wide routing mode to use. If set to REGIONAL, this network's Cloud Routers will only advertise routes with subnets of this network in the same region as the router. If set to GLOBAL, this network's Cloud Routers will advertise routes with all subnets of this network, across regions. Possible values: "GLOBAL" "REGIONAL"
self_linktextServer-defined URL for the resource.
subnetworksjsonbServer-defined fully-qualified URLs for all subnetworks in this VPC network.
titletextTitle of the resource.