Query: cloudwatch_log_groups_for_eventbridge_rule

select
  (t ->> 'Arn') :: text || ':*' as cloudwatch_log_group_arn
from
  aws_eventbridge_rule r,
  jsonb_array_elements(targets) t
where
  r.arn = $1
  and t ->> 'Arn' like '%logs%';