ODBC Driver for Amazon S3

Build 23.0.8839

Buckets

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 本製品 uses the Amazon S3 API to process search criteria that refers to the Name column. The 本製品 processes other filters client side within the 本製品. 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 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

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839