table_storage_optimizers

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

Overview

Name	table_storage_optimizers
Type	Resource
Id	aws.lakeformation.table_storage_optimizers

Fields

The following fields are returned by SELECT queries:

list_table_storage_optimizers

Name	Datatype	Description
next_token	string	A continuation token for paginating the returned list of tokens, returned if the current segment of the list is not the last.
storage_optimizer_list	array	A list of the storage optimizers associated with a table.

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list_table_storage_optimizers	select	region		Returns the configuration of all storage optimizers associated with a specified table.
update_table_storage_optimizer	update	region, DatabaseName, TableName, StorageOptimizerConfig		Updates the configuration of the storage optimizers for a table.

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)

SELECT examples

list_table_storage_optimizers

Returns the configuration of all storage optimizers associated with a specified table.

SELECT
next_token,
storage_optimizer_list
FROM aws.lakeformation.table_storage_optimizers
WHERE region = '{{ region }}' -- required
;

UPDATE examples

update_table_storage_optimizer

Updates the configuration of the storage optimizers for a table.

UPDATE aws.lakeformation.table_storage_optimizers
SET 
CatalogId = '{{ CatalogId }}',
DatabaseName = '{{ DatabaseName }}',
TableName = '{{ TableName }}',
StorageOptimizerConfig = '{{ StorageOptimizerConfig }}'
WHERE 
region = '{{ region }}' --required
AND DatabaseName = '{{ DatabaseName }}' --required
AND TableName = '{{ TableName }}' --required
AND StorageOptimizerConfig = '{{ StorageOptimizerConfig }}' --required
RETURNING
result;