topic How to restore if a catalog is deleted in Administration & Architecture

How to restore if a catalog is deleted

bhanu_dp — Mon, 17 Mar 2025 11:25:45 GMT

I am looking to identify potential pitfall in the decentralized workspace framework where the key business owner have full access to their respective workspace and catalogs. In case of accidental delete/drop schema or catalog from the UC, what are the ways to restore a catalog?

Re: How to restore if a catalog is deleted

KaranamS — Mon, 17 Mar 2025 19:55:35 GMT

Hi @bhanu_dp ,

To retrieve accidental deletes, you can -

1. Restore it to a previous version using time travel feature

https://docs.databricks.com/gcp/en/delta/history#restore-a-delta-table-to-an-earlier-state

2. Use UNDROP command

https://docs.databricks.com/aws/en/sql/language-manual/sql-ref-syntax-ddl-undrop-table

Just to note, to restore a catalog, you will need to restore all tables under it.

Hope this helps!

Re: How to restore if a catalog is deleted

bhanu_dp — Thu, 20 Mar 2025 07:03:12 GMT

Hello @KaranamS

Thank you for your inputs. Here you have provided mechanism for table delete/drop.

But however, I am look for a more dire scenario where the schema or the parent catalog is dropped.

In a decentralized platform, there are catalog owners who have full access on their catalog.

One way I can think of is disabling delete on parent catalog and applying further governance rules.

However, in any case, I am looking for a solution or mechanism to restore accidental drops on catalog or schema altogether including the structure, permissions and other artifacts within the schema/catalog.