Remove Old Data During Refresh

Question & Answer
1

Would be great if there was a feature of Incremental Refresh that, in addition to refreshing for the set window, also removes data for another set window.

Use Case - receive a large number of records every day. You want to display the past year of these records. Full Refresh takes a long time. Incremental Refresh is good for adding newest records. But cannot remove old records (records over a year old, in this case), and storing more than a year’s worth will eat away at SPICE storage.

2

That would be a nice feature. I’ll mark this as a feature request.

To solve it immediately, you would need to add it in a where clause of your SQL (if you have SQL)