Packages

•  package root

  Definition Classes

  root

•  package com

  Definition Classes

  root

•  package snowflake

  Definition Classes

  com

•  package snowpark

  Definition Classes

  snowflake

•  object functions

  Provides utility functions that generate Column expressions that you can pass to DataFrame transformation methods.

  Provides utility functions that generate Column expressions that you can pass to DataFrame transformation methods. These functions generate references to columns, literals, and SQL expressions (e.g. "c + 1").

  This object also provides functions that correspond to Snowflake system-defined functions (built-in functions), including functions for aggregation and window functions.

  The following examples demonstrate the use of some of these functions:

  // Use columns and literals in expressions.
  df.select(col("c") + lit(1))
  
  // Call system-defined (built-in) functions.
  // This example calls the function that corresponds to the ADD_MONTHS() SQL function.
  df.select(add_months(col("d"), lit(3)))
  
  // Call system-defined functions that have no corresponding function in the functions object.
  // This example calls the RADIANS() SQL function, passing in values from the column "e".
  df.select(callBuiltin("radians", col("e")))
  
  // Call a user-defined function (UDF) by name.
  df.select(callUDF("some_func", col("c")))
  
  // Register and call an anonymous UDF.
  val myudf = udf((x:Int) => x + x)
  df.select(myudf(col("c")))
  
  // Evaluate an SQL expression
  df.select(sqlExpr("c + 1"))

  For functions that accept scala types, e.g. callUdf, callBuiltin, lit(), the mapping from scala types to Snowflake types is as follows:

  String => String
  Byte => TinyInt
  Int => Int
  Short => SmallInt
  Long => BigInt
  Float => Float
  Double => Double
  Decimal => Number
  Boolean => Boolean
  Array => Array
  Timestamp => Timestamp
  Date => Date

  Definition Classes

  snowpark

  Since

  0.1.0

• builtin

com . snowflake . snowpark . functions

builtin 