Query: compute_instance_network_interfaces

select
  nic ->> 'name' as "Name",
  nic ->> 'networkIP' as "Internal IP",
  nic ->> 'stackType' as "Stack Type",
  ac ->> 'natIP' as "External IP",
  ac ->> 'networkTier' as "Network Tier",
  can_ip_forward as "IP Forwarding"
from
  gcp_compute_instance,
  jsonb_array_elements(network_interfaces) as nic,
  jsonb_array_elements(nic -> 'accessConfigs') ac
where
  id = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);