Skip to content
AWS for Query.Farm

aws.s3.list_bucket_intelligent_tiering_configurations

Example SQL Queries

SELECT * FROM
aws.s3.list_bucket_intelligent_tiering_configurations
WHERE
"bucket" = 'VALUE';

Description

This operation is not supported by directory buckets.

Lists the S3 Intelligent-Tiering configuration from the specified bucket.

The S3 Intelligent-Tiering storage class is designed to optimize storage costs by automatically moving data to the most cost-effective storage access tier, without performance impact or operational overhead. S3 Intelligent-Tiering delivers automatic cost savings in three low latency and high throughput access tiers. To get the lowest storage cost on data that can be accessed in minutes to hours, you can choose to activate additional archiving capabilities.

The S3 Intelligent-Tiering storage class is the ideal storage class for data with unknown, changing, or unpredictable access patterns, independent of object size or retention period. If the size of an object is less than 128 KB, it is not monitored and not eligible for auto-tiering. Smaller objects can be stored, but they are always charged at the Frequent Access tier rates in the S3 Intelligent-Tiering storage class.

For more information, see Storage class for automatically optimizing frequently and infrequently accessed objects.

Operations related to ListBucketIntelligentTieringConfigurations include:

Table Definition

Column NameColumn Data Type
bucket Required Input Column

The name of the Amazon S3 bucket whose configuration you want to modify or retrieve.

VARCHAR
continuation_token Input Column

The ContinuationToken that represents a placeholder from where this request should begin.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

intelligent_tiering_configuration_list

The list of S3 Intelligent-Tiering configurations for a bucket.

STRUCT(
    "id" VARCHAR,
    "filter" STRUCT(
        "prefix" VARCHAR,
        "tag" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        ),
        "and" STRUCT(
            "prefix" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )
    ),
    "status" VARCHAR,
    "tierings" STRUCT(
        "days" BIGINT,
        "access_tier" VARCHAR
    )[]
)[]
Show child fields
intelligent_tiering_configuration_list[]
Show child fields
intelligent_tiering_configuration_list[].filter

Specifies a bucket filter. The configuration only includes objects that meet the filter's criteria.

Show child fields
intelligent_tiering_configuration_list[].filter.and

A conjunction (logical AND) of predicates, which is used in evaluating a metrics filter. The operator must have at least two predicates, and an object must match all of the predicates in order for the filter to apply.

Show child fields
intelligent_tiering_configuration_list[].filter.and.prefix

An object key name prefix that identifies the subset of objects to which the configuration applies.

intelligent_tiering_configuration_list[].filter.and.tags[]
Show child fields
intelligent_tiering_configuration_list[].filter.and.tags[].key

Name of the object key.

intelligent_tiering_configuration_list[].filter.and.tags[].value

Value of the tag.

intelligent_tiering_configuration_list[].filter.prefix

An object key name prefix that identifies the subset of objects to which the rule applies.

Replacement must be made for object keys containing special characters (such as carriage returns) when using XML requests. For more information, see XML related object key constraints.

intelligent_tiering_configuration_list[].filter.tag

A container of a key value name pair.

Show child fields
intelligent_tiering_configuration_list[].filter.tag.key

Name of the object key.

intelligent_tiering_configuration_list[].filter.tag.value

Value of the tag.

intelligent_tiering_configuration_list[].id

The ID used to identify the S3 Intelligent-Tiering configuration.

intelligent_tiering_configuration_list[].status

Specifies the status of the configuration.

intelligent_tiering_configuration_list[].tierings[]
Show child fields
intelligent_tiering_configuration_list[].tierings[].access_tier

S3 Intelligent-Tiering access tier. See Storage class for automatically optimizing frequently and infrequently accessed objects for a list of access tiers in the S3 Intelligent-Tiering storage class.

intelligent_tiering_configuration_list[].tierings[].days

The number of consecutive days of no access after which an object will be eligible to be transitioned to the corresponding tier. The minimum number of days specified for Archive Access tier must be at least 90 days and Deep Archive Access tier must be at least 180 days. The maximum can be up to 2 years (730 days).

is_truncated

Indicates whether the returned list of analytics configurations is complete. A value of true indicates that the list is not complete and the NextContinuationToken will be provided for a subsequent request.

BOOLEAN
next_continuation_token

The marker used to continue this inventory configuration listing. Use the NextContinuationToken from this response to continue the listing in a subsequent request. The continuation token is an opaque value that Amazon S3 understands.

VARCHAR