Provides detailed information about S3 buckets, which are top-level containers used to organize and store objects along with their associated metadata.

Table Specific Information

NOTE:This table retrieves Buckets for all regions regardless of the AWS Region property.

Select

The add-in uses the Amazon S3 API to process search criteria that refers to the Name column. The add-in processes other filters client side within the add-in. For example, the following queries are processed server side.

SELECT * FROM Buckets WHERE Bucket = 'TestBucket'

Insert

To insert a Bucket, specify the primary key of the Bucket in the INSERT query. For example, the following query inserts a bucket from Amazon S3:

INSERT INTO Buckets (Bucket) VALUES ('TestBucket')

Delete

To delete a Bucket, specify the primary key of the Bucket in the DELETE query. For example, the following query deletes a bucket from Amazon S3:

DELETE FROM Buckets WHERE Bucket = 'MyBucket'

Columns

Name	Type	ReadOnly	Description
Bucket [KEY]	String	False	The unique name assigned to the S3 bucket, which serves as the primary identifier for storing and accessing objects.
CreationDate	Timestamp	True	The timestamp indicating when the bucket was created in Amazon S3.
OwnerId	String	True	The canonical user ID of the AWS account that owns the bucket, used to uniquely identify the bucket owner.
OwnerDisplayName	String	True	The display name associated with the AWS account that owns the bucket, providing a human-readable identifier for the owner.