Incremental PDT's - rebuild entire table nightly

Hi All! Does anyone have thoughts on the following use-case for incremental PDT’s?

I have an incremental PDT that refreshes every 30 minutes with an increment_offset of 5 days. Is it possible to set a trigger so that this PDT rebuilds in its entirety once per day? (from the beginning of time, ignoring the increment offset - just like it did on the initial build).

The use case is that customers want to see very recent results during the day, but every night, there should be a ‘true-up’ for late arriving data - and it’s ok that this build takes 5x longer.

0 11 983
11 REPLIES 11
Top Labels in this Space
Top Solution Authors