Deleting an optimizer - Amazon Glue
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Deleting an optimizer

You can delete an optimizer and associated metadata for the table using Amazon CLI or Amazon API operation.

Run the following Amazon CLI command to delete optimization history for a table. You need to specify the optimizer type along with the catalog ID, database name and table name. The acceptable values are: compaction, retention, and orphan_file_deletion.

aws glue delete-table-optimizer \
  --catalog-id 123456789012 \
  --database-name iceberg_db \
  --table-name iceberg_table \
  --type compaction

Use DeleteTableOptimizer operation to delete an optimizer for a table.