turbot/aws_insights

Query: sns_topic_subscriptions_for_lambda_function

Usage

powerpipe query aws_insights.query.sns_topic_subscriptions_for_lambda_function

SQL

select
subscription_arn as subscription_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);