Excel Add-In for Amazon S3

Build 25.0.9434

BucketsAnalytics

Retrieves bucket analytics configurations, which define storage class analysis and data usage patterns for optimizing storage costs.

Table Specific Information

Select

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

SELECT * FROM BucketsAnalytics WHERE Bucket = 'TestBucket'

Columns

Name Type Description
Id [KEY] String A unique identifier for the analytics configuration, used to distinguish it from other configurations in the same bucket.
FilterPrefix String Defines the key name prefix that objects must match to be included in the analytics results, allowing filtering by object path.
OutputSchemaVersion String Indicates the schema version used when exporting analytics results. This is currently required to be V_1.
DestinationBucket String The Amazon Resource Name (ARN) of the S3 bucket where the analytics results are delivered.
DestinationFormat String Specifies the file format of the analytics output, such as CSV, for easier analysis and reporting.
DestinationPrefix String A key prefix that is added to all exported analytics result files stored in the destination bucket.
Bucket String The name of the source S3 bucket for which the analytics configuration is defined.

Copyright (c) 2025 CData Software, Inc. - All rights reserved.
Build 25.0.9434