turbot/aws_insights

Query: sns_topics_for_lambda_function

Usage

powerpipe query aws_insights.query.sns_topics_for_lambda_function

SQL

select
topic_arn as topic_arn
from
aws_sns_topic_subscription
where
protocol = 'lambda'
and endpoint = $1
and account_id = split_part($1, ':', 5)
and region = split_part($1, ':', 4);