Snowpark Scala API Reference 1.19.1 - com.snowflake.snowpark.NotMatchedClauseBuilder
Keywords: Snowpark Scala API Reference 1.19.1 com.snowflake.snowpark.NotMatchedClauseBuilder

Snowpark Scala API Reference1.19.1 < Back
 

# Packages

-  package root
  Definition Classes
    root
-  package com
  Definition Classes
    root
-  package snowflake
  Definition Classes
    com
-  package snowpark
  Definition Classes
    snowflake
-  package types

  This package contains all Snowpark logical types.

  This package contains all Snowpark logical types.

  Definition Classes
    snowpark
  Since

    0.1.0

-  package udaf
  Definition Classes
    snowpark
-  package udtf
  Definition Classes
    snowpark
- AggregateFunction
- AsyncJob
- CaseExpr
- Column
- CopyableDataFrame
- CopyableDataFrameAsyncActor
- DataFrame
- DataFrameAsyncActor
- DataFrameNaFunctions
- DataFrameReader
- DataFrameStatFunctions
- DataFrameWriter
- DataFrameWriterAsyncActor
- DeleteResult
- FileOperation
- GetResult
- GroupingSets
- HasCachedResult
- MatchedClauseBuilder
- MergeBuilder
- MergeBuilderAsyncActor
- MergeResult
- MergeTypedAsyncJob
- NotMatchedClauseBuilder
- PublicPreview
- PutResult
- RelationalGroupedDataFrame
- Row
- SProcRegistration
- SaveMode
- Session
- SnowparkClientException
- StoredProcedure
- TableFunction
- TypedAsyncJob
- UDAFRegistration
- UDFRegistration
- UDTFRegistration
- Updatable
- UpdatableAsyncActor
- UpdateResult
- UserDefinedFunction
- Window
- WindowSpec
- WriteFileResult
- functions
- tableFunctions

c

com.snowflake.snowpark

# NotMatchedClauseBuilder 

###

#### class NotMatchedClauseBuilder extends AnyRef

Builder for a not matched clause. It provides APIs to build insert actions

Since

  0.7.0

Linear Supertypes
AnyRef, Any
 
Ordering

1. Alphabetic
2. By Inheritance

Inherited

1. NotMatchedClauseBuilder
2. AnyRef
3. Any

1. Hide All
2. Show All

Visibility

1. Public
2. All

### Value Members

1.  final def !=(arg0: Any): Boolean
   Definition Classes
     AnyRef → Any
2.  final def ##(): Int
   Definition Classes
     AnyRef → Any
3.  final def ==(arg0: Any): Boolean
   Definition Classes
     AnyRef → Any
4.  final def asInstanceOf[T0]: T0
   Definition Classes
     Any
5.  def clone(): AnyRef
   Attributes
     protected[lang]
   Definition Classes
     AnyRef
   Annotations
     @throws( ... ) @native() @HotSpotIntrinsicCandidate()
6.  final def eq(arg0: AnyRef): Boolean
   Definition Classes
     AnyRef
7.  def equals(arg0: Any): Boolean
   Definition Classes
     AnyRef → Any
8.  final def getClass(): Class[_]
   Definition Classes
     AnyRef → Any
   Annotations
     @native() @HotSpotIntrinsicCandidate()
9.  def hashCode(): Int
   Definition Classes
     AnyRef → Any
   Annotations
     @native() @HotSpotIntrinsicCandidate()
10.  def insert(assignments: Map[Column, Column]): MergeBuilder

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value.

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value. All unspecified columns are set to NULL. Returns an updated MergeBuilder with the new clause added.

    For example:

        target.merge(source, target("id") === source("id"))
        .whenNotMatched.insert(Map(target("id") -> source("id")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id is assigned to the id of the not matched row.

    returns

      MergeBuilder

    Since

      0.7.0

11.  def insert[T](assignments: Map[String, Column])(implicit arg0: ClassTag[T]): MergeBuilder

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value.

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <assignments>, where the key specifies column name and value specifies its assigned value. All unspecified columns are set to NULL. Returns an updated MergeBuilder with the new clause added.

    For example:

        target.merge(source, target("id") === source("id"))
        .whenNotMatched.insert(Map("id" -> source("id")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id is assigned to the id of the not matched row.

    returns

      MergeBuilder

    Since

      0.7.0

12.  def insert(values: Seq[Column]): MergeBuilder

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <values>.

    Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with <values>. Returns an updated MergeBuilder with the new clause added.

    For example:

        target.merge(source, target("id") === source("id"))
        .whenNotMatched.insert(Seq(source("id"), source("value")))

    Adds a not matched clause where a row in source is not matched if its id does not equal the id of any row in the Updatable target. For all such rows, insert a row into target whose id and value are assigned to the id and value of the not matched row.

    Note: This API inserts into all columns in target with values, so the length of <values> must equal the number of columns in target.

    returns

      MergeBuilder

    Since

      0.7.0

13.  final def isInstanceOf[T0]: Boolean
    Definition Classes
      Any
14.  final def ne(arg0: AnyRef): Boolean
    Definition Classes
      AnyRef
15.  final def notify(): Unit
    Definition Classes
      AnyRef
    Annotations
      @native() @HotSpotIntrinsicCandidate()
16.  final def notifyAll(): Unit
    Definition Classes
      AnyRef
    Annotations
      @native() @HotSpotIntrinsicCandidate()
17.  final def synchronized[T0](arg0: ⇒ T0): T0
    Definition Classes
      AnyRef
18.  def toString(): String
    Definition Classes
      AnyRef → Any
19.  final def wait(arg0: Long, arg1: Int): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws( ... )
20.  final def wait(arg0: Long): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws( ... ) @native()
21.  final def wait(): Unit
    Definition Classes
      AnyRef
    Annotations
      @throws( ... )

### Deprecated Value Members

1.  def finalize(): Unit
   Attributes
     protected[lang]
   Definition Classes
     AnyRef
   Annotations
     @throws( classOf[java.lang.Throwable] ) @Deprecated
   Deprecated

### Inherited from AnyRef

### Inherited from Any

### transform

### Ungrouped