Provides detailed information about objects stored within a bucket, including metadata, size, and storage class.

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 add-in uses the Amazon S3 API to process search criteria that refer to the Object and Bucket columns. The add-in processes other filters client-side in the add-in. 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	The key (name) that uniquely identifies the object within the bucket.
Description	String	False	A descriptive label or metadata value associated with the object, if available.
LastModified	Datetime	False	The timestamp indicating when the object was last modified in Amazon S3.
OwnerId	String	False	The canonical user ID of the AWS account that owns the object.
OwnerDisplayName	String	False	The human-readable display name of the AWS account that owns the object.
Size	String	False	The size of the object in bytes, representing its total stored data.
Etag	String	False	The entity tag (ETag) generated by Amazon S3 to identify the specific version of the object, often used for caching or integrity checks.
Bucket [KEY]	String	False	The name of the S3 bucket where the object is stored.