How to restore if a catalog is deleted

[bhanu_dp]

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?

[KaranamS]

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!