Package com.snowflake.snowpark_java

Class Functions

java.lang.Object

com.snowflake.snowpark_java.Functions

public final class Functions
extends Object

The static column factories a handler imports as import static com.snowflake.snowpark_java.Functions.*;.

Every one builds a Column over the SQL Frostlake would run for it, so the set is open-ended by construction: anything named here is spelled out, and anything not named is still reachable through callBuiltin(java.lang.String, com.snowflake.snowpark_java.Column...) or sqlExpr(java.lang.String). That is deliberate — Snowpark's own Functions class has hundreds of entries, and mirroring it exhaustively would be a list to maintain rather than behaviour to get right.

Method Summary

Modifier and Type	Method	Description
static Column	abs(Column column)
static Column	avg(Column column)
static Column	callBuiltin(String functionName, Column... arguments)	Any built-in by name, so a function this class does not spell out is still reachable.
static Column	callUDF(String udfName, Column... arguments)	A user-defined function by name.
static Column	ceil(Column column)
static Column	coalesce(Column... columns)
static Column	col(String name)
static Column	column(String name)
static Column	concat(Column... columns)
static Column	count(Column column)
static Column	count_distinct(Column... columns)
static Column	current_date()
static Column	current_timestamp()
static Column	floor(Column column)
static Column	iff(Column condition, Column whenTrue, Column whenFalse)
static Column	length(Column column)
static Column	lit(Object value)	A literal.
static Column	lower(Column column)
static Column	max(Column column)
static Column	mean(Column column)
static Column	min(Column column)
static Column	round(Column column)
static Column	sqlExpr(String sql)	Raw SQL, passed through untouched.
static Column	stddev(Column column)
static Column	substring(Column column, Column start, Column count)
static Column	sum(Column column)
static Column	to_date(Column column)
static Column	trim(Column column)
static Column	upper(Column column)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Details

col

public static Column col(String name)

column

public static Column column(String name)

sqlExpr

public static Column sqlExpr(String sql)

Raw SQL, passed through untouched.

lit

public static Column lit(Object value)

A literal. Strings are quoted the way the engine's own decoder expects, so an apostrophe in the value cannot end the literal early.

count

public static Column count(Column column)

sum

public static Column sum(Column column)

avg

public static Column avg(Column column)

mean

public static Column mean(Column column)

min

public static Column min(Column column)

max

public static Column max(Column column)

stddev

public static Column stddev(Column column)

count_distinct

public static Column count_distinct(Column... columns)

upper

public static Column upper(Column column)

lower

public static Column lower(Column column)

trim

public static Column trim(Column column)

length

public static Column length(Column column)

concat

public static Column concat(Column... columns)

substring

public static Column substring(Column column,
 Column start,
 Column count)

abs

public static Column abs(Column column)

round

public static Column round(Column column)

floor

public static Column floor(Column column)

ceil

public static Column ceil(Column column)

coalesce

public static Column coalesce(Column... columns)

iff

public static Column iff(Column condition,
 Column whenTrue,
 Column whenFalse)

current_date

public static Column current_date()

current_timestamp

public static Column current_timestamp()

to_date

public static Column to_date(Column column)

callBuiltin

public static Column callBuiltin(String functionName,
 Column... arguments)

Any built-in by name, so a function this class does not spell out is still reachable.

callUDF

public static Column callUDF(String udfName,
 Column... arguments)

A user-defined function by name. Identical in shape to callBuiltin(java.lang.String, com.snowflake.snowpark_java.Column...); kept for the API.