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 targetTable
that do not satisfyjoin_expr
but satisfycondition
, if it is provided. You can usefunctions.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.