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