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

Table Specific Information

Select

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

SELECT * FROM Buckets

SELECT * FROM Buckets WHERE Name = '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 Amazon 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 Amazon S3:

DELETE FROM Buckets WHERE Bucket = 'MyBucket'

Columns