Just for anybody interested: I just found out that you just update the _I table to some older values, to reload all data greater than the value you set.
Previously, I always reloaded the full table in these cases. This is not necessary and saves me some time from now on.
Best answer by JTreadwell
View original
+5
Hi hgr, thank you so much for posting this great solution! I can confirm this is a reliable solution for reloading a select portion of an incremental table.
Maybe it would be an option to add an "Execute From ..." feature in Discovery Hub, which asks for incremental values like an id or a date to load a table from?
Or alternatively a: "Load last X days/Y ids" feature on top of the usual incremental rules.
+5
Great Idea Hendrik. I would encourage you to submit this to Ideas section if you haven't already.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
