ODBC Driver for Google Cloud Storage

Build 20.0.7746

Buckets

Returns information for buckets. Buckets are used to store objects, which consist of data and its metadata.

Table Specific Information

Select

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.

  • Name supports the '=,LIKE' comparisons.

For example, the following queries are processed server side:

SELECT * FROM Buckets WHERE Name = 'TestBucket'

Columns

Name Type Description
Id [KEY] String The ID of the bucket. For buckets, the id and name properties are the same.
Name String The name of the bucket.
ProjectNumber String The project number of the project the bucket belongs to.
MetaGeneration String The metadata generation of this bucket.
Location String The location of the bucket. Object data for objects in the bucket resides in physical storage within this region.
StorageClass String The bucket's default storage class, used whenever no storageClass is specified for a newly-created object.
ETag String HTTP 1.1 Entity tag for the bucket.
DefaultEventBasedHold Boolean Whether or not to automatically apply an eventBasedHold to new objects added to the bucket.
TimeCreated Datetime The creation time of the bucket in RFC 3339 format.
Updated Datetime The modification time of the bucket in RFC 3339 format.
BucketPolicyOnlyEnabled Boolean Whether or not the bucket uses uniform bucket-level access. If set, access checks only use bucket-level IAM policies or above.
UniformBucketLevelAccessEnabled String Whether or not the bucket uses uniform bucket-level access. If set, access checks only use bucket-level IAM policies or above.
LocationType String The type of location that the bucket resides in, as determined by the location property.
RetentionPolicyPeriod String The period of time, in seconds, that objects in the bucket must be retained and cannot be deleted, overwritten, or made noncurrent. The value must be greater than 0 seconds and less than 3,155,760,000 seconds.
RetentionPolicyEffectiveTime Datetime The time from which the retentionPolicy was effective, in RFC 3339 format.
RetentionPolicyIsLocked Boolean Whether or not the retentionPolicy is locked. If true, the retentionPolicy cannot be removed and the retention period cannot be reduced.
EncryptionDefaultKmsKeyName String A Cloud KMS key that will be used to encrypt objects inserted into this bucket, if no encryption method is specified.
OwnerEntity String The entity, in the form project-owner-projectId.
OwnerEntityId String The ID for the entity.
WebsiteMainPageSuffix String If the requested object path is missing, the service will ensure the path has a trailing '/', append this suffix, and attempt to retrieve the resulting object. This allows the creation of index.html objects to represent directory pages.
WebsiteNotFoundPage String If the requested object path is missing, and any mainPageSuffix object is missing, if applicable, the service will return the named object from this bucket as the content for a 404 Not Found result.
LogBucket String The destination bucket where the current bucket's logs should be placed.
LogObjectPrefix String A prefix for log object names. The default prefix is the bucket name.
VersioningEnabled Boolean While set to true, versioning is fully enabled for this bucket.
BillingRequesterPays Boolean When set to true, Requester Pays is enabled for this bucket.

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