06-14-2021 02:53 PM
06-21-2021 12:28 PM
It is not possible to undrop a managed table. When you drop a managed table it will also remove the data from cloud storage as well. If it were an unmanaged table then you could simply recreate the table because it would be persisted.
View solution in original post
07-21-2023 12:07 PM
Databricks now supports this via https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html!
07-21-2023 12:31 PM
Starting DBR 12.1 you can run the UNDROP command to undrop a managed or external table. The table must be in Unity Catalog for this feature to work. See https://docs.databricks.com/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html for more details and examples.
