BucketLifecycle
Returns information about lifecycle of a specific bucket.
Table Specific Information
Select
The add-in will use the Google Cloud Storage API to process WHERE clause conditions built with the following column and operator. The rest of the filter is executed client side within the add-in.
- Bucket supports the '=,LIKE' comparisons.
For example, the following queries are processed server side:
SELECT * FROM BucketLifecycle WHERE Bucket = 'TestBucket'
Columns
| Name | Type | Description |
| ActionType | String | Type of the action. Currently, Delete and SetStorageClass are supported. |
| ActionStorageClass | String | The new storage class when action.type is SetStorageClass. See lifecycle actions for a table of supported storage class transitions. |
| Age | Integer | Age of an object (in days). This condition is satisfied when an object reaches the specified age. |
| CreatedBefore | Date | A date in RFC 3339 format with only the date part. |
| IsLive | Boolean | Relevant only for versioned objects. If the value is true, this condition matches the live version of objects; if the value is false, it matches noncurrent versions of objects. |
| MatchesStorageClass | String | Objects having any of the storage classes specified by this condition will be matched. Values include STANDARD, NEARLINE, COLDLINE, ARCHIVE, MULTI_REGIONAL, REGIONAL, and DURABLE_REDUCED_AVAILABILITY. |
| NumberOfNewerVersions | Integer | Relevant only for versioned objects. If the value is N, this condition is satisfied when there are at least N versions (including the live version) newer than this version of the object. |
| CustomTimeBefore | Date | A date in the RFC 3339 format YYYY-MM-DD. This condition is satisfied when the customTime metadata for the object is set to an earlier date than the date used in this lifecycle condition. |
| NoncurrentTimeBefore | Date | Relevant only for versioned objects. A date in the RFC 3339 format YYYY-MM-DD. This condition is satisfied for objects that became noncurrent on a date prior to the one specified in this condition. |
| DaysSinceNoncurrentTime | Integer | Relevant only for versioned objects. This condition is satisfied when an object has been noncurrent for more than the specified number of days. |
| DaysSinceCustomTime | Integer | Days since the date set in the customTime metadata for the object. This condition is satisfied when the current date and time is at least the specified number of days after the customTime. |
| Bucket | String | Name of the bucket. |