Query: Get the archival age in days before deletion for each vault

Description

This query is used to identify the number of days before each AWS Glacier vault is scheduled for deletion. This helps in managing data lifecycle and ensuring timely archival or deletion of data to optimize storage costs.

Query

Tables used in this query:

• aws_glacier_vault

SQL