cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

Is VACUUM operation recorded in the history of the delta table?

cristianc
Contributor

Greetings,

I have tried using Spark with DBR 9.1 LTS to run VACUUM on my delta table then DESCRIBE HISTORY to see the operation, but apparently the VACUUM operation was not in the history despite the things stated in the documentation from: https://docs.databricks.com/delta/delta-utility.html#3

From my understanding there should be a "VACUUM" operation in the history table. Can you please confirm if my understanding is correct, or if not can you please improve my understanding why not?

Regards,

Cristian

1 ACCEPTED SOLUTION

Accepted Solutions

AmanSehgal
Honored Contributor III

To capture the logs for VACUUM operation enable vacuum logging.

spark.conf.set("spark.databricks.delta.vacuum.logging.enabled",True)

On doing so, you'll see two records in the history logs.

  1. VACUUM START and
  2. VACUUM END

View solution in original post

3 REPLIES 3

Kaniz
Community Manager
Community Manager

Hi @Cristian Constantinescu​ ! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers in the community have an answer to your question first. Or else I will get back to you soon. Thanks.

AmanSehgal
Honored Contributor III

To capture the logs for VACUUM operation enable vacuum logging.

spark.conf.set("spark.databricks.delta.vacuum.logging.enabled",True)

On doing so, you'll see two records in the history logs.

  1. VACUUM START and
  2. VACUUM END

cristianc
Contributor

That makes sense, thanks for the reply!