ODBC Driver for Google Cloud Storage

Build 20.0.7746


Returns information about lifecycle of a specific bucket.

Table Specific Information


The {i 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 {i.

  • Bucket supports the '=,LIKE' comparisons.

For example, the following queries are processed server side:

SELECT * FROM BucketLifecycle WHERE Bucket = 'TestBucket'


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.
Bucket String Name of the bucket.

Copyright (c) 2021 CData Software, Inc. - All rights reserved.
Build 20.0.7746