turbot/aws_insights

Query: s3_bucket_lifecycle_policy

Usage

powerpipe query aws_insights.query.s3_bucket_lifecycle_policy

Steampipe Tables

SQL

select
r ->> 'ID' as "ID",
r ->> 'AbortIncompleteMultipartUpload' as "Abort Incomplete Multipart Upload",
r ->> 'Expiration' as "Expiration",
r ->> 'Filter' as "Filter",
r ->> 'NoncurrentVersionExpiration' as "Non-current Version Expiration",
r ->> 'Prefix' as "Prefix",
r ->> 'Status' as "Status",
r ->> 'Transitions' as "Transitions"
from
aws_s3_bucket,
jsonb_array_elements(lifecycle_rules) as r
where
arn = $1
order by
r ->> 'ID';

Dashboards

The query is used in the dashboards: