Is it possible restore a deleted catalog and schema

[ashokz]

Is it possible restore a deleted catalog and schema.

if CASCADE is used even though schemas and tables are present in catalog, catalog will be dropped.

Is it possible to restore catalog or is possible to restrict the use of CACADE command.

Thank you.

[Louis_Frolio · Accepted solution]

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.

[immassiv]

Are they any plans on supporting a seamless recovery of "forcefully" (with cascade) deleted Catalogs or Schemas?

[Louis_Frolio]

There is nothing I can see on the immediate roadmap.

Louis

[immassiv]

@Louis_Frolio, thanks for updating.

[Louis_Frolio]

@immassiv, if you’re satisfied with the answer, would you mind clicking “Accept as Solution”? This helps others by confirming the solution and clearing up any doubts.

Thanks, Louis.

[immassiv]

@Louis_Frolio I cannot click any "Accept as Solution" button, as I was not the one creating the post, I believe 🙂