Forum Discussion
Overwriting incremental refresh
Yes a full refresh ignores the refresh policy. You have to pass a use refresh policy parameter if you want to respect it.
Hi smpa01
I would suggest doing a process full on the entire database. This will make sure that all other tables also get all the latest data (there could be other tables which might be missing some data)
GilbertQ thanks !!! my Q is does "process full" of the entire database ensure ingesting data to the sales table ( as well as to the other tables) despite currently having a incremental refresh policy of 7 days? My worry is whether the one time "process full" is still subject to existing 7 days IR policy. In that case, even doing process full will only correctly ingest last 7days and not prior to that.
Yes a full refresh ignores the refresh policy. You have to pass a use refresh policy parameter if you want to respect it.
bcdobbs I can confirm it works. Now, I have done it, I am currently worrying whther it would still reinstate the incremental refresh policy. 😂
I want he business to be usual (IR as usual) unless I decide to perfrom a FR and once a FR is done does it go back to IR?
Also, what do you mean by You have to pass a use refresh policy parameter if you want to respect it.