An account is using the default setting for every parameter. The MERGE command updates or deletes target rows that join to multiple source rows.
MERGE
What will be the outcome of the MERGE statement?
For a MERGE in which multiple source rows match a target row for an update or delete, the operation is nondeterministic. ERROR_ON_NONDETERMINISTIC_MERGE defaults to TRUE, so Snowflake returns an error instead of selecting a matching source row arbitrarily. Snowflake MERGE documentation
ERROR_ON_NONDETERMINISTIC_MERGE
TRUE
Community Discussion