cancel
Showing results for 
Search instead for 
Did you mean: 
Data Governance
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
Honored Contributor III

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
Honored Contributor III

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
New Contributor II
New Contributor II

vihangk1
New Contributor II
New Contributor II

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.

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.