v.25.9New Feature

New setting to delete files

A new setting to delete files on dropping Iceberg tables. This closes #86211. #86501 (scanhex12).
Added a new setting to enable automatic deletion of files when dropping Iceberg tables in ClickHouse.

Why it matters

This feature solves the issue of leftover files after dropping Iceberg tables by allowing users to automatically delete associated files, preventing wasted storage and improving data management.

How to use it

Users can enable this feature by setting the new configuration option that controls file deletion on dropping Iceberg tables. Once enabled, dropping an Iceberg table will also delete its underlying files automatically.