Hi @priam_singh
Unfortunately there is no way to delete older records in spice.
My recommendation would be to at the right time (before the DB gets too big) do a full refresh and pull in 30 days of data to clean it up. Then on a daily basis do 1 or 2 day look back window to get the latest records. Maybe when you get to 30days of data(depending on how much data you have, longer if its not that much data) do a full refresh.
On Analysis and dashboards filter for the last 30days. (you could even setup a flag as a custom column and filter on that)
Hope this helps.
Regards,
Ramon Lopez