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

Table Specific Information

NOTE:This table retrieves Buckets for all regions regardless of the AWS Region property.

Select

The adapter uses the S3 API to process search criteria that refers to the Name column. The adapter processes other filters client side within the adapter. For example, the following queries are processed server side.

SELECT * FROM Buckets WHERE Bucket = 'TestBucket'

Insert

To insert a Bucket, specify the primary key of the Bucket in the INSERT query. For example, the following query inserts a bucket from S3:

INSERT INTO Buckets (Bucket) VALUES ('TestBucket')

Delete

To delete a Bucket, specify the primary key of the Bucket in the DELETE query. For example, the following query deletes a bucket from S3:

DELETE FROM Buckets WHERE Bucket = 'MyBucket'

Columns

Name	Type	ReadOnly	Description
Bucket [KEY]	String	False	The bucket's name.
CreationDate	Timestamp	False	The date the bucket was created.
OwnerId	String	False	The bucket owner's canonical user ID.
OwnerDisplayName	String	False	The bucket owner's display name.