JDBC Driver for Google Cloud Storage

Build 22.0.8462

BucketLifecycle

Returns information about lifecycle of a specific bucket.

Table Specific Information

Select

The driver 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 driver.

  • 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462