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
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.

Join 100K+ Data Experts: Register Now & Grow with Us!

Excited to expand your horizons with us? Click here to Register and begin your journey to success!

Already a member? Login and join your local regional user group! If there isn’t one near you, fill out this form and we’ll create one for you to join!