It is not possible to directly restore a deleted catalog or schema if they were dropped with the CASCADE option, especially in Databricks Unity Catalog. When a catalog or schema is dropped with CASCADE, all its dependent objects, such as schemas and tables, are also deleted. Current functionality focuses on restoring only tables that were dropped under certain conditions.
No inherent mechanisms currently exist in Unity Catalog to dynamically restrict the use of the CASCADE option.
Hope this helps. Louis.
