Query: sns_topics_for_kms_key

select
  t.topic_arn as topic_arn
from
  aws_sns_topic as t
  left join aws_kms_key as k on k.id = split_part(t.kms_master_key_id, '/', 2)
where
  k.arn = $1
  and k.region = t.region
  and k.account_id = t.account_id;