You are viewing documentation about an older version (1.1.0). View latest version

snowflake.snowpark.WhenNotMatchedClause

class snowflake.snowpark.WhenNotMatchedClause(condition: Column | None = None)[source]

Bases: object

A not-matched clause for the Table.merge() action. It matches all remaining rows in the target Table that do not satisfy join_expr but satisfy condition, if it is provided. You can use functions.when_not_matched() to instantiate this class.

Parameters:

condition – An optional Column object representing the specified condition.

Methods

insert(assignments)

Defines an insert action for the not-matched clause and returns an updated WhenNotMatchedClause with the new insert action added.