cancel
Showing results for 
Search instead for 
Did you mean: 
Knowledge Sharing Hub
Dive into a collaborative space where members like YOU can exchange knowledge, tips, and best practices. Join the conversation today and unlock a wealth of collective wisdom to enhance your experience and drive success.
cancel
Showing results for 
Search instead for 
Did you mean: 

How to recover Dropped Tables in Databricks

Sourav-Kundu
Contributor

Have you ever accidentally dropped a table in Databricks, or had someone else mistakenly drop it?

Databricks offers a useful feature that allows you to view dropped tables and recover them if needed.

1. You need to first execute
SHOW TABLES DROPPED

2. Then you need to UNDROP the table which you need but dropped by mistake using the below command
UNDROP TABLE { tablename | WITH ID tableid }

https://docs.databricks.com/en/sql/language-manual/sql-ref-syntax-ddl-undrop-table.html#examples

@Sujitha 

 

 

0 REPLIES 0

Join Us as a Local Community Builder!

Passionate about hosting events and connecting people? Help us grow a vibrant local community—sign up today to get started!

Sign Up Now