cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
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

2 REPLIES 2

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!