Returns information for objects inside a specific bucket.

Table Specific Information

NOTE: The driver automatically resolves the region if the AWS Region is set to its default value. If you change the default, use Buckets specific to the new region.

Select

The driver uses the Amazon S3 API to process search criteria that refer to the Object and Bucket columns. The driver processes other filters client-side in the driver. For example, the following queries are processed server-side.

SELECT * FROM Objects WHERE Object = 'TestObject'

SELECT * FROM Objects WHERE Bucket = 'TestBucket'

SELECT * FROM Objects WHERE Object = 'TestObject' AND Bucket = 'TestBucket'

Insert

INSERT queries are not supported to create new Objects. To create new Objects in Amazon S3, use the Stored Procedure UploadObject.

Delete

To delete an Object, specify the primary keys of the Object in the DELETE query. For example, the following query deletes an object from Amazon S3:

DELETE FROM Objects WHERE Object = 'MyObject' AND Bucket = 'MyBucket'

Columns

Name	Type	ReadOnly	Description
Object [KEY]	String	False	Objects's name.
Description	String	False	Object's description.
LastModified	Datetime	False	Date the object was last modified.
OwnerId	String	False	Objects owner's canonical user ID.
OwnerDisplayName	String	False	Objects owner's display name.
Size	String	False	Objects size.
Etag	String	False	Objects Etag.
Bucket [KEY]	String	False	Bucket in which the object is located.