Loading historical data using incremental PDT

[pushkar_kastoor]

I have an incremental PDT that loads data on a daily basis. However when I deploy the same to production I want to do a one time historical data load from Jan 2021 till date. How can I go about doing so?

I tried changing the filter first be “2021/01/01 - 2022/01/16” for the first deployment and then changing the value to “1 days go for 1 complete days”, but I realized that changing the filter rebuilts that entire PDT so the older data gets wiped off and only 1 days worth of data is present in the table.