Query: source_ecs_snapshots_for_ecs_disk

select
  s.arn as snapshot_arn
from
  alicloud_ecs_snapshot s
  left join alicloud_ecs_disk as d on s.snapshot_id = d.source_snapshot_id
where
  d.account_id = split_part($1, ':', 5)
  and d.region = split_part($1, ':', 4)
  and d.arn = $1
  and s.arn is not null;