SPICE: full vs Incremental Refresh ORDER (UI)

Question & Answer
1

My Apologies if this topic has been addressed

I need to refresh SPICE data weekly and keep the last 4 weeks

Will a Full refresh followed by an incremental (windows size:4) do?

Or Vice versa?

Kind regards

2

Hello @chhbi !

Do you mean that you want to load new data every week and keep only the previous 4 weeks of data?

Incremental refresh is used to replace specific parts of your data with in a time window:

1 Like
3

@duncan
Exactly.
As you know, keeping only the previous n weeks can be done manually via Date Filter but iā€™d like to automate it via UI

Best Regards,

4

Hello @chhbi !

Got it! To get this week and the previous 4 I would first set the refresh window to 5 weeks. An important note about the incremental refresh is that it will delete data older within your window of refresh.

5

@duncan
Excellent! Thank you very much for your help

1 Like