turbot/aws_insights

Query: redshift_clusters_for_sns_topic

Usage

powerpipe query aws_insights.query.redshift_clusters_for_sns_topic

SQL

select
c.arn as cluster_arn
from
aws_redshift_event_subscription as s,
jsonb_array_elements_text(source_ids_list) as ids
join aws_redshift_cluster as c on ids = c.cluster_identifier
where
s.sns_topic_arn = $1;