Unity Catalog Backup

[noorbasha534]

Dear all

Has anyone explored on backing up unity catalog?...

because of gaps in the security model of Databricks, we had to make certain user groups as the schema owners and the schema owners can drop the schema 🙂

I always wonder how to recover the schema ((that has views only)) if some user drops it by mistake....

so, wanted to check if someone attempted to backup the whole catalog...((we have external tables and views, functions, volumes etc etc))

[WiliamRosa]

Hi @noorbasha534,
Currently, there’s no native backup/restore. The pragmatic approach is.
Treat Unity Catalog metadata as code (Terraform / SQL DDL checked into Git), regularly export UC object definitions with REST API and lock down schema ownership so end-users can’t drop them.