snowflake.snowpark.WhenNotMatchedClause¶

class snowflake.snowpark.WhenNotMatchedClause(condition: Optional[Column] = None)[source] (https://github.com/snowflakedb/snowpark-python/blob/v1.23.0/src/snowflake/snowpark/table.py#L160-L231)¶

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.