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!

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