turbot/aws_insights

Query: eventbridge_rules_for_sqs_queue

Usage

powerpipe query aws_insights.query.eventbridge_rules_for_sqs_queue

Steampipe Tables

SQL

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