snowflake.snowpark.WhenMatchedClauseΒΆ
- class snowflake.snowpark.WhenMatchedClause(condition: Optional[Column] = None)[source]ΒΆ
Bases:
object
A matched clause for the
Table.merge()
action. It matches all remaining rows in the targetTable
that satisfyjoin_expr
while also satisfyingcondition
, if it is provided. You can usefunctions.when_matched()
to instantiate this class.- Parameters:
condition β An optional
Column
object representing the specified condition. For example,col("a") == 1
.
Methods
delete
()Defines a delete action for the matched clause and returns an updated
WhenMatchedClause
with the new delete action added.update
(assignments)Defines an update action for the matched clause and returns an updated
WhenMatchedClause
with the new update action added.