The problem I’m having
I want help in understanding if i am correctly converting my existing full refresh models to incremental ones.
I understand that to do this every intermediate, staging, mart table needs to be materialized as an incremental model( correct?).
Else their is no point in having an incrementally materialized staging layer only.
The context of why I’m trying to do this
I am converting my existing full refresh models to incremental one’s, I have added a new column depicting the time of ingestion which I will use to filter out rows.
I am sure that updating all the existing models with incremental strategy in the config will do the job. But want help in understanding if I am doing it correctly.
Any reference incremental project will also help in taking inspiration.