turbot/aws_insights

Query: sns_topics_for_elasticache_cluster_node

Usage

powerpipe query aws_insights.query.sns_topics_for_elasticache_cluster_node

Steampipe Tables

SQL

select
notification_configuration ->> 'TopicArn' as sns_topic_arn
from
aws_elasticache_cluster
where
arn = $1
and notification_configuration ->> 'TopicArn' is not null
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);