What exactly does the Vacuum? Does cleaning the old versions of the Delta table?

[Kaniz · Accepted solution]

Hi @Borislav Blagoev​ ,

Vacuum cleans up files associated with a table.

Note:-

This command works differently depending on whether you’re working on a Delta or Apache Spark table.

Vacuum a Delta table (Delta Lake on Databricks)

Recursively vacuum directories associated with the Delta table and remove data files that are no longer in the latest state of the transaction log for the table and are older than a retention threshold. Files are deleted according to the time they have been logically removed from Delta’s transaction log + retention hours, not their modification timestamps on the storage system. The default threshold is 7 days.

Vacuum a Spark table (Apache Spark)

Recursively vacuums directories associated with the Spark table and remove uncommitted files older than a retention threshold. The default threshold is 7 days.

On Spark tables, Databricks automatically triggers 

VACUUM operations as data are written.

Source

[BorislavBlagoev]

Thanks!

[Kaniz]

Hi @Borislav Blagoev​ , If that answers your question would you like to mark it as the best answer?

[BorislavBlagoev]

I can't see where is the button for that

[Kaniz]

Hi @Borislav Blagoev​ , Shared the SS.