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!

[bhanu_dp]

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.