Query: lambda_functions_for_eventbridge_rule

select
  (t ->> 'Arn')::text as function_arn
from
  aws_eventbridge_rule r,
  jsonb_array_elements(targets) t
where
  r.arn = $1
  and r.account_id = split_part($1, ':', 5)
  and r.region = split_part($1, ':', 4)
  and t ->> 'Arn' like '%lambda%';