Query: source_ebs_snapshots_for_ebs_volume

select
  v.snapshot_id
from
  aws_ebs_volume as v
where
  v.arn = $1
  and v.account_id = split_part($1, ':', 5)
  and v.region = split_part($1, ':', 4);