Pranav Kohli
Aug 19, 2023

--

Instead of reprocessing last 7 days of data again, there are two better alternatives

1. Change datatype of created_at column to timestamp instead of date

2. Just add an equal+to in the condition

where event_time >= (select max(event_time) from {{ this }})

Now you will re process only latest day's data again instead of last 7 days

--

--

Pranav Kohli
Pranav Kohli

Responses (1)