turbot/aws_insights

Query: s3_buckets_for_vpc_flow_log

Usage

powerpipe query aws_insights.query.s3_buckets_for_vpc_flow_log

SQL

select
distinct s.arn as bucket_arn
from
aws_vpc_flow_log as f,
aws_s3_bucket as s
where
f.bucket_name = s.name
and f.log_destination_type = 's3'
and f.flow_log_id = $1;