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

[cristianc]

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

[Kaniz_Fatma]

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 · Accepted solution]

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]

That makes sense, thanks for the reply!