Incremental PDTs in Practice: increment_key, increment_offset, and Builds That Do Not Rescan History
September 9, 2026 · Vistelio
Rebuilding a three-year PDT every night to add one day of data is a warehouse bill you do not need to pay. This tutorial covers incremental PDTs end to end: choosing an increment_key, sizing increment_offset for late-arriving data, partitioning so the increment is actually cheap, verifying the build SQL, and the failure modes that quietly produce wrong numbers.
Read more