table_bucket_storage_class

Creates, updates, deletes, gets or lists a table_bucket_storage_class resource.

Overview

Name	table_bucket_storage_class
Type	Resource
Id	aws.s3tables.table_bucket_storage_class

Fields

The following fields are returned by SELECT queries:

get_table_bucket_storage_class

Name	Datatype	Description
storage_class	string	The storage class for the table or table bucket. Valid values include storage classes optimized for different access patterns and cost profiles. (STANDARD, INTELLIGENT_TIERING)

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
get_table_bucket_storage_class	select	table_bucket_arn, region		Retrieves the storage class configuration for a specific table. This allows you to view the storage class settings that apply to an individual table, which may differ from the table bucket's default configuration. Permissions You must have the s3tables:GetTableBucketStorageClass permission to use this operation.
put_table_bucket_storage_class	replace	table_bucket_arn, region, storageClassConfiguration		Sets or updates the storage class configuration for a table bucket. This configuration serves as the default storage class for all new tables created in the bucket, allowing you to optimize storage costs at the bucket level. Permissions You must have the s3tables:PutTableBucketStorageClass permission to use this operation.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

Name	Datatype	Description
region	string	AWS region (default: us-east-1)
table_bucket_arn	string	The Amazon Resource Name (ARN) of the table bucket.

SELECT examples

get_table_bucket_storage_class

Retrieves the storage class configuration for a specific table. This allows you to view the storage class settings that apply to an individual table, which may differ from the table bucket's default configuration. Permissions You must have the s3tables:GetTableBucketStorageClass permission to use this operation.

SELECT
storage_class
FROM aws.s3tables.table_bucket_storage_class
WHERE table_bucket_arn = '{{ table_bucket_arn }}' -- required
AND region = '{{ region }}' -- required
;

REPLACE examples

put_table_bucket_storage_class

Sets or updates the storage class configuration for a table bucket. This configuration serves as the default storage class for all new tables created in the bucket, allowing you to optimize storage costs at the bucket level. Permissions You must have the s3tables:PutTableBucketStorageClass permission to use this operation.

REPLACE aws.s3tables.table_bucket_storage_class
SET 
storageClassConfiguration = '{{ storageClassConfiguration }}'
WHERE 
table_bucket_arn = '{{ table_bucket_arn }}' --required
AND region = '{{ region }}' --required
AND storageClassConfiguration = '{{ storageClassConfiguration }}' --required;