Query: compute_instance_public_access

select
  'Public Access' as label,
  case
    when d ->> 'natIP' is not null then 'Enabled'
    else 'Disabled'
  end as value,
  case
    when d ->> 'natIP' is not null then 'alert'
    else 'ok'
  end as type
from
  gcp_compute_instance,
  jsonb_array_elements(network_interfaces) nic,
  jsonb_array_elements(nic -> 'accessConfigs') d
where
  id = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);