Iceberg table metadata isn't removed after DROP TABLE

[DimensionWieldr]

Describe the bug
Iceberg table metadata isn't removed after DROP TABLE.

To Reproduce
Steps to reproduce the behavior:

1. Create iceberg table

CREATE TABLE ice.`default.metadata_testing`
(
    `event_month` Int32
)
ENGINE = Iceberg('s3://protvjoe-1lfyj7kp-iceberg/default/metadata_testing')
PARTITION BY event_month

2. Drop the table

DROP TABLE ice.`default.metadata_testing`

4. Create another iceberg table with the same name and we get:

Received exception from server (version 26.3.10):
Code: 57. DB::Exception: Received from test-export-0-0.proton-7vjoe.dev.altinity.cloud:9440. DB::Exception: Iceberg table with path default/metadata_testing/ already exists. (TABLE_ALREADY_EXISTS)

Expected behavior
Creation with same name succeeds after drop.

Key information
Provide relevant runtime details.

• 26.3.10.20001 Antalya
• Iceberg table is on ice rest catalog on ACM dev

[subkanthi]

Its better to wait for this fix https://github.com/Altinity/ClickHouse/pull/1896/changes, since the Iceberg( engine calls the ice rest catalog, the drop table should send the purgeRequested=true flag in the REST API and that change seems to be handled in the above PR.
#1909 (comment)

@alsugiliazova @DimensionWieldr @zvonand