turbot/aws_insights

Query: s3_buckets_for_redshift_cluster

Usage

powerpipe query aws_insights.query.s3_buckets_for_redshift_cluster

SQL

select
b.arn as bucket_arn
from
aws_redshift_cluster as c,
aws_s3_bucket as b
where
b.name = c.logging_status ->> 'BucketName'
and c.arn = $1;