turbot/aws_insights

Query: sns_topics_for_rds_db_cluster

Usage

powerpipe query aws_insights.query.sns_topics_for_rds_db_cluster

SQL

select
s.sns_topic_arn as topic_arn
from
aws_rds_db_event_subscription as s,
jsonb_array_elements_text(source_ids_list) as ids
join aws_rds_db_cluster as c
on ids = c.db_cluster_identifier
where
c.arn = $1
and c.account_id = split_part($1, ':', 5)
and c.region = split_part($1, ':', 4);