TDV Adapter for Amazon S3

Build 22.0.8462

Buckets

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

Table Specific Information

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

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 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.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462