turbot/aws_insights

Query: rds_db_instances_for_sns_topic

Usage

powerpipe query aws_insights.query.rds_db_instances_for_sns_topic

SQL

select
i.arn as db_instance_arn
from
aws_rds_db_event_subscription as s,
jsonb_array_elements_text(source_ids_list) as ids
join aws_rds_db_instance as i on ids = i.db_instance_identifier
where
s.sns_topic_arn = $1;