ADO.NET Provider for Amazon S3

Build 23.0.8770


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.


The 本製品 uses the Amazon S3 API to process search criteria that refer to the Object and Bucket columns. The 本製品 processes other filters client-side in the 本製品. 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 queries are not supported to create new Objects. To create new Objects in Amazon S3, use the Stored Procedure UploadObject.


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'


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.

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