Forum Discussion
Anonymous
8 years agoNot applicable
Incremental Refreshes - how to accomplish future dates?
Hi, I'm trying to experiment with incremental refreshes, using our "Visit" data. "Visit" is a fact that includes not only historic visits (completed, cancelled, etc.) but also future dated "sched...
kevhav
Continued Contributor
8 years agoIn the documentation, like here, Microsoft mentions that they plan to add the ability to set an "effective date," other than "the current UTC date/time," from which the incremental refresh policy "steps backward" to determine the "last X periods" to be incrementally refreshed.
I wonder if that will mean that you will be able to set an effective date in the future, to solve this. For example, you could send your incremental refresh policty to "Refresh rows in the last 3 years..." and set an "effective date" of '2021-01-01 00:00:00'. Then, presumably (hopefully), it would create partitions for 2020, 2019 and 2018...and each incremental refresh would refresh all three of those partitions.