How to recover Dropped Tables in Databricks
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-19-2024 08:41 AM - edited 10-19-2024 08:59 AM
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
0 REPLIES 0

