Incremental model default behavior when not specifying unique key (Snowflake)

I’m in the process of updating the logic for one of our incremental models for our CDC pipeline (the incremental model is run daily) and wanted to check the default behaviour in Snowflake when not specifying a unique key.

From the documentation, it appears that MERGE is the default incremental mode. When not specifying a Unique Key does this do a merge over the entire row if all columns are the same?

Without a unique key, you effectively create an append only model since there’s nothing to key the merge from.

1 Like