Lists the objects stored in a bucket, including each object's key, size, last-modified time, and owner.

View-Specific Information

SELECT

The provider uses the Amazon S3 API to process filter criteria that reference the Object and Bucket columns, and processes all other filters client-side within the provider. 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'

To list objects across every bucket configured in the

Buckets

connection property in a single query, use the

AllObjects

view in the

Information

schema.

This view is read-only. To add an object to Amazon S3, use the UploadObject stored procedure; to remove an object, use the DeleteObject stored procedure.

Columns

Name	Type	Description
Object [KEY]	String	The key (name) that uniquely identifies the object within the bucket.
Description	String	A descriptive label or metadata value associated with the object, if available.
LastModified	Datetime	The timestamp indicating when the object was last modified in Amazon S3.
OwnerId	String	The canonical user ID of the AWS account that owns the object.
OwnerDisplayName	String	The human-readable display name of the AWS account that owns the object.
Size	Long	The size of the object in bytes, representing its total stored data.
Etag	String	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	The name of the S3 bucket where the object is stored.