Query: eventbridge_rule_targets

select
  target ->> 'Id' as "ID",
  target ->> 'Arn' as "ARN",
  target ->> 'Input' as "Input"
from
  aws_eventbridge_rule as c,
  jsonb_array_elements(c.targets) as target
where
  c.arn = $1
  and c.account_id = split_part($1, ':', 5)
  and c.region = split_part($1, ':', 4);