turbot/aws_insights

Query: logging_source_s3_buckets_for_s3_bucket

Usage

powerpipe query aws_insights.query.logging_source_s3_buckets_for_s3_bucket

Steampipe Tables

SQL

select
lb.arn as bucket_arn
from
aws_s3_bucket as lb,
aws_s3_bucket as b
where
b.arn = $1
and lb.logging ->> 'TargetBucket' = b.name;