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 r.account_id = split_part($1, ':', 5)
  and r.region = split_part($1, ':', 4)
  and t ->> 'Arn' like '%sns%';