How to recover Dropped Tables in Databricks

Sourav-Kundu — Sat, 19 Oct 2024 15:59:18 GMT

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

topic How to recover Dropped Tables in Databricks in Community Articles

How to recover Dropped Tables in Databricks