SnowPro Advanced Architect

By Snowflake · Question Mode

QuestionQ5

VerifiedData Storage and Processing

An account is using the default setting for every parameter. The MERGE command updates or deletes target rows that join to multiple source rows.

What will be the outcome of the MERGE statement?

Explanation

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

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!