Query: compute_network_subnet

select
  s.name as "Name",
  s.id::text as "ID",
  s.creation_timestamp as "Creation Time",
  s.enable_flow_logs as "Enable Flow Logs",
  s.log_config_enable as "Log Config Enabled",
  s.gateway_address as "Gateway Address",
  s.ip_cidr_range as "IPv4 CIDR Range",
  s.ipv6_cidr_range as "IPv6 CIDR Range",
  s.private_ip_google_access as "Private IPv4 Google Access",
  s.private_ipv6_google_access as "Private IPv6 Google Access"
from
  gcp_compute_subnetwork s,
  gcp_compute_network n
where
  s.network_name = n.name
  and s.project = n.project
  and n.id = (split_part($1, '/', 1))::bigint
  and n.project = split_part($1, '/', 2);