cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
Data Governance
Join discussions on data governance practices, compliance, and security within the Databricks Community. Exchange strategies and insights to ensure data integrity and regulatory compliance.
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Is it possible to UNDROP a dropped managed table? Any workaround?

Anonymous
Not applicable
1 ACCEPTED SOLUTION

Accepted Solutions

Ryan_Chynoweth
Esteemed Contributor

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

3 REPLIES 3

Ryan_Chynoweth
Esteemed Contributor

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.

User16602068676
Databricks Employee
Databricks Employee

vihangk1
Databricks Employee
Databricks Employee

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.

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group