Forum Discussion

AxiomaticOne's avatar
AxiomaticOne
Icon for Helper I rankHelper I
2 years ago

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,...
General Comment
Need Help
AxiomaticOne's avatar
AxiomaticOne
Icon for Helper I rankHelper I
2 years ago

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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Just to confirm - you made RangeStart inclusive and RangeEnd exclusive?

  • AxiomaticOne's avatar
    AxiomaticOne
    Icon for Helper I rankHelper I
    2 years ago

    Fair question. Yes that is true:

     

    • lbendlin's avatar
      lbendlin
      Icon for Super User rankSuper User
      2 years ago

      the parameter needs to be called RangeStart, not varRangeStart . And you seem to be missing the single quotes.

      • AxiomaticOne's avatar
        AxiomaticOne
        Icon for Helper I rankHelper I
        2 years ago

        It is: