pradeep_singh
Honored Contributor III

If your source only emits full daily snapshots, create_auto_cdc_from_snapshot_flow() is purpose-built for this and will likely be simpler and safer to operate than synthesizing CDC events for create_auto_cdc_flow(). It automatically computes inserts/updates/deletes between snapshots, supports SCD1/2, enforces strict snapshot ordering, and avoids you having to model delete/truncate semantics or event sequencing. 

Thank You
Pradeep Singh - https://www.linkedin.com/in/dbxdev