turbot/aws_insights

Query: kinesis_streams_for_cloudwatch_log_group

Usage

powerpipe query aws_insights.query.kinesis_streams_for_cloudwatch_log_group

SQL

select
s.stream_arn
from
aws_cloudwatch_log_group as g,
aws_cloudwatch_log_subscription_filter as f,
aws_kinesis_stream as s
where
f.region = g.region
and g.name = f.log_group_name
and s.stream_arn = f.destination_arn
and g.arn = $1;