Objects
Returns information for objects inside a specific bucket.
Table Specific Information
Select
The adapter uses the S3 API to process search criteria that refers to the Object and Bucket columns. The adapter processes other filters client side within the adapter. For example, the following queries are processed server side.
SELECT * FROM Objects 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. In order to create new Objects in 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 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. |