Hi @vidya_kothavale ,

1. The feature is called preditive optimization for manged table. Predictive optimization runs the following operations on Unity Catalog managed tables:

- OPTIMIZE

- VACCUM

- ANALYZE

You can read more here:

Predictive optimization for Unity Catalog managed tables - Azure Databricks | Microsoft Learn

2. You can disable predictive optimization for a catalog or schema in following way:

Predictive optimization for Unity Catalog managed tables | Databricks on AWS

ALTER CATALOG [catalog_name] { ENABLE | DISABLE | INHERIT } PREDICTIVE OPTIMIZATION;
ALTER { SCHEMA | DATABASE } schema_name { ENABLE | DISABLE | INHERIT } PREDICTIVE OPTIMIZATION;

And if you want to increase retention period you can use following query:

ALTER TABLE table_name SET TBLPROPERTIES ('delta.deletedFileRetentionDuration' = '30 days');

 3. You can't do much since VACUUM removes all files from the table directory that are not managed by Delta, as well as data files that are no longer in the latest state of the transaction log for the table and are older than a retention threshold. Of course you can try restore deleted files using cloud provider native options.
For instance if you have enabled soft deletes on Azure Storage you can try to use that. 

If the answer was helpful, please consider marking it as accepted solution