Skip to main content

table_storage_class

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

Overview

Nametable_storage_class
TypeResource
Idaws.s3tables.table_storage_class

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
storage_classstringThe 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:

NameAccessible byRequired ParamsOptional ParamsDescription
get_table_storage_classselecttable_bucket_arn, namespace, name, regionRetrieves 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:GetTableStorageClass 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.

NameDatatypeDescription
namestringThe name of the table.
namespacestringThe namespace associated with the table.
regionstringAWS region (default: us-east-1)
table_bucket_arnstringThe Amazon Resource Name (ARN) of the table bucket that contains the table.

SELECT examples

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:GetTableStorageClass permission to use this operation.

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