Query: snapshot_source_blockstorage_volume

select
  v.urn as "URN",
  v.name as "Name",
  v.id as "ID",
  v.size_gigabytes as "Size (GB)"
from
  digitalocean_volume as v,
  digitalocean_snapshot as s
where
  s.resource_id = v.id
  and s.resource_type = 'volume'
  and s.id = $1;