Forum Discussion
Incremental Refresh Azure Blob
Hi, I need help implementing incremental refresh on Azure Blob databases. I've already implemented it the standard way, but the incremental refresh takes forever and sometimes it doesn't even update,...
What is your reasoning for doing this in the first place?
I have historical data in azure blob that is immutable, so I don't need to update it every time I need to update the report. That's why I want to implement incremental refresh, taking only the last 7 days, for example. But the big difficulty here is structuring the incremental refresh in the best way, and I'm not succeeding. I believe that the Azure Blob bases don't support query folding, and this may be considerably impacting the incremental update and I don't know what to do about it 😥ðŸ˜
I think it is a design conflict. Azure Blobs are not supposed to be re-stored somewhere else.
Do you have a performance issue during regular refresh?