Forum Discussion
AxiomaticOne
2 years agoHelper I
Incremental refresh is adding an extra day
This make zero logical sense to me...what am I missing? Here is what happened today 6/22: If the "only refresh complete days" box IS checked the following dates were refreshed: 31, 1, 2, 3, 4,...
lbendlin
1 year agoSuper User
Did you figure out what caused the extra day?
AxiomaticOne
1 year agoHelper I
Regretfully no, I have it on the backlog to go back and do detailed testing on smaller incremental refresh periods and create multiple tables with different settings.
As a work around we've just added +1 day to the expected range so that we can hit the partitions with an API refresh monthly to true up historical data.
- lbendlin1 year agoSuper User
Just to confirm - you made RangeStart inclusive and RangeEnd exclusive?
- AxiomaticOne1 year agoHelper I
Fair question. Yes that is true:
- lbendlin1 year agoSuper User
the parameter needs to be called RangeStart, not varRangeStart . And you seem to be missing the single quotes.