Query: List all objects in a bucket which are set to be retained for more than 1 year from now

Description

Discover the objects within a specific storage area that are scheduled to be kept for over a year from the current date. This query can be useful in understanding long-term data retention policies and identifying potential areas for storage optimization.

Query

Tables used in this query:

• aws_s3_object

SQL