turbot/aws_insights

Query: cloudwatch_log_groups_for_vpc_flow_log

Usage

powerpipe query aws_insights.query.cloudwatch_log_groups_for_vpc_flow_log

SQL

select
g.arn as log_group_arn
from
aws_vpc_flow_log as f
left join aws_cloudwatch_log_group as g on f.log_group_name = g.name
and f.region = g.region
and f.account_id = g.account_id
where
f.log_destination_type = 'cloud-watch-logs'
and f.flow_log_id = $1;