Forum Discussion
Incremental Refresh didn't save time
I have a very large dataset of over 25 million rows and I set up a 90-day incremental refresh for it. But the refresh took nearly as long as the usual refresh. Does anybody know how to reduce the inc...
- Hi there
It would then appear that both of those data sources do not support query folding.
Which means that it has to load all the data first, and then determine which data to load incrementally. In doing it in this manner it will not be any quicker using incremental refreshing.
Hi GilbertQ ,
Thank you for your advice. I didn't make it clearly. I use dataflow and snowflake individually for incremental refresh and they both didn't work.
Thanks,
Hi there
It would then appear that both of those data sources do not support query folding.
Which means that it has to load all the data first, and then determine which data to load incrementally. In doing it in this manner it will not be any quicker using incremental refreshing.
It would then appear that both of those data sources do not support query folding.
Which means that it has to load all the data first, and then determine which data to load incrementally. In doing it in this manner it will not be any quicker using incremental refreshing.