Query: kms_keys_for_ecs_snapshot

select
  k.arn as key_arn
from
  alicloud_kms_key k
  left join alicloud_ecs_snapshot as s on k.key_id = s.kms_key_id
where
  s.arn = $1
  and s.account_id = split_part($1, ':', 5)
  and s.region = split_part($1, ':', 4)
  and k.arn is not null;