Forum Discussion

RoopaR's avatar
RoopaR
Icon for Advocate I rankAdvocate I
6 years ago
Solved

incremental refresh on a non-date integer column

Hi,   I have a need to do incremental refresh (daily cadence) on my datasets based on a non-date integer column (bigint) We have time series data that's loaded on to SQL server that sometimes miss...
Need Help
  • lbendlin's avatar
    lbendlin
    6 years ago

    You can't. Incremental refresh is timestamp based. 

     

    Can you use a different timestamp, like "Record received"  ?  

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

You can't. Incremental refresh is timestamp based. 

 

Can you use a different timestamp, like "Record received"  ?  

RoopaR's avatar
RoopaR
Icon for Advocate I rankAdvocate I
6 years ago

Thank you lbendlin for the suggestion. By adding a record_ received column at source I can set up incremental refresh. Didn't think of that earlier. Appreciate your input!