Query: snapshot_source_droplet

select
  d.urn as "URN",
  d.name as "Name",
  d.id as "ID",
  d.status as "Status"
from
  digitalocean_droplet as d,
  jsonb_array_elements(snapshot_ids) as sid,
  digitalocean_snapshot as s
where
  s.id = sid::text
  and s.id = $1;