Query: sns_topics_for_eventbridge_rule

select
  (t ->> 'Arn') :: text as topic_arn
from
  aws_eventbridge_rule r,
  jsonb_array_elements(targets) t
where
  arn = $1
  and t ->> 'Arn' like '%sns%';