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;