---
title: "POST /ListTableStorageOptimizers"
method: POST
path: "/ListTableStorageOptimizers"
---

# POST /ListTableStorageOptimizers

`POST /ListTableStorageOptimizers`

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

## Query parameters

- `MaxResults` string
- `NextToken` string

## Request body

- object
  - `CatalogId` string — The Catalog ID of the table.
  - `DatabaseName` string, required — Name of the database where the table is present.
  - `TableName` string, required — Name of the table.
  - `StorageOptimizerType` 'COMPACTION' | 'GARBAGE_COLLECTION' | 'ALL' — The specific type of storage optimizers to list. The supported value is <code>compaction</code>.
  - `MaxResults` integer — The number of storage optimizers to return on each call.
  - `NextToken` string — A continuation token, if this is a continuation call.

## Response `200`

Success

- ListTableStorageOptimizersResponse
  - `StorageOptimizerList` StorageOptimizer[] — A list of the storage optimizers associated with a table.
    - `StorageOptimizerType` 'COMPACTION' | 'GARBAGE_COLLECTION' | 'ALL' — The specific type of storage optimizer. The supported value is <code>compaction</code>.
    - `Config` object — A map of the storage optimizer configuration. Currently contains only one key-value pair: <code>is_enabled</code> indicates true or false for acceleration.
    - `ErrorMessage` string — <p>A message that contains information about any error (if present).</p> <p>When an acceleration result has an enabled status, the error message is empty.</p> <p>When an acceleration result has a disabled status, the message describes an error or simply indicates "disabled by the user".</p>
    - `Warnings` string — A message that contains information about any warnings (if present).
    - `LastRunDetails` string — When an acceleration result has an enabled status, contains the details of the last job run.
  - `NextToken` string — A continuation token for paginating the returned list of tokens, returned if the current segment of the list is not the last.

## Other responses

- `480` — EntityNotFoundException
- `481` — InvalidInputException
- `482` — AccessDeniedException
- `483` — InternalServiceException

---

[API](https://skmtc.net/aws/apis/lakeformation.md) · [All operations](https://skmtc.net/aws/apis/lakeformation/llms.txt) · [OpenAPI document](https://skmtc-service-staging.skmtc.workers.dev/v1/apis/aws/lakeformation/versions/a7cd69eb107d/schema)