Buckets
Returns information for buckets. Buckets are used to store objects, which consist of data and its metadata.
Table Specific Information
Select
The connector 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 connector.
- 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. |