topic Re: Is it possible restore a deleted catalog and schema in Administration & Architecture

Is it possible restore a deleted catalog and schema

ashokz — Fri, 25 Apr 2025 21:19:10 GMT

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.

Re: Is it possible restore a deleted catalog and schema

Louis_Frolio — Fri, 25 Apr 2025 21:47:00 GMT

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.

Re: Is it possible restore a deleted catalog and schema

immassiv — Sun, 21 Sep 2025 17:02:27 GMT

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

Re: Is it possible restore a deleted catalog and schema

Louis_Frolio — Tue, 23 Sep 2025 01:57:12 GMT

There is nothing I can see on the immediate roadmap.

Louis

Re: Is it possible restore a deleted catalog and schema

immassiv — Wed, 24 Sep 2025 08:16:20 GMT

@Louis_Frolio, thanks for updating.

Re: Is it possible restore a deleted catalog and schema

Louis_Frolio — Fri, 26 Sep 2025 16:17:37 GMT

@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.

Re: Is it possible restore a deleted catalog and schema

immassiv — Mon, 29 Sep 2025 09:12:32 GMT

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