Glue client create_table_optimizer does not support disable functionality

[mr-shitij]

Describe the bug

With AWS management console compaction, snapshot retention and orphan file deletion of Glue Iceberg tables can be configured.

This is can be done via boto3 - but once enabled when we try to disable it by enable=false, it wont work.

Regression Issue

• Select this option if this issue appears to be a regression.

Expected Behavior

on passing enable = False it should disable the specific function.

Current Behavior

on passing enable = False it is not disabling the specific function.

Reproduction Steps

This function is part of lambda function. I am passing params to this function which contains

  {
    'enable': False,
    ...
  }

def create_compaction_optimizer(glue_client, params, table_name):
    optimizer_config = {
        'roleArn': params['role_arn'],
        'enabled': params['enabled'],
    }

    print('create_compaction_optimizer:')
    print(table_name)
    print(optimizer_config)
    print(params)

    return glue_client.create_table_optimizer(
        CatalogId=params['catalog_id'],
        DatabaseName=params['database_name'],
        TableName=table_name,
        Type='compaction',
        TableOptimizerConfiguration=optimizer_config,
    )

If I execute this code twice for both enable = True and False. It is giving error as a Already Exists on Table.

Possible Solution

No response

Additional Information/Context

No response

SDK version used

1.36.0

Environment details (OS name and version, etc.)

The code is executing on AWS Lambda

[mr-shitij]

def update_optimizer_configuration(glue_client, params: Dict[str, Any], table_name: str,
                                 optimizer_type: str, config: Dict[str, Any]) -> Dict:
    """
    Creates or updates a table optimizer based on whether it already exists.
    """
    try:
        existing_optimizer = get_existing_optimizer(glue_client, params, table_name, optimizer_type)
        
        if existing_optimizer:
            print(f"Updating existing {optimizer_type} optimizer")
            response = glue_client.update_table_optimizer(
                CatalogId=params['catalog_id'],
                DatabaseName=params['database_name'],
                TableName=table_name,
                Type=optimizer_type,
                TableOptimizerConfiguration=config
            )
        else:
            print(f"Creating new {optimizer_type} optimizer")
            response = glue_client.create_table_optimizer(
                CatalogId=params['catalog_id'],
                DatabaseName=params['database_name'],
                TableName=table_name,
                Type=optimizer_type,
                TableOptimizerConfiguration=config
            )
        return response
    except ClientError as e:
        print(f"Error updating optimizer configuration: {str(e)}")
        raise