cancel
Showing results forย 
Search instead forย 
Did you mean:ย 
missing-QuestionPost
cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Delta table transaction log

yatharth
New Contributor III

What if i delete the delta table in the 10th transaction(Checkpoint) will i be able to recover the table through time travel

1 ACCEPTED SOLUTION

Accepted Solutions

Lakshay
Databricks Employee
Databricks Employee

If you meant to run the "DELETE FROM TABLE" command, then it will not actually delete the table. It will just delete all the data from the table which you will be able to recover from previous versions.

But if you meant to run the "DROP Table" command, then it will drop the table and you will not be able to recover it.

View solution in original post

2 REPLIES 2

Lakshay
Databricks Employee
Databricks Employee

If you meant to run the "DELETE FROM TABLE" command, then it will not actually delete the table. It will just delete all the data from the table which you will be able to recover from previous versions.

But if you meant to run the "DROP Table" command, then it will drop the table and you will not be able to recover it.

Anonymous
Not applicable

Hi @Yatharth Malhotraโ€‹ 

Thank you for posting your question in our community! We are happy to assist you.

To help us provide you with the most accurate information, could you please take a moment to review the responses and select the one that best answers your question?

This will also help other community members who may have similar questions in the future. Thank you for your participation and let us know if you need any further assistance! 

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you wonโ€™t want to miss the chance to attend and share knowledge.

If there isnโ€™t a group near you, start one and help create a community that brings people together.

Request a New Group