Query: kms_keys_for_redshift_snapshot

select
  kms_key_id as key_arn
from
  aws_redshift_snapshot
where
  kms_key_id is not null
  and akas :: text = $1;