cancel
Showing results for 
Search instead for 
Did you mean: 

Save only last X Period History in Incremental Tables

nikhil_cr
Cosmonaut

Hi,

I have an incremental table where I load data once a week. It’s been 6 months, and the data has already exceeded 30 GB (~500 million rows). Now, if I want to restrict the history to only the last 3 months, is there a way to do this? I don’t want to take a backup, remove the unnecessary history, and append it back. I’m looking for an automated solution. I see the load filter option, but is there any other way to achieve this?

 

Thanks,

Nikhil

2 REPLIES 2

JoeM
Community Manager
Community Manager

Hi @nikhil_cr, starting in 2024.7, we introduced better table management options. Below, you will see the option that can retain data based on a relative period:

JoeM_0-1736775757815.png

 

@JoeM Thank you 🙂 Much appreciated your help.