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.