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.