Databricks

Hunter1604 · ‎03-30-2023

How to remove checkpoints from DeltaLake table ?

I see that on my delta table exist a few checkpoints I want to remove the oldest one.

It seems that existing of it is blocking removing the oldest _delta_logs entries

ajaypanday6781 · ‎03-31-2023

Hi @Pawel Woj ,

If you want to keep your checkpoints X days, you can set delta.checkpointRetentionDuration to X days this way:

spark.sql(f"""
        ALTER TABLE delta.`path`
            SET TBLPROPERTIES (
                delta.checkpointRetentionDuration = 'X days'
            )
        """
)

Hunter1604 · ‎04-03-2023

Hi,

This looks well, thanks - will be testing it.

ajaypanday6781 · ‎04-03-2023

Test and let me know if it's working for you.

Anonymous · ‎03-31-2023

Hi @Pawel Woj

Hope everything is going great.

Just wanted to check in if you were able to resolve your issue. If yes, would you be happy to mark an answer as best so that other members can find the solution more quickly? If not, please tell us so we can help you.

Cheers!