BucketsLifecycle
Shows lifecycle rules for a bucket, which automate object transitions between storage classes or schedule deletions to optimize data retention.
Table Specific Information
Select
The driver uses the Amazon S3 API to process search criteria that refers to the Bucket column. The driver processes other filters client side within the driver. For example, the following query is processed server side.
SELECT * FROM BucketsLifecycle WHERE Bucket = 'TestBucket'
Columns
| Name | Type | Description |
| Id [KEY] | String | A unique identifier for the lifecycle rule within the bucket configuration. |
| Filter | String | Defines filters, such as prefixes or tags, that determine the subset of objects the lifecycle rule applies to. |
| Status | String | Indicates whether the lifecycle rule is enabled and actively applied by Amazon S3 or disabled and ignored. |
| Transition | Long | Specifies the number of days after object creation when S3 should automatically transition objects to a different storage class, such as STANDARD_IA, ONEZONE_IA, or GLACIER. |
| Storage | String | Identifies the target S3 storage class where objects should be transitioned, as defined by the rule. |
| Expiration | Long | Specifies the number of days after object creation when Amazon S3 should permanently delete the objects. |
| Bucket | String | The name of the S3 bucket associated with this lifecycle configuration. |