Forum Discussion
Incremental Refresh and Query Folding
Hi everybody,
i'm not able to know if my incremental refresh and query folding it is working correctly.
I have a multiple API call. I create the list of all my calls that i transform in a table and then explode the table results.
The option "View Native Query" with the right button on the last passage of my transformation is Disabled.
But if i go to the xmla endpoint with the ssms i see that is refreshing the right part. Infact is refreshing only the rows that i declare on the incremental refresh parameters (the last 3 days for example).
Also the time to refresh the dataset is fast. (1 minute).
How to be sure that the API call is only for the last 3 days and not for all period?
Thanks any suggestion and sorry for my not perfect english.
As long as you can observe that the right partitions are updated (and the other ones left alone) you are good. Query folding is not necessary for incremental refresh (although it makes it a little easier).
2 Replies
As long as you can observe that the right partitions are updated (and the other ones left alone) you are good. Query folding is not necessary for incremental refresh (although it makes it a little easier).