Query: compute_instance_attached_disks

select
  d ->> 'deviceName' as "Device Name",
  d ->> 'diskSizeGb' as "Disk Size (GB)",
  d ->> 'interface' as "Interface",
  d ->> 'mode' as "Mode",
  d ->> 'boot' as "Boot",
  d ->> 'autoDelete' as "Auto-Delete"
from
  gcp_compute_instance,
  jsonb_array_elements(disks) as d
where
  id = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);