Query: compute_instance_group_attached_instances

select
  i.id :: text as "ID",
  i.name as "Name",
  i.creation_timestamp as "Create Time",
  i.cpu_platform as "CPU Platform",
  i.status as "Status"
from
  gcp_compute_instance_group g,
  jsonb_array_elements(instances) as ins,
  gcp_compute_instance i
where
  g.id = $1
  and i.self_link = ins ->> 'instance';