CDC from snapshot

Need to select only the changed and updated existing records my source table. So, before running the my core model, i prepare the snapshot. In my core model mentioned, selecting the snapshot with condition as “dbt_valid_to” is null, but running the model it select all records from snapshot including the new and old records too.

  1. If there is any option to add the flag with value as O - Old Record and N - New Record in snapshot.?
  2. For first run the flag should be N for the records and for second run the flag should be O for existing records and N for new records.
1 Like