Uses of Class com.snowflake.snowpark_java.Column (Snowpark Java API Reference 1.15.0)

Packages that use Column
Package Description

com.snowflake.snowpark_java
Provides most of the classes for the Snowpark Java API.

Packages that use Column
Package	Description
com.snowflake.snowpark_java	Provides most of the classes for the Snowpark Java API.

Uses of Column in com.snowflake.snowpark_java

Subclasses of Column in com.snowflake.snowpark_java
Modifier and Type	Class	Description
`class`	`CaseExpr`	Represents a CASE expression.

Methods in com.snowflake.snowpark_java that return Column
Modifier and Type	Method	Description
`static Column`	Functions.`abs(Column col)`	Returns the absolute value of a numeric expression.
`static Column`	Functions.`acos(Column col)`	Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`add_months(Column startDate, Column numMonths)`	Adds or subtracts a specified number of months to a date or timestamp, preserving the end-of-month information.
`Column`	Column.`alias(String alias)`	Retrieves s new renamed Column.
`Column`	Column.`and(Column other)`	And.
`static Column`	Functions.`any_value(Column e)`	Returns a non-deterministic value for the specified column.
`Column`	UserDefinedFunction.`apply(Column... exprs)`	Apply the UDF to one or more columns to generate a Column expression.
`static Column`	Functions.`approx_count_distinct(Column col)`	Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e.
`static Column`	Functions.`approx_percentile(Column col, double percentile)`	Returns an approximated value for the desired percentile.
`static Column`	Functions.`approx_percentile_accumulate(Column col)`	Returns the internal representation of the t-Digest state (as a JSON object) at the end of aggregation.
`static Column`	Functions.`approx_percentile_combine(Column state)`	Combines (merges) percentile input states into a single output state.
`static Column`	Functions.`approx_percentile_estimate(Column col, double percentile)`	Returns the desired approximated percentile value for the specified t-Digest state.
`static Column`	Functions.`array(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs.
`static Column`	Functions.`array_agg(Column col)`	Returns the input values, pivoted into an ARRAY.
`static Column`	Functions.`array_append(Column array, Column element)`	Returns an ARRAY containing all elements from the source ARRAYas well as the new element.
`static Column`	Functions.`array_cat(Column array1, Column array2)`	Returns the concatenation of two ARRAYs.
`static Column`	Functions.`array_compact(Column array)`	Returns a compacted ARRAY with missing and null values removed, effectively converting sparse arrays into dense arrays.
`static Column`	Functions.`array_construct(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs.
`static Column`	Functions.`array_construct_compact(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs; the constructed ARRAY omits any NULL input values.
`static Column`	Functions.`array_contains(Column variant, Column array)`	Returns `true` if the specified VARIANT is found in the specified ARRAY.
`static Column`	Functions.`array_insert(Column array, Column pos, Column element)`	Returns an ARRAY containing all elements from the source ARRAY as well as the new element.
`static Column`	Functions.`array_intersection(Column col1, Column col2)`	Returns an ARRAY that contains the matching elements in the two input ARRAYs.
`static Column`	Functions.`array_position(Column variant, Column array)`	Returns the index of the first occurrence of an element in an ARRAY.
`static Column`	Functions.`array_prepend(Column array, Column element)`	Returns an ARRAY containing the new element as well as all elements from the source ARRAY.
`static Column`	Functions.`array_size(Column array)`	Returns the size of the input ARRAY.
`static Column`	Functions.`array_slice(Column array, Column from, Column to)`	Returns an ARRAY constructed from a specified subset of elements of the input ARRAY.
`static Column`	Functions.`array_to_string(Column array, Column separator)`	Returns an input ARRAY converted to a string by casting all values to strings (using TO_VARCHAR) and concatenating them (using the string from the second argument to separate the elements).
`static Column`	Functions.`arrays_overlap(Column a1, Column a2)`	Compares whether two arrays have at least one element in common.
`Column`	Column.`as(String alias)`	Retrieves s new renamed Column.
`static Column`	Functions.`as_array(Column variant)`	Casts a VARIANT value to an array.
`static Column`	Functions.`as_binary(Column variant)`	Casts a VARIANT value to a binary string.
`static Column`	Functions.`as_char(Column variant)`	Casts a VARIANT value to a string.
`static Column`	Functions.`as_date(Column variant)`	Casts a VARIANT value to a date.
`static Column`	Functions.`as_decimal(Column variant)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
`static Column`	Functions.`as_decimal(Column variant, int precision)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
`static Column`	Functions.`as_decimal(Column variant, int precision, int scale)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
`static Column`	Functions.`as_double(Column variant)`	Casts a VARIANT value to a floating-point value.
`static Column`	Functions.`as_integer(Column variant)`	Casts a VARIANT value to an integer.
`static Column`	Functions.`as_number(Column variant)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
`static Column`	Functions.`as_number(Column variant, int precision)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
`static Column`	Functions.`as_number(Column variant, int precision, int scale)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
`static Column`	Functions.`as_object(Column variant)`	Casts a VARIANT value to an object.
`static Column`	Functions.`as_real(Column variant)`	Casts a VARIANT value to a floating-point value.
`static Column`	Functions.`as_time(Column variant)`	Casts a VARIANT value to a time value.
`static Column`	Functions.`as_timestamp_ltz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with local timezone.
`static Column`	Functions.`as_timestamp_ntz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with no timezone.
`static Column`	Functions.`as_timestamp_tz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with timezone.
`static Column`	Functions.`as_varchar(Column variant)`	Casts a VARIANT value to a string.
`Column`	Column.`asc()`	Sorts this column in ascending order.
`static Column`	Functions.`asc(String name)`	Returns a Column expression with values sorted in ascending order.
`Column`	Column.`asc_nulls_first()`	Sorts this column in ascending order, null values sorted before non-null values.
`Column`	Column.`asc_nulls_last()`	Sorts this column in ascending order, null values sorted after non-null values.
`static Column`	Functions.`ascii(Column e)`	Returns the ASCII code for the first character of a string.
`static Column`	Functions.`asin(Column col)`	Computes the inverse sine (arc sine) of its argument; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`atan(Column col)`	Computes the inverse tangent (arc tangent) of its argument; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`atan2(Column y, Column x)`	Computes the inverse tangent (arc tangent) of the ratio of its two arguments.
`static Column`	Functions.`avg(Column col)`	Returns the average of non-NULL records.
`static Column`	Functions.`base64(Column c)`	Computes the BASE64 encoding of a column and returns it as a string column.
`Column`	Column.`between(Column lowerBound, Column upperBound)`	Between lower bound (including) and upper bound (including).
`Column`	Column.`bitand(Column other)`	Bitwise and.
`static Column`	Functions.`bitnot(Column col)`	Returns the bitwise negation of a numeric expression.
`Column`	Column.`bitor(Column other)`	Bitwise or.
`static Column`	Functions.`bitshiftleft(Column e, Column numBits)`	Shifts the bits for a numeric expression numBits positions to the left.
`static Column`	Functions.`bitshiftright(Column e, Column numBits)`	Shifts the bits for a numeric expression numBits positions to the right.
`Column`	Column.`bitxor(Column other)`	Bitwise xor.
`Column`	TableFunction.`call(Column... args)`	Create a Column reference by passing arguments in the TableFunction object.
`Column`	TableFunction.`call(Map<String,Column> args)`	Create a Column reference by passing arguments in the TableFunction object.
`static Column`	Functions.`callUDF(String udfName, Column... cols)`	Calls a user-defined function (UDF) by name.
`Column`	Column.`cast(DataType to)`	Casts the values in the Column to the specified data type.
`static Column`	Functions.`ceil(Column col)`	Returns values from the specified column rounded to the nearest equal or larger integer.
`static Column`	Functions.`charindex(Column targetExpr, Column sourceExpr)`	Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
`static Column`	Functions.`charindex(Column targetExpr, Column sourceExpr, Column position)`	Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
`static Column`	Functions.`check_json(Column col)`	Checks the validity of a JSON document.
`static Column`	Functions.`check_xml(Column col)`	Checks the validity of an XML document.
`static Column`	Functions.`chr(Column col)`	Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode.
`static Column`	Functions.`coalesce(Column... cols)`	Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.
`Column`	DataFrame.`col(String colName)`	Retrieves a reference to a column in this DataFrame.
`static Column`	Functions.`col(DataFrame df)`	Generates a Column representing the result of the input DataFrame.
`static Column`	Functions.`col(String name)`	Creates a Column with the specified name.
`Column`	Column.`collate(String collateSpec)`	Returns a copy of the original Column with the specified 'collateSpec` property, rather than the original collation specification property.
`static Column`	Functions.`collate(Column expr, String collationSpec)`	Returns a copy of expr, but with the specified collationSpec property instead of the original collation specification property.
`static Column`	Functions.`collation(Column expr)`	Returns the collation specification of expr.
`static Column`	Functions.`collect_list(Column c)`	Returns the input values, pivoted into an ARRAY.
`static Column`	Functions.`collect_set(Column e)`	Aggregate function: returns a set of objects with duplicate elements eliminated.
`static Column`	Functions.`collect_set(String e)`	Aggregate function: returns a set of objects with duplicate elements eliminated.
`static Column`	Functions.`concat(Column... exprs)`	Concatenates one or more strings, or concatenates one or more binary values.
`static Column`	Functions.`concat_ws(Column separator, Column... exprs)`	Concatenates two or more strings, or concatenates two or more binary values.
`static Column`	Functions.`contains(Column col, Column str)`	Returns true if col contains str.
`static Column`	Functions.`convert_timezone(Column targetTimeZone, Column sourceTimestamp)`	Converts the given sourceTimestampNTZ to targetTimeZone.
`static Column`	Functions.`convert_timezone(Column sourceTimeZone, Column targetTimeZone, Column sourceTimestampNTZ)`	Converts the given sourceTimestampNTZ from sourceTimeZone to targetTimeZone.
`static Column`	Functions.`corr(Column col1, Column col2)`	Returns the correlation coefficient for non-null pairs in a group.
`static Column`	Functions.`cos(Column col)`	Computes the cosine of its argument; the argument should be expressed in radians.
`static Column`	Functions.`cosh(Column col)`	Computes the hyperbolic cosine of its argument.
`static Column`	Functions.`count(Column col)`	Returns either the number of non-NULL records for the specified columns, or the total number of records.
`static Column`	Functions.`count_distinct(Column first, Column... remaining)`	Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
`static Column`	Functions.`countDistinct(Column first, Column... remaining)`	Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
`static Column`	Functions.`countDistinct(String first, String... remaining)`	Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
`static Column`	Functions.`covar_pop(Column col1, Column col2)`	Calculates the population covariance for non-null pairs in a group.
`static Column`	Functions.`covar_samp(Column col1, Column col2)`	Calculates the sample covariance for non-null pairs in a group.
`static Column`	Functions.`cume_dist()`	Finds the cumulative distribution of a value with regard to other values within the same window partition.
`static Column`	Functions.`current_account()`	Returns the account used by the user's current session.
`static Column`	Functions.`current_available_roles()`	Returns a JSON string that lists all roles granted to the current user.
`static Column`	Functions.`current_database()`	Returns the name of the database in use for the current session.
`static Column`	Functions.`current_date()`	Returns the current date of the system.
`static Column`	Functions.`current_region()`	Returns the name of the region for the account where the current user is logged in.
`static Column`	Functions.`current_role()`	Returns the name of the role in use for the current session.
`static Column`	Functions.`current_schema()`	Returns the name of the schema in use by the current session.
`static Column`	Functions.`current_schemas()`	Returns active search path schemas.
`static Column`	Functions.`current_session()`	Returns a unique system identifier for the Snowflake session corresponding to the present connection.
`static Column`	Functions.`current_statement()`	Returns the SQL text of the statement that is currently executing.
`static Column`	Functions.`current_time()`	Returns the current time for the system.
`static Column`	Functions.`current_timestamp()`	Returns the current timestamp for the system.
`static Column`	Functions.`current_user()`	Returns the name of the user currently logged into the system.
`static Column`	Functions.`current_version()`	Returns the current Snowflake version.
`static Column`	Functions.`current_warehouse()`	Returns the name of the warehouse in use for the current session.
`static Column`	Functions.`date_add(Column start, Column days)`	Returns the date that is `days` days after `start` Usage - DATE_ADD( date_or_time_part, value, date_or_time_expr )
`static Column`	Functions.`date_add(Integer days, Column start)`	Returns the date that is `days` days after `start` Usage - DATE_ADD( date_or_time_part, value, date_or_time_expr )
`static Column`	Functions.`date_format(Column col, String s)`	Converts an input expression into the corresponding date in the specified date format.
`static Column`	Functions.`date_from_parts(Column year, Column month, Column day)`	Creates a date from individual numeric components that represent the year, month, and day of the month.
`static Column`	Functions.`date_trunc(String format, Column timestamp)`	Truncates a DATE, TIME, or TIMESTAMP to the specified precision.
`static Column`	Functions.`dateadd(String part, Column value, Column expr)`	Adds the specified value for the specified date or time art to date or time expr.
`static Column`	Functions.`datediff(String part, Column col1, Column col2)`	Calculates the difference between two date, time, or timestamp columns based on the date or time part requested.
`static Column`	Functions.`dayname(Column expr)`	Extracts the three-letter day-of-week name from the specified date or timestamp.
`static Column`	Functions.`dayofmonth(Column e)`	Extracts the day of month from a date or timestamp.
`static Column`	Functions.`dayofweek(Column e)`	Extracts the day of week from a date or timestamp.
`static Column`	Functions.`dayofyear(Column e)`	Extracts the day of year from a date or timestamp.
`static Column`	Functions.`degrees(Column e)`	Converts radians to degrees.
`static Column`	Functions.`dense_rank()`	Returns the rank of a value within a group of values, without gaps in the ranks.
`Column`	Column.`desc()`	Sorts this column in descending order.
`static Column`	Functions.`desc(String name)`
`Column`	Column.`desc_nulls_first()`	Sorts this column in descending order, null values sorted before non-null values.
`Column`	Column.`desc_nulls_last()`	Sorts this column in descending order, null values sorted after non-null values.
`static Column`	Functions.`div0(Column dividend, Column divisor)`	Performs division like the division operator (/), but returns 0 when the divisor is 0 (rather than reporting an error).
`Column`	Column.`divide(Column other)`	Divide
`static Column`	Functions.`endswith(Column expr, Column str)`	Returns TRUE if expr ends with str.
`Column`	Column.`equal_nan()`	Is NaN.
`static Column`	Functions.`equal_nan(Column col)`	Returns true if the value in the column is not a number (NaN).
`Column`	Column.`equal_null(Column other)`	Equal to.
`Column`	Column.`equal_to(Column other)`	Equal to.
`static Column`	Functions.`exp(Column col)`	Computes Euler's number e raised to a floating-point value.
`static Column`	TableFunctions.`explode(Column input)`	Flattens a given array or map type column into individual rows.
`static Column`	Functions.`expr(String s)`	Creates a Column expression from row SQL text.
`static Column`	Functions.`factorial(Column col)`	Computes the factorial of its input.
`static Column`	TableFunctions.`flatten(Column input)`	Flattens (explodes) compound values into multiple rows.
`static Column`	TableFunctions.`flatten(Column input, String path, boolean outer, boolean recursive, String mode)`	Flattens (explodes) compound values into multiple rows.
`static Column`	Functions.`floor(Column col)`	Returns values from the specified column rounded to the nearest equal or smaller integer.
`static Column`	Functions.`format_number(Column x, Integer d)`	Formats numeric column x to a format like '#,###,###.##', rounded to d decimal places with HALF_EVEN round mode, and returns the result as a string column.
`static Column`	Functions.`from_unixtime(Column ut)`	Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the yyyy-MM-dd HH:mm:ss format.
`static Column`	Functions.`from_unixtime(Column ut, String f)`	Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the given format.
`static Column`	Functions.`from_utc_timestamp(Column ts)`	Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in UTC, and renders that time as a timestamp in the given time zone.
`Column`	Column.`geq(Column other)`	Greater than or equal to.
`static Column`	Functions.`get(Column col1, Column col2)`	Extracts a value from an object or array; returns NULL if either of the arguments is NULL.
`static Column`	Functions.`get_ignore_case(Column obj, Column field)`	Extracts a field value from an object; returns NULL if either of the arguments is NULL.
`static Column`	Functions.`get_path(Column col, Column path)`	Extracts a value from semi-structured data using a path name.
`static Column`	Functions.`greatest(Column... cols)`	Returns the largest value from a list of expressions.
`static Column`	Functions.`grouping(Column col)`	Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
`static Column`	Functions.`grouping_id(Column... cols)`	Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
`Column`	Column.`gt(Column other)`	Greater than.
`static Column`	Functions.`hash(Column... cols)`	Returns a signed 64-bit hash value.
`static Column`	Functions.`hex(Column c)`	Computes hex value of the given column.
`static Column`	Functions.`hour(Column e)`	Extracts the hour from a date or timestamp.
`static Column`	Functions.`iff(Column condition, Column expr1, Column expr2)`	Returns one of two specified expressions, depending on a condition.
`Column`	Column.`in(DataFrame df)`	Returns a conditional expression that you can pass to the filter or where method to perform a WHERE ...
`Column`	Column.`in(Object... values)`	Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
`static Column`	Functions.`in(Column[] columns, DataFrame df)`	Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
`static Column`	Functions.`in(Column[] columns, List<List<Object>> values)`	Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
`static Column`	Functions.`initcap(Column e)`	Returns the input string with the first letter of each word in uppercase and the subsequent letters in lowercase.
`static Column`	Functions.`insert(Column baseExpr, Column position, Column length, Column insertExpr)`	Replaces a substring of the specified length, starting at the specified position, with a new string or binary value.
`static Column`	Functions.`instr(Column str, String substring)`	Locate the position of the first occurrence of substr column in the given string.
`static Column`	Functions.`is_array(Column col)`	Returns true if the specified VARIANT column contains an ARRAY value.
`static Column`	Functions.`is_binary(Column col)`	Returns true if the specified VARIANT column contains a binary value.
`static Column`	Functions.`is_boolean(Column col)`	Returns true if the specified VARIANT column contains a Boolean value.
`static Column`	Functions.`is_char(Column col)`	Returns true if the specified VARIANT column contains a string value.
`static Column`	Functions.`is_date(Column col)`	Returns true if the specified VARIANT column contains a DATE value.
`static Column`	Functions.`is_date_value(Column col)`	Returns true if the specified VARIANT column contains a DATE value.
`static Column`	Functions.`is_decimal(Column col)`	Returns true if the specified VARIANT column contains a fixed-point decimal value or integer.
`static Column`	Functions.`is_double(Column col)`	Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
`static Column`	Functions.`is_integer(Column col)`	Returns true if the specified VARIANT column contains an integer value.
`Column`	Column.`is_not_null()`	Is not null.
`Column`	Column.`is_null()`	Is null.
`static Column`	Functions.`is_null(Column col)`	Returns true if the value in the column is null.
`static Column`	Functions.`is_null_value(Column col)`	Returns true if the specified VARIANT column is a JSON null value.
`static Column`	Functions.`is_object(Column col)`	Returns true if the specified VARIANT column contains an OBJECT value.
`static Column`	Functions.`is_real(Column col)`	Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
`static Column`	Functions.`is_time(Column col)`	Returns true if the specified VARIANT column contains a TIME value.
`static Column`	Functions.`is_timestamp_ltz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value to be interpreted using the local time zone.
`static Column`	Functions.`is_timestamp_ntz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value with no time zone.
`static Column`	Functions.`is_timestamp_tz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value with a time zone.
`static Column`	Functions.`is_varchar(Column col)`	Returns true if the specified VARIANT column contains a string value.
`static Column`	Functions.`isnull(Column c)`	Wrapper for Snowflake built-in isnull function.
`Column`	Column.`isNull()`	Wrapper for is_null function.
`static Column`	Functions.`json_extract_path_text(Column col, Column path)`	Parses a JSON string and returns the value of an element at a specified path in the resulting JSON document.
`static Column`	Functions.`kurtosis(Column col)`	Returns the population excess kurtosis of non-NULL records.
`static Column`	Functions.`lag(Column col)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`lag(Column col, int offset)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`lag(Column col, int offset, Column defaultValue)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`last(Column col)`	Returns the last value of the column in a group.
`static Column`	Functions.`last_day(Column e)`	Returns the last day of the specified date part for a date or timestamp.
`static Column`	Functions.`lead(Column col)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`lead(Column col, int offset)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`lead(Column col, int offset, Column defaultValue)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`least(Column... cols)`	Returns the smallest value from a list of expressions.
`static Column`	Functions.`left(Column strExpr, Column lengthExpr)`	Returns a left most substring of strExpr.
`static Column`	Functions.`length(Column e)`	Returns the length of an input string or binary value.
`Column`	Column.`leq(Column other)`	Less than or equal to.
`Column`	Column.`like(Column pattern)`	Allows case-sensitive matching of strings based on comparison with a pattern.
`static Column`	Functions.`listagg(Column col)`	Returns the concatenated input values, separated by empty string.
`static Column`	Functions.`listagg(Column col, String delimiter)`	Returns the concatenated input values, separated by `delimiter` string.
`static Column`	Functions.`listagg(Column col, String delimiter, boolean isDistinct)`	Returns the concatenated input values, separated by `delimiter` string.
`static Column`	Functions.`lit(Object literal)`	Creates a Column expression for a literal value.
`static Column`	Functions.`locate(Column substr, Column str, int pos)`	Locate the position of the first occurrence of substr in a string column, after position pos.
`static Column`	Functions.`locate(String substr, Column str)`	Locate the position of the first occurrence of substr in a string column, after position pos.
`static Column`	Functions.`log(Column base, Column a)`	Returns the logarithm of a numeric expression.
`static Column`	Functions.`log10(Column col)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`log10(String s)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`log1p(Column col)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`log1p(String s)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`lower(Column e)`	Returns the input string with all characters converted to lowercase.
`static Column`	Functions.`lpad(Column str, Column len, Column pad)`	Left-pads a string with characters from another string, or left-pads a binary value with bytes from another binary value.
`Column`	Column.`lt(Column other)`	Less than.
`static Column`	Functions.`ltrim(Column e)`	Removes leading characters, including whitespace, from a string.
`static Column`	Functions.`ltrim(Column e, Column trimString)`	Removes leading characters, including whitespace, from a string.
`static Column`	Functions.`max(Column col)`	Returns the maximum value for the records in a group.
`static Column`	Functions.`max(String colName)`	Returns the maximum value for the records in a group.
`static Column`	Functions.`md5(Column e)`	Returns a 32-character hex-encoded string containing the 128-bit MD5 message digest.
`static Column`	Functions.`mean(Column col)`	Returns the average of non-NULL records.
`static Column`	Functions.`mean(String colName)`	Returns the average of non-NULL records.
`static Column`	Functions.`median(Column col)`	Returns the median value for the records in a group.
`static Column`	Functions.`min(Column col)`	Returns the minimum value for the records in a group.
`static Column`	Functions.`min(String colName)`	Returns the minimum value for the records in a group.
`Column`	Column.`minus(Column other)`	Minus
`static Column`	Functions.`minute(Column e)`	Extracts the minute from a date or timestamp.
`Column`	Column.`mod(Column other)`	Remainder
`static Column`	Functions.`monotonically_increasing_id()`	A column expression that generates monotonically increasing 64-bit integers.
`static Column`	Functions.`month(Column e)`	Extracts the month from a date or timestamp.
`static Column`	Functions.`monthname(Column expr)`	Extracts the three-letter month name from the specified date or timestamp.
`static Column`	Functions.`months_between(String end, String start)`	Returns number of months between dates `start` and `end`.
`Column`	Column.`multiply(Column other)`	Multiply
`static Column`	Functions.`negate(Column col)`	Returns the negation of the value in the column (equivalent to a unary minus).
`static Column`	Functions.`next_day(Column date, Column dayOfWeek)`	Returns the date of the first specified DOW (day of week) that occurs after the input date.
`static Column`	Functions.`not(Column col)`	Returns the inverse of a boolean expression.
`Column`	Column.`not_equal(Column other)`	Not equal to.
`static Column`	Functions.`ntile(int n)`	Window function: returns the ntile group id (from 1 to `n` inclusive) in an ordered window partition.
`static Column`	Functions.`ntile(Column col)`	Divides an ordered data set equally into the number of buckets specified by n.
`static Column`	Functions.`object_construct(Column... key_values)`	Returns an OBJECT constructed from the arguments.
`static Column`	Functions.`object_delete(Column obj, Column key1, Column... keys)`	Returns an object containing the contents of the input (i.e.source) object with one or more keys removed.
`static Column`	Functions.`object_insert(Column obj, Column key, Column value)`	Returns an object consisting of the input object with a new key-value pair inserted.
`static Column`	Functions.`object_insert(Column obj, Column key, Column value, Column update_flag)`	Returns an object consisting of the input object with a new key-value pair inserted (or an existing key updated with a new value).
`static Column`	Functions.`object_keys(Column obj)`	Returns an array containing the list of keys in the input object.
`static Column`	Functions.`object_pick(Column obj, Column key1, Column... keys)`	Returns a new OBJECT containing some of the key-value pairs from an existing object.
`static Column`	Functions.`objectagg(Column key, Column value)`	Returns one OBJECT per group.
`Column`	Column.`or(Column other)`	Or.
`Column`	CaseExpr.`otherwise(Column value)`	Sets the default result for this CASE expression.
`Column`	Column.`over()`	Returns a windows frame, based on the specified WindowSpec.
`Column`	Column.`over(WindowSpec windowSpec)`	Returns a windows frame, based on the specified WindowSpec.
`static Column`	Functions.`parse_json(Column col)`	Parse the value of the specified column as a JSON string and returns the resulting JSON document.
`static Column`	Functions.`parse_xml(Column col)`	Parse the value of the specified column as a JSON string and returns the resulting XML document.
`static Column`	Functions.`percent_rank()`	Returns the relative rank of a value within a group of values, specified as a percentage ranging from 0.0 to 1.0.
`Column`	Column.`plus(Column other)`	Plus
`static Column`	Functions.`pow(Column l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Column l, Double r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Column l, String r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Double l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Double l, String r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(String l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(String l, Double r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(String l, String r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`previous_day(Column date, Column dayOfWeek)`	Returns the date of the first specified DOW (day of week) that occurs before the input date.
`static Column`	Functions.`quarter(Column e)`	Extracts the quarter from a date or timestamp.
`static Column`	Functions.`radians(Column e)`	Converts degrees to radians.
`static Column`	Functions.`randn()`	Generate a column with independent and identically distributed (i.i.d.) samples from the standard normal distribution.
`static Column`	Functions.`randn(long seed)`	Generate a column with independent and identically distributed (i.i.d.) samples from the standard normal distribution.
`static Column`	Functions.`random()`	Each call returns a pseudo-random 64-bit integer.
`static Column`	Functions.`random(long seed)`	Each call returns a pseudo-random 64-bit integer.
`static Column`	Functions.`rank()`	Returns the rank of a value within an ordered group of values.
`Column`	Column.`regexp(Column pattern)`	Returns true if this column matches the specified regular expression.
`static Column`	Functions.`regexp_count(Column strExpr, Column pattern)`	Returns the number of times that a pattern occurs in a strExpr.
`static Column`	Functions.`regexp_count(Column strExpr, Column pattern, Column position, Column parameters)`	Returns the number of times that a pattern occurs in a strExpr.
`static Column`	Functions.`regexp_extract(Column col, String exp, Integer position, Integer Occurences, Integer grpIdx)`	Signature - snowflake.snowpark.functions.regexp_extract (value: Union[Column, str], regexp: Union[Column, str], idx: int) Column Extract a specific group matched by a regex, from the specified string column.
`static Column`	Functions.`regexp_replace(Column strExpr, Column pattern)`	Returns the subject with the specified pattern (or all occurrences of the pattern) removed.
`static Column`	Functions.`regexp_replace(Column strExpr, Column pattern, Column replacement)`	Returns the subject with the specified pattern (or all occurrences of the pattern) replaced by a replacement string.
`static Column`	Functions.`repeat(Column str, Column n)`	Builds a string by repeating the input for the specified number of times.
`static Column`	Functions.`replace(Column strExpr, Column pattern)`	Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
`static Column`	Functions.`replace(Column strExpr, Column pattern, Column replacement)`	Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
`static Column`	Functions.`reverse(Column name)`	Wrapper for Snowflake built-in reverse function.
`static Column`	Functions.`right(Column strExpr, Column lengthExpr)`	Returns a right most substring of strExpr.
`static Column`	Functions.`round(Column e)`	Rounds the numeric values of the given column `e` to 0 decimal places using the half away from zero rounding mode.
`static Column`	Functions.`round(Column e, int scale)`	Rounds the numeric values of the given column `e` to the `scale` decimal places using the half away from zero rounding mode.
`static Column`	Functions.`round(Column e, Column scale)`	Rounds the numeric values of the given column `e` to the `scale` decimal places using the half away from zero rounding mode.
`static Column`	Functions.`row_number()`	Returns a unique row number for each row within a window partition.
`static Column`	Functions.`rpad(Column str, Column len, Column pad)`	Right-pads a string with characters from another string, or right-pads a binary value with bytes from another binary value.
`static Column`	Functions.`rtrim(Column e)`	Removes trailing characters, including whitespace, from a string.
`static Column`	Functions.`rtrim(Column e, Column trimString)`	Removes trailing characters, including whitespace, from a string.
`static Column`	Functions.`second(Column e)`	Extracts the second from a date or timestamp.
`static Column`	Functions.`seq1()`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq1(boolean startsFromZero)`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq2()`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq2(boolean startsFromZero)`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq4()`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq4(boolean startsFromZero)`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq8()`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`seq8(boolean startsFromZero)`	Generates a sequence of monotonically increasing integers, with wrap-around.
`static Column`	Functions.`sha1(Column e)`	Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest.
`static Column`	Functions.`sha2(Column e, int numBits)`	Returns a hex-encoded string containing the N-bit SHA-2 message digest, where N is the specified output digest size.
`static Column`	Functions.`shiftleft(Column c, int numBits)`	Shift the given value numBits left.
`static Column`	Functions.`shiftright(Column c, int numBits)`	Shift the given value numBits right.
`static Column`	Functions.`sign(Column col)`	Returns the sign of its argument:
`static Column`	Functions.`signum(Column col)`	Returns the sign of its argument:
`static Column`	Functions.`sin(Column e)`	Computes the sine of its argument; the argument should be expressed in radians.
`static Column`	Functions.`sinh(Column e)`	Computes the hyperbolic sine of its argument.
`static Column`	Functions.`size(Column col)`	Returns the size of the input ARRAY.
`static Column`	Functions.`skew(Column col)`	Returns the sample skewness of non-NULL records.
`static Column`	Functions.`soundex(Column e)`	Returns a string that contains a phonetic representation of the input string.
`static Column`	Functions.`split(Column str, Column pattern)`	Splits a given string with a given separator and returns the result in an array of strings.
`static Column`	TableFunctions.`split_to_table(Column str, String delimiter)`	This table function splits a string (based on a specified delimiter) and flattens the results into rows.
`static Column`	Functions.`sqlExpr(String sqlText)`	Creates a Column expression from row SQL text.
`static Column`	Functions.`sqrt(Column col)`	Returns the square-root of a non-negative numeric expression.
`static Column`	Functions.`startswith(Column col, Column str)`	Returns true if col starts with str.
`static Column`	Functions.`stddev(Column col)`	Returns the sample standard deviation (square root of sample variance) of non-NULL values.
`static Column`	Functions.`stddev_pop(Column col)`	Returns the population standard deviation (square root of variance) of non-NULL values.
`static Column`	Functions.`stddev_samp(Column col)`	Returns the sample standard deviation (square root of sample variance) of non-NULL values.
`static Column`	Functions.`strip_null_value(Column col)`	Converts a JSON "null" value in the specified column to a SQL NULL value.
`static Column`	Functions.`strtok_to_array(Column array)`	Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
`static Column`	Functions.`strtok_to_array(Column array, Column delimiter)`	Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
`Column`	Column.`subField(int index)`	Retrieves the element (field) at the specified index in a column that contains semi-structured data.
`Column`	Column.`subField(String field)`	Retrieves the specified element (field) in a column that contains semi-structured data.
`static Column`	Functions.`substring(Column str, Column pos, Column len)`	Returns the portion of the string or binary value str, starting from the character/byte specified by pos, with limited length.
`static Column`	Functions.`substring_index(String col, String delim, Integer count)`	Returns the substring from string str before count occurrences of the delimiter delim.
`static Column`	Functions.`sum(Column col)`	Returns the sum of non-NULL records in a group.
`static Column`	Functions.`sum(String colName)`	Returns the sum of non-NULL records in a group.
`static Column`	Functions.`sum_distinct(Column col)`	Returns the sum of non-NULL distinct records in a group.
`static Column`	Functions.`sysdate()`	Returns the current timestamp for the system, but in the UTC time zone.
`static Column`	Functions.`tan(Column e)`	Computes the tangent of its argument; the argument should be expressed in radians.
`static Column`	Functions.`tanh(Column e)`	Computes the hyperbolic tangent of its argument.
`static Column`	Functions.`time_from_parts(Column hour, Column minute, Column second)`	Creates a time from individual numeric components.
`static Column`	Functions.`time_from_parts(Column hour, Column minute, Column second, Column nanosecond)`	Creates a time from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column dateExpr, Column timeExpr)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ltz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ltz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column dateExpr, Column timeExpr)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond, Column timezone)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`to_array(Column col)`	Converts the input expression into an array:
`static Column`	Functions.`to_date(Column e)`	Converts an input expression to a date.
`static Column`	Functions.`to_date(Column e, Column fmt)`	Converts an input expression to a date.
`static Column`	Functions.`to_decimal(Column expr, int precision, int scale)`	Converts an input expression to a decimal
`static Column`	Functions.`to_json(Column col)`	Converts any VARIANT value to a string containing the JSON representation of the value.
`static Column`	Functions.`to_object(Column col)`	Converts the input value to an object:
`static Column`	Functions.`to_timestamp(Column s)`	Converts an input expression into the corresponding timestamp.
`static Column`	Functions.`to_timestamp(Column s, Column fmt)`	Converts an input expression into the corresponding timestamp.
`static Column`	Functions.`to_utc_timestamp(Column ts)`	Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in the given time zone, and renders that time as a timestamp in UTC.
`static Column`	Functions.`to_variant(Column col)`	Converts any value to VARIANT value or NULL (if input is NULL).
`static Column`	Functions.`to_xml(Column col)`	Converts any VARIANT value to a string containing the XML representation of the value.
`static Column`	Functions.`toScalar(DataFrame df)`	Generates a Column representing the result of the input DataFrame.
`static Column`	Functions.`translate(Column src, Column matchingString, Column replaceString)`	Translates src from the characters in matchingString to the characters in replaceString.
`static Column`	Functions.`trim(Column e, Column trimString)`	Removes leading and trailing characters from a string.
`static Column`	Functions.`trunc(Column expr, Column scale)`	Rounds the input expression down to the nearest (or equal) integer closer to zero, or to the nearest equal or smaller value with the specified number of places after the decimal point.
`Column`	Column.`unary_minus()`	Unary minus.
`Column`	Column.`unary_not()`	Unary not.
`static Column`	Functions.`unbase64(Column c)`	Decodes a BASE64 encoded string column and returns it as a column.
`static Column`	Functions.`unhex(Column c)`	Inverse of hex.
`static Column`	Functions.`uniform(Column min, Column max, Column gen)`	Returns a uniformly random number, in the inclusive range (`min`, `max`)
`static Column`	Functions.`unix_timestamp(Column c)`	Returns the current Unix timestamp (in seconds) as a long.
`static Column`	Functions.`upper(Column e)`	Returns the input string with all characters converted to uppercase.
`static Column`	Functions.`var_pop(Column col)`	Returns the population variance of non-NULL records in a group.
`static Column`	Functions.`var_samp(Column col)`	Returns the sample variance of non-NULL records in a group.
`static Column`	Functions.`variance(Column col)`	Returns the sample variance of non-NULL records in a group.
`static Column`	Functions.`weekofyear(Column e)`	Extracts the week of year from a date or timestamp.
`Column`	Column.`withinGroup(Column... cols)`	Returns a Column expression that adds a WITHIN GROUP clause to sort the rows by the specified sequence of columns.
`static Column`	Functions.`xmlget(Column xml, Column tag)`	Extracts the first XML element object (often referred to as simply a tag) from a content of outer XML element object by the name of the tag
`static Column`	Functions.`xmlget(Column xml, Column tag, Column instance)`	Extracts an XML element object (often referred to as simply a tag) from a content of outer XML element object by the name of the tag and its instance number (counting from 0).
`static Column`	Functions.`year(Column e)`	Extracts the year from a date or timestamp.

Methods in com.snowflake.snowpark_java with parameters of type Column
Modifier and Type	Method	Description
`static Column`	Functions.`abs(Column col)`	Returns the absolute value of a numeric expression.
`static Column`	Functions.`acos(Column col)`	Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`add_months(Column startDate, Column numMonths)`	Adds or subtracts a specified number of months to a date or timestamp, preserving the end-of-month information.
`DataFrame`	DataFrame.`agg(Column... exprs)`	Aggregate the data in the DataFrame.
`DataFrame`	RelationalGroupedDataFrame.`agg(Column... cols)`	Returns a DataFrame with aggregated computed according to the supplied Column expressions.
`Column`	Column.`and(Column other)`	And.
`static Column`	Functions.`any_value(Column e)`	Returns a non-deterministic value for the specified column.
`DataFrame`	RelationalGroupedDataFrame.`any_value(Column... cols)`	Returns non-deterministic values for the specified columns.
`Column`	UserDefinedFunction.`apply(Column... exprs)`	Apply the UDF to one or more columns to generate a Column expression.
`static Column`	Functions.`approx_count_distinct(Column col)`	Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e.
`static Column`	Functions.`approx_percentile(Column col, double percentile)`	Returns an approximated value for the desired percentile.
`static Column`	Functions.`approx_percentile_accumulate(Column col)`	Returns the internal representation of the t-Digest state (as a JSON object) at the end of aggregation.
`static Column`	Functions.`approx_percentile_combine(Column state)`	Combines (merges) percentile input states into a single output state.
`static Column`	Functions.`approx_percentile_estimate(Column col, double percentile)`	Returns the desired approximated percentile value for the specified t-Digest state.
`static Column`	Functions.`array(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs.
`static Column`	Functions.`array_agg(Column col)`	Returns the input values, pivoted into an ARRAY.
`static Column`	Functions.`array_append(Column array, Column element)`	Returns an ARRAY containing all elements from the source ARRAYas well as the new element.
`static Column`	Functions.`array_cat(Column array1, Column array2)`	Returns the concatenation of two ARRAYs.
`static Column`	Functions.`array_compact(Column array)`	Returns a compacted ARRAY with missing and null values removed, effectively converting sparse arrays into dense arrays.
`static Column`	Functions.`array_construct(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs.
`static Column`	Functions.`array_construct_compact(Column... cols)`	Returns an ARRAY constructed from zero, one, or more inputs; the constructed ARRAY omits any NULL input values.
`static Column`	Functions.`array_contains(Column variant, Column array)`	Returns `true` if the specified VARIANT is found in the specified ARRAY.
`static Column`	Functions.`array_insert(Column array, Column pos, Column element)`	Returns an ARRAY containing all elements from the source ARRAY as well as the new element.
`static Column`	Functions.`array_intersection(Column col1, Column col2)`	Returns an ARRAY that contains the matching elements in the two input ARRAYs.
`static Column`	Functions.`array_position(Column variant, Column array)`	Returns the index of the first occurrence of an element in an ARRAY.
`static Column`	Functions.`array_prepend(Column array, Column element)`	Returns an ARRAY containing the new element as well as all elements from the source ARRAY.
`static Column`	Functions.`array_size(Column array)`	Returns the size of the input ARRAY.
`static Column`	Functions.`array_slice(Column array, Column from, Column to)`	Returns an ARRAY constructed from a specified subset of elements of the input ARRAY.
`static Column`	Functions.`array_to_string(Column array, Column separator)`	Returns an input ARRAY converted to a string by casting all values to strings (using TO_VARCHAR) and concatenating them (using the string from the second argument to separate the elements).
`static Column`	Functions.`arrays_overlap(Column a1, Column a2)`	Compares whether two arrays have at least one element in common.
`static Column`	Functions.`as_array(Column variant)`	Casts a VARIANT value to an array.
`static Column`	Functions.`as_binary(Column variant)`	Casts a VARIANT value to a binary string.
`static Column`	Functions.`as_char(Column variant)`	Casts a VARIANT value to a string.
`static Column`	Functions.`as_date(Column variant)`	Casts a VARIANT value to a date.
`static Column`	Functions.`as_decimal(Column variant)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
`static Column`	Functions.`as_decimal(Column variant, int precision)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
`static Column`	Functions.`as_decimal(Column variant, int precision, int scale)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
`static Column`	Functions.`as_double(Column variant)`	Casts a VARIANT value to a floating-point value.
`static Column`	Functions.`as_integer(Column variant)`	Casts a VARIANT value to an integer.
`static Column`	Functions.`as_number(Column variant)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
`static Column`	Functions.`as_number(Column variant, int precision)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
`static Column`	Functions.`as_number(Column variant, int precision, int scale)`	Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
`static Column`	Functions.`as_object(Column variant)`	Casts a VARIANT value to an object.
`static Column`	Functions.`as_real(Column variant)`	Casts a VARIANT value to a floating-point value.
`static Column`	Functions.`as_time(Column variant)`	Casts a VARIANT value to a time value.
`static Column`	Functions.`as_timestamp_ltz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with local timezone.
`static Column`	Functions.`as_timestamp_ntz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with no timezone.
`static Column`	Functions.`as_timestamp_tz(Column variant)`	Casts a VARIANT value to a TIMESTAMP value with timezone.
`static Column`	Functions.`as_varchar(Column variant)`	Casts a VARIANT value to a string.
`static Column`	Functions.`ascii(Column e)`	Returns the ASCII code for the first character of a string.
`static Column`	Functions.`asin(Column col)`	Computes the inverse sine (arc sine) of its argument; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`atan(Column col)`	Computes the inverse tangent (arc tangent) of its argument; the result is a number in the interval [-pi, pi].
`static Column`	Functions.`atan2(Column y, Column x)`	Computes the inverse tangent (arc tangent) of the ratio of its two arguments.
`static Column`	Functions.`avg(Column col)`	Returns the average of non-NULL records.
`DataFrame`	RelationalGroupedDataFrame.`avg(Column... cols)`	Return the average for the specified numeric columns.
`static Column`	Functions.`base64(Column c)`	Computes the BASE64 encoding of a column and returns it as a string column.
`Column`	Column.`between(Column lowerBound, Column upperBound)`	Between lower bound (including) and upper bound (including).
`Column`	Column.`bitand(Column other)`	Bitwise and.
`static Column`	Functions.`bitnot(Column col)`	Returns the bitwise negation of a numeric expression.
`Column`	Column.`bitor(Column other)`	Bitwise or.
`static Column`	Functions.`bitshiftleft(Column e, Column numBits)`	Shifts the bits for a numeric expression numBits positions to the left.
`static Column`	Functions.`bitshiftright(Column e, Column numBits)`	Shifts the bits for a numeric expression numBits positions to the right.
`Column`	Column.`bitxor(Column other)`	Bitwise xor.
`DataFrame`	RelationalGroupedDataFrame.`builtin(String aggName, Column... cols)`	Computes the builtin aggregate 'aggName' over the specified columns.
`Column`	TableFunction.`call(Column... args)`	Create a Column reference by passing arguments in the TableFunction object.
`static Column`	Functions.`callUDF(String udfName, Column... cols)`	Calls a user-defined function (UDF) by name.
`static Column`	Functions.`ceil(Column col)`	Returns values from the specified column rounded to the nearest equal or larger integer.
`static Column`	Functions.`charindex(Column targetExpr, Column sourceExpr)`	Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
`static Column`	Functions.`charindex(Column targetExpr, Column sourceExpr, Column position)`	Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
`static Column`	Functions.`check_json(Column col)`	Checks the validity of a JSON document.
`static Column`	Functions.`check_xml(Column col)`	Checks the validity of an XML document.
`static Column`	Functions.`chr(Column col)`	Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode.
`static Column`	Functions.`coalesce(Column... cols)`	Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.
`static Column`	Functions.`collate(Column expr, String collationSpec)`	Returns a copy of expr, but with the specified collationSpec property instead of the original collation specification property.
`static Column`	Functions.`collation(Column expr)`	Returns the collation specification of expr.
`static Column`	Functions.`collect_list(Column c)`	Returns the input values, pivoted into an ARRAY.
`static Column`	Functions.`collect_set(Column e)`	Aggregate function: returns a set of objects with duplicate elements eliminated.
`static Column`	Functions.`concat(Column... exprs)`	Concatenates one or more strings, or concatenates one or more binary values.
`static Column`	Functions.`concat_ws(Column separator, Column... exprs)`	Concatenates two or more strings, or concatenates two or more binary values.
`static Column`	Functions.`contains(Column col, Column str)`	Returns true if col contains str.
`static Column`	Functions.`convert_timezone(Column targetTimeZone, Column sourceTimestamp)`	Converts the given sourceTimestampNTZ to targetTimeZone.
`static Column`	Functions.`convert_timezone(Column sourceTimeZone, Column targetTimeZone, Column sourceTimestampNTZ)`	Converts the given sourceTimestampNTZ from sourceTimeZone to targetTimeZone.
`void`	CopyableDataFrame.`copyInto(String tableName, Column[] transformations)`	Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
`void`	CopyableDataFrame.`copyInto(String tableName, Column[] transformations, Map<String,?> options)`	Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
`void`	CopyableDataFrame.`copyInto(String tableName, String[] targetColumnNames, Column[] transformations, Map<String,?> options)`	Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
`TypedAsyncJob<Void>`	CopyableDataFrameAsyncActor.`copyInto(String tableName, Column[] transformations)`	Executes `CopyableDataFrame.copyInto` asynchronously.
`TypedAsyncJob<Void>`	CopyableDataFrameAsyncActor.`copyInto(String tableName, Column[] transformations, Map<String,?> options)`	Executes `CopyableDataFrame.copyInto` asynchronously.
`TypedAsyncJob<Void>`	CopyableDataFrameAsyncActor.`copyInto(String tableName, String[] targetColumnNames, Column[] transformations, Map<String,?> options)`	Executes `CopyableDataFrame.copyInto` asynchronously.
`static Column`	Functions.`corr(Column col1, Column col2)`	Returns the correlation coefficient for non-null pairs in a group.
`static Column`	Functions.`cos(Column col)`	Computes the cosine of its argument; the argument should be expressed in radians.
`static Column`	Functions.`cosh(Column col)`	Computes the hyperbolic cosine of its argument.
`static Column`	Functions.`count(Column col)`	Returns either the number of non-NULL records for the specified columns, or the total number of records.
`static Column`	Functions.`count_distinct(Column first, Column... remaining)`	Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
`static Column`	Functions.`countDistinct(Column first, Column... remaining)`	Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
`static Column`	Functions.`covar_pop(Column col1, Column col2)`	Calculates the population covariance for non-null pairs in a group.
`static Column`	Functions.`covar_samp(Column col1, Column col2)`	Calculates the sample covariance for non-null pairs in a group.
`RelationalGroupedDataFrame`	DataFrame.`cube(Column... cols)`	Performs an SQL GROUP BY CUBE on the DataFrame.
`static Column`	Functions.`date_add(Column start, Column days)`	Returns the date that is `days` days after `start` Usage - DATE_ADD( date_or_time_part, value, date_or_time_expr )
`static Column`	Functions.`date_add(Integer days, Column start)`	Returns the date that is `days` days after `start` Usage - DATE_ADD( date_or_time_part, value, date_or_time_expr )
`static Column`	Functions.`date_format(Column col, String s)`	Converts an input expression into the corresponding date in the specified date format.
`static Column`	Functions.`date_from_parts(Column year, Column month, Column day)`	Creates a date from individual numeric components that represent the year, month, and day of the month.
`static Column`	Functions.`date_trunc(String format, Column timestamp)`	Truncates a DATE, TIME, or TIMESTAMP to the specified precision.
`static Column`	Functions.`dateadd(String part, Column value, Column expr)`	Adds the specified value for the specified date or time art to date or time expr.
`static Column`	Functions.`datediff(String part, Column col1, Column col2)`	Calculates the difference between two date, time, or timestamp columns based on the date or time part requested.
`static Column`	Functions.`dayname(Column expr)`	Extracts the three-letter day-of-week name from the specified date or timestamp.
`static Column`	Functions.`dayofmonth(Column e)`	Extracts the day of month from a date or timestamp.
`static Column`	Functions.`dayofweek(Column e)`	Extracts the day of week from a date or timestamp.
`static Column`	Functions.`dayofyear(Column e)`	Extracts the day of year from a date or timestamp.
`static Column`	Functions.`degrees(Column e)`	Converts radians to degrees.
`DeleteResult`	Updatable.`delete(Column condition)`	Deletes all rows in the updatable that satisfy specified condition and returns a `DeleteResult`, representing number of rows deleted.
`DeleteResult`	Updatable.`delete(Column condition, DataFrame sourceData)`	Deletes all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `DeleteResult`, representing number of rows deleted.
`TypedAsyncJob<DeleteResult>`	UpdatableAsyncActor.`delete(Column condition)`	Executes `Updatable.delete` asynchronously.
`TypedAsyncJob<DeleteResult>`	UpdatableAsyncActor.`delete(Column condition, DataFrame sourceData)`	Executes `Updatable.delete` asynchronously.
`static Column`	Functions.`div0(Column dividend, Column divisor)`	Performs division like the division operator (/), but returns 0 when the divisor is 0 (rather than reporting an error).
`Column`	Column.`divide(Column other)`	Divide
`DataFrame`	DataFrame.`drop(Column... columns)`	Returns a new DataFrame that excludes the columns with the specified names from the output.
`static Column`	Functions.`endswith(Column expr, Column str)`	Returns TRUE if expr ends with str.
`static Column`	Functions.`equal_nan(Column col)`	Returns true if the value in the column is not a number (NaN).
`Column`	Column.`equal_null(Column other)`	Equal to.
`Column`	Column.`equal_to(Column other)`	Equal to.
`static Column`	Functions.`exp(Column col)`	Computes Euler's number e raised to a floating-point value.
`static Column`	TableFunctions.`explode(Column input)`	Flattens a given array or map type column into individual rows.
`static Column`	Functions.`factorial(Column col)`	Computes the factorial of its input.
`DataFrame`	DataFrame.`filter(Column condition)`	Filters rows based on the specified conditional expression (similar to WHERE in SQL).
`DataFrame`	DataFrame.`flatten(Column input)`	Flattens (explodes) compound values into multiple rows (similar to the SQL FLATTEN
`DataFrame`	DataFrame.`flatten(Column input, String path, boolean outer, boolean recursive, String mode)`	Flattens (explodes) compound values into multiple rows (similar to the SQL FLATTEN
`DataFrame`	Session.`flatten(Column input)`	Creates a new DataFrame by flattening compound values into multiple rows.
`DataFrame`	Session.`flatten(Column input, String path, boolean outer, boolean recursive, String mode)`	Creates a new DataFrame by flattening compound values into multiple rows.
`static Column`	TableFunctions.`flatten(Column input)`	Flattens (explodes) compound values into multiple rows.
`static Column`	TableFunctions.`flatten(Column input, String path, boolean outer, boolean recursive, String mode)`	Flattens (explodes) compound values into multiple rows.
`static Column`	Functions.`floor(Column col)`	Returns values from the specified column rounded to the nearest equal or smaller integer.
`static Column`	Functions.`format_number(Column x, Integer d)`	Formats numeric column x to a format like '#,###,###.##', rounded to d decimal places with HALF_EVEN round mode, and returns the result as a string column.
`static Column`	Functions.`from_unixtime(Column ut)`	Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the yyyy-MM-dd HH:mm:ss format.
`static Column`	Functions.`from_unixtime(Column ut, String f)`	Converts the number of seconds from unix epoch (1970-01-01 00:00:00 UTC) to a string representing the timestamp of that moment in the current system time zone in the given format.
`static Column`	Functions.`from_utc_timestamp(Column ts)`	Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in UTC, and renders that time as a timestamp in the given time zone.
`DataFrame`	Session.`generator(long rowCount, Column... columns)`	Creates a new DataFrame via Generator function.
`Column`	Column.`geq(Column other)`	Greater than or equal to.
`static Column`	Functions.`get(Column col1, Column col2)`	Extracts a value from an object or array; returns NULL if either of the arguments is NULL.
`static Column`	Functions.`get_ignore_case(Column obj, Column field)`	Extracts a field value from an object; returns NULL if either of the arguments is NULL.
`static Column`	Functions.`get_path(Column col, Column path)`	Extracts a value from semi-structured data using a path name.
`static Column`	Functions.`greatest(Column... cols)`	Returns the largest value from a list of expressions.
`RelationalGroupedDataFrame`	DataFrame.`groupBy(Column... cols)`	Groups rows by the columns specified by expressions (similar to GROUP BY in SQL).
`static Column`	Functions.`grouping(Column col)`	Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
`static Column`	Functions.`grouping_id(Column... cols)`	Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
`Column`	Column.`gt(Column other)`	Greater than.
`static Column`	Functions.`hash(Column... cols)`	Returns a signed 64-bit hash value.
`static Column`	Functions.`hex(Column c)`	Computes hex value of the given column.
`static Column`	Functions.`hour(Column e)`	Extracts the hour from a date or timestamp.
`static Column`	Functions.`iff(Column condition, Column expr1, Column expr2)`	Returns one of two specified expressions, depending on a condition.
`static Column`	Functions.`in(Column[] columns, DataFrame df)`	Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
`static Column`	Functions.`in(Column[] columns, List<List<Object>> values)`	Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
`static Column`	Functions.`initcap(Column e)`	Returns the input string with the first letter of each word in uppercase and the subsequent letters in lowercase.
`static Column`	Functions.`insert(Column baseExpr, Column position, Column length, Column insertExpr)`	Replaces a substring of the specified length, starting at the specified position, with a new string or binary value.
`MergeBuilder`	NotMatchedClauseBuilder.`insert(Column[] 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'.
`static Column`	Functions.`instr(Column str, String substring)`	Locate the position of the first occurrence of substr column in the given string.
`static Column`	Functions.`is_array(Column col)`	Returns true if the specified VARIANT column contains an ARRAY value.
`static Column`	Functions.`is_binary(Column col)`	Returns true if the specified VARIANT column contains a binary value.
`static Column`	Functions.`is_boolean(Column col)`	Returns true if the specified VARIANT column contains a Boolean value.
`static Column`	Functions.`is_char(Column col)`	Returns true if the specified VARIANT column contains a string value.
`static Column`	Functions.`is_date(Column col)`	Returns true if the specified VARIANT column contains a DATE value.
`static Column`	Functions.`is_date_value(Column col)`	Returns true if the specified VARIANT column contains a DATE value.
`static Column`	Functions.`is_decimal(Column col)`	Returns true if the specified VARIANT column contains a fixed-point decimal value or integer.
`static Column`	Functions.`is_double(Column col)`	Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
`static Column`	Functions.`is_integer(Column col)`	Returns true if the specified VARIANT column contains an integer value.
`static Column`	Functions.`is_null(Column col)`	Returns true if the value in the column is null.
`static Column`	Functions.`is_null_value(Column col)`	Returns true if the specified VARIANT column is a JSON null value.
`static Column`	Functions.`is_object(Column col)`	Returns true if the specified VARIANT column contains an OBJECT value.
`static Column`	Functions.`is_real(Column col)`	Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
`static Column`	Functions.`is_time(Column col)`	Returns true if the specified VARIANT column contains a TIME value.
`static Column`	Functions.`is_timestamp_ltz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value to be interpreted using the local time zone.
`static Column`	Functions.`is_timestamp_ntz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value with no time zone.
`static Column`	Functions.`is_timestamp_tz(Column col)`	Returns true if the specified VARIANT column contains a TIMESTAMP value with a time zone.
`static Column`	Functions.`is_varchar(Column col)`	Returns true if the specified VARIANT column contains a string value.
`static Column`	Functions.`isnull(Column c)`	Wrapper for Snowflake built-in isnull function.
`DataFrame`	DataFrame.`join(Column func)`	Joins the current DataFrame with the output of the specified table function `func`.
`DataFrame`	DataFrame.`join(Column func, Column[] partitionBy, Column[] orderBy)`	Joins the current DataFrame with the output of the specified table function `func`.
`DataFrame`	DataFrame.`join(DataFrame right, Column joinExpr)`	Performs a default inner join of the current DataFrame and another DataFrame (`right`) using the join condition specified in an expression (`joinExpr`).
`DataFrame`	DataFrame.`join(DataFrame right, Column joinExpr, String joinType)`	Performs a join of the specified type (`joinType`) with the current DataFrame and another DataFrame (`right`) using the join condition specified in an expression (`joinExpr`).
`DataFrame`	DataFrame.`join(TableFunction func, Column... args)`	Joins the current DataFrame with the output of the specified table function `func`.
`DataFrame`	DataFrame.`join(TableFunction func, Column[] args, Column[] partitionBy, Column[] orderBy)`	Joins the current DataFrame with the output of the specified user-defined table function (UDTF) `func`.
`DataFrame`	DataFrame.`join(TableFunction func, Map<String,Column> args, Column[] partitionBy, Column[] orderBy)`	Joins the current DataFrame with the output of the specified user-defined table function (UDTF) `func`.
`static Column`	Functions.`json_extract_path_text(Column col, Column path)`	Parses a JSON string and returns the value of an element at a specified path in the resulting JSON document.
`static Column`	Functions.`kurtosis(Column col)`	Returns the population excess kurtosis of non-NULL records.
`static Column`	Functions.`lag(Column col)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`lag(Column col, int offset)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`lag(Column col, int offset, Column defaultValue)`	Accesses data in a previous row in the same result set without having to join the table to itself.
`static Column`	Functions.`last(Column col)`	Returns the last value of the column in a group.
`static Column`	Functions.`last_day(Column e)`	Returns the last day of the specified date part for a date or timestamp.
`static Column`	Functions.`lead(Column col)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`lead(Column col, int offset)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`lead(Column col, int offset, Column defaultValue)`	Accesses data in a subsequent row in the same result set without having to join the table to itself.
`static Column`	Functions.`least(Column... cols)`	Returns the smallest value from a list of expressions.
`static Column`	Functions.`left(Column strExpr, Column lengthExpr)`	Returns a left most substring of strExpr.
`static Column`	Functions.`length(Column e)`	Returns the length of an input string or binary value.
`Column`	Column.`leq(Column other)`	Less than or equal to.
`Column`	Column.`like(Column pattern)`	Allows case-sensitive matching of strings based on comparison with a pattern.
`static Column`	Functions.`listagg(Column col)`	Returns the concatenated input values, separated by empty string.
`static Column`	Functions.`listagg(Column col, String delimiter)`	Returns the concatenated input values, separated by `delimiter` string.
`static Column`	Functions.`listagg(Column col, String delimiter, boolean isDistinct)`	Returns the concatenated input values, separated by `delimiter` string.
`static Column`	Functions.`locate(Column substr, Column str, int pos)`	Locate the position of the first occurrence of substr in a string column, after position pos.
`static Column`	Functions.`locate(String substr, Column str)`	Locate the position of the first occurrence of substr in a string column, after position pos.
`static Column`	Functions.`log(Column base, Column a)`	Returns the logarithm of a numeric expression.
`static Column`	Functions.`log10(Column col)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`log1p(Column col)`	Computes the logarithm of the given value in base 10.
`static Column`	Functions.`lower(Column e)`	Returns the input string with all characters converted to lowercase.
`static Column`	Functions.`lpad(Column str, Column len, Column pad)`	Left-pads a string with characters from another string, or left-pads a binary value with bytes from another binary value.
`Column`	Column.`lt(Column other)`	Less than.
`static Column`	Functions.`ltrim(Column e)`	Removes leading characters, including whitespace, from a string.
`static Column`	Functions.`ltrim(Column e, Column trimString)`	Removes leading characters, including whitespace, from a string.
`static Column`	Functions.`max(Column col)`	Returns the maximum value for the records in a group.
`DataFrame`	RelationalGroupedDataFrame.`max(Column... cols)`	Return the max for the specified numeric columns.
`static Column`	Functions.`md5(Column e)`	Returns a 32-character hex-encoded string containing the 128-bit MD5 message digest.
`static Column`	Functions.`mean(Column col)`	Returns the average of non-NULL records.
`DataFrame`	RelationalGroupedDataFrame.`mean(Column... cols)`	Return the average for the specified numeric columns.
`static Column`	Functions.`median(Column col)`	Returns the median value for the records in a group.
`DataFrame`	RelationalGroupedDataFrame.`median(Column... cols)`	Return the median for the specified numeric columns.
`MergeBuilder`	Updatable.`merge(DataFrame source, Column joinExpr)`	Initiates a merge action for this updatable with `DataFrame` source on specified join expression.
`static Column`	Functions.`min(Column col)`	Returns the minimum value for the records in a group.
`DataFrame`	RelationalGroupedDataFrame.`min(Column... cols)`	Return the min for the specified numeric columns.
`Column`	Column.`minus(Column other)`	Minus
`static Column`	Functions.`minute(Column e)`	Extracts the minute from a date or timestamp.
`Column`	Column.`mod(Column other)`	Remainder
`static Column`	Functions.`month(Column e)`	Extracts the month from a date or timestamp.
`static Column`	Functions.`monthname(Column expr)`	Extracts the three-letter month name from the specified date or timestamp.
`Column`	Column.`multiply(Column other)`	Multiply
`static Column`	Functions.`negate(Column col)`	Returns the negation of the value in the column (equivalent to a unary minus).
`static Column`	Functions.`next_day(Column date, Column dayOfWeek)`	Returns the date of the first specified DOW (day of week) that occurs after the input date.
`static Column`	Functions.`not(Column col)`	Returns the inverse of a boolean expression.
`Column`	Column.`not_equal(Column other)`	Not equal to.
`static Column`	Functions.`ntile(Column col)`	Divides an ordered data set equally into the number of buckets specified by n.
`static Column`	Functions.`object_construct(Column... key_values)`	Returns an OBJECT constructed from the arguments.
`static Column`	Functions.`object_delete(Column obj, Column key1, Column... keys)`	Returns an object containing the contents of the input (i.e.source) object with one or more keys removed.
`static Column`	Functions.`object_insert(Column obj, Column key, Column value)`	Returns an object consisting of the input object with a new key-value pair inserted.
`static Column`	Functions.`object_insert(Column obj, Column key, Column value, Column update_flag)`	Returns an object consisting of the input object with a new key-value pair inserted (or an existing key updated with a new value).
`static Column`	Functions.`object_keys(Column obj)`	Returns an array containing the list of keys in the input object.
`static Column`	Functions.`object_pick(Column obj, Column key1, Column... keys)`	Returns a new OBJECT containing some of the key-value pairs from an existing object.
`static Column`	Functions.`objectagg(Column key, Column value)`	Returns one OBJECT per group.
`Column`	Column.`or(Column other)`	Or.
`static WindowSpec`	Window.`orderBy(Column... cols)`	Returns WindowSpec object with order by clause.
`WindowSpec`	WindowSpec.`orderBy(Column... cols)`	Returns a new WindowSpec object with the new order by clause.
`Column`	CaseExpr.`otherwise(Column value)`	Sets the default result for this CASE expression.
`static Column`	Functions.`parse_json(Column col)`	Parse the value of the specified column as a JSON string and returns the resulting JSON document.
`static Column`	Functions.`parse_xml(Column col)`	Parse the value of the specified column as a JSON string and returns the resulting XML document.
`static WindowSpec`	Window.`partitionBy(Column... cols)`	Returns WindowSpec object with partition by clause.
`WindowSpec`	WindowSpec.`partitionBy(Column... cols)`	Returns a new WindowSpec object with the new partition by clause.
`RelationalGroupedDataFrame`	DataFrame.`pivot(Column pivotColumn, Object[] values)`	Rotates this DataFrame by turning the unique values from one column in the input expression into multiple columns and aggregating results where required on any remaining column values.
`Column`	Column.`plus(Column other)`	Plus
`static Column`	Functions.`pow(Column l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Column l, Double r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Column l, String r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(Double l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`pow(String l, Column r)`	Returns a number (l) raised to the specified power (r).
`static Column`	Functions.`previous_day(Column date, Column dayOfWeek)`	Returns the date of the first specified DOW (day of week) that occurs before the input date.
`static Column`	Functions.`quarter(Column e)`	Extracts the quarter from a date or timestamp.
`static Column`	Functions.`radians(Column e)`	Converts degrees to radians.
`Column`	Column.`regexp(Column pattern)`	Returns true if this column matches the specified regular expression.
`static Column`	Functions.`regexp_count(Column strExpr, Column pattern)`	Returns the number of times that a pattern occurs in a strExpr.
`static Column`	Functions.`regexp_count(Column strExpr, Column pattern, Column position, Column parameters)`	Returns the number of times that a pattern occurs in a strExpr.
`static Column`	Functions.`regexp_extract(Column col, String exp, Integer position, Integer Occurences, Integer grpIdx)`	Signature - snowflake.snowpark.functions.regexp_extract (value: Union[Column, str], regexp: Union[Column, str], idx: int) Column Extract a specific group matched by a regex, from the specified string column.
`static Column`	Functions.`regexp_replace(Column strExpr, Column pattern)`	Returns the subject with the specified pattern (or all occurrences of the pattern) removed.
`static Column`	Functions.`regexp_replace(Column strExpr, Column pattern, Column replacement)`	Returns the subject with the specified pattern (or all occurrences of the pattern) replaced by a replacement string.
`DataFrame`	DataFrame.`rename(String newName, Column col)`	Returns a DataFrame with the specified column `col` renamed as `newName`.
`static Column`	Functions.`repeat(Column str, Column n)`	Builds a string by repeating the input for the specified number of times.
`static Column`	Functions.`replace(Column strExpr, Column pattern)`	Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
`static Column`	Functions.`replace(Column strExpr, Column pattern, Column replacement)`	Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
`static Column`	Functions.`reverse(Column name)`	Wrapper for Snowflake built-in reverse function.
`static Column`	Functions.`right(Column strExpr, Column lengthExpr)`	Returns a right most substring of strExpr.
`RelationalGroupedDataFrame`	DataFrame.`rollup(Column... cols)`	Performs an SQL GROUP BY ROLLUP on the DataFrame.
`static Column`	Functions.`round(Column e)`	Rounds the numeric values of the given column `e` to 0 decimal places using the half away from zero rounding mode.
`static Column`	Functions.`round(Column e, int scale)`	Rounds the numeric values of the given column `e` to the `scale` decimal places using the half away from zero rounding mode.
`static Column`	Functions.`round(Column e, Column scale)`	Rounds the numeric values of the given column `e` to the `scale` decimal places using the half away from zero rounding mode.
`static Column`	Functions.`rpad(Column str, Column len, Column pad)`	Right-pads a string with characters from another string, or right-pads a binary value with bytes from another binary value.
`static Column`	Functions.`rtrim(Column e)`	Removes trailing characters, including whitespace, from a string.
`static Column`	Functions.`rtrim(Column e, Column trimString)`	Removes trailing characters, including whitespace, from a string.
`DataFrame`	DataFrameStatFunctions.`sampleBy(Column col, Map<?,Double> fractions)`	Returns a DataFrame containing a stratified sample without replacement, based on a Map that specifies the fraction for each stratum.
`static Column`	Functions.`second(Column e)`	Extracts the second from a date or timestamp.
`DataFrame`	DataFrame.`select(Column... columns)`	Generates a new DataFrame with the specified Column expressions as output (similar to SELECT in SQL).
`static Column`	Functions.`sha1(Column e)`	Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest.
`static Column`	Functions.`sha2(Column e, int numBits)`	Returns a hex-encoded string containing the N-bit SHA-2 message digest, where N is the specified output digest size.
`static Column`	Functions.`shiftleft(Column c, int numBits)`	Shift the given value numBits left.
`static Column`	Functions.`shiftright(Column c, int numBits)`	Shift the given value numBits right.
`static Column`	Functions.`sign(Column col)`	Returns the sign of its argument:
`static Column`	Functions.`signum(Column col)`	Returns the sign of its argument:
`static Column`	Functions.`sin(Column e)`	Computes the sine of its argument; the argument should be expressed in radians.
`static Column`	Functions.`sinh(Column e)`	Computes the hyperbolic sine of its argument.
`static Column`	Functions.`size(Column col)`	Returns the size of the input ARRAY.
`static Column`	Functions.`skew(Column col)`	Returns the sample skewness of non-NULL records.
`DataFrame`	DataFrame.`sort(Column... sortExprs)`	Sorts a DataFrame by the specified expressions (similar to ORDER BY in SQL).
`static Column`	Functions.`soundex(Column e)`	Returns a string that contains a phonetic representation of the input string.
`static Column`	Functions.`split(Column str, Column pattern)`	Splits a given string with a given separator and returns the result in an array of strings.
`static Column`	TableFunctions.`split_to_table(Column str, String delimiter)`	This table function splits a string (based on a specified delimiter) and flattens the results into rows.
`static Column`	Functions.`sqrt(Column col)`	Returns the square-root of a non-negative numeric expression.
`static Column`	Functions.`startswith(Column col, Column str)`	Returns true if col starts with str.
`static Column`	Functions.`stddev(Column col)`	Returns the sample standard deviation (square root of sample variance) of non-NULL values.
`static Column`	Functions.`stddev_pop(Column col)`	Returns the population standard deviation (square root of variance) of non-NULL values.
`static Column`	Functions.`stddev_samp(Column col)`	Returns the sample standard deviation (square root of sample variance) of non-NULL values.
`static Column`	Functions.`strip_null_value(Column col)`	Converts a JSON "null" value in the specified column to a SQL NULL value.
`static Column`	Functions.`strtok_to_array(Column array)`	Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
`static Column`	Functions.`strtok_to_array(Column array, Column delimiter)`	Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
`static Column`	Functions.`substring(Column str, Column pos, Column len)`	Returns the portion of the string or binary value str, starting from the character/byte specified by pos, with limited length.
`static Column`	Functions.`sum(Column col)`	Returns the sum of non-NULL records in a group.
`DataFrame`	RelationalGroupedDataFrame.`sum(Column... cols)`	Return the sum for the specified numeric columns.
`static Column`	Functions.`sum_distinct(Column col)`	Returns the sum of non-NULL distinct records in a group.
`DataFrame`	Session.`tableFunction(Column func)`	Creates a new DataFrame from the given table function and arguments.
`DataFrame`	Session.`tableFunction(TableFunction func, Column... args)`	Creates a new DataFrame from the given table function and arguments.
`static Column`	Functions.`tan(Column e)`	Computes the tangent of its argument; the argument should be expressed in radians.
`static Column`	Functions.`tanh(Column e)`	Computes the hyperbolic tangent of its argument.
`static Column`	Functions.`time_from_parts(Column hour, Column minute, Column second)`	Creates a time from individual numeric components.
`static Column`	Functions.`time_from_parts(Column hour, Column minute, Column second, Column nanosecond)`	Creates a time from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column dateExpr, Column timeExpr)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ltz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ltz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column dateExpr, Column timeExpr)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_ntz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`timestamp_tz_from_parts(Column year, Column month, Column day, Column hour, Column minute, Column second, Column nanosecond, Column timezone)`	Creates a timestamp from individual numeric components.
`static Column`	Functions.`to_array(Column col)`	Converts the input expression into an array:
`static Column`	Functions.`to_date(Column e)`	Converts an input expression to a date.
`static Column`	Functions.`to_date(Column e, Column fmt)`	Converts an input expression to a date.
`static Column`	Functions.`to_decimal(Column expr, int precision, int scale)`	Converts an input expression to a decimal
`static Column`	Functions.`to_json(Column col)`	Converts any VARIANT value to a string containing the JSON representation of the value.
`static Column`	Functions.`to_object(Column col)`	Converts the input value to an object:
`static Column`	Functions.`to_timestamp(Column s)`	Converts an input expression into the corresponding timestamp.
`static Column`	Functions.`to_timestamp(Column s, Column fmt)`	Converts an input expression into the corresponding timestamp.
`static Column`	Functions.`to_utc_timestamp(Column ts)`	Given a timestamp like '2017-07-14 02:40:00.0', interprets it as a time in the given time zone, and renders that time as a timestamp in UTC.
`static Column`	Functions.`to_variant(Column col)`	Converts any value to VARIANT value or NULL (if input is NULL).
`static Column`	Functions.`to_xml(Column col)`	Converts any VARIANT value to a string containing the XML representation of the value.
`static Column`	Functions.`translate(Column src, Column matchingString, Column replaceString)`	Translates src from the characters in matchingString to the characters in replaceString.
`static Column`	Functions.`trim(Column e, Column trimString)`	Removes leading and trailing characters from a string.
`static Column`	Functions.`trunc(Column expr, Column scale)`	Rounds the input expression down to the nearest (or equal) integer closer to zero, or to the nearest equal or smaller value with the specified number of places after the decimal point.
`static Column`	Functions.`unbase64(Column c)`	Decodes a BASE64 encoded string column and returns it as a column.
`static Column`	Functions.`unhex(Column c)`	Inverse of hex.
`static Column`	Functions.`uniform(Column min, Column max, Column gen)`	Returns a uniformly random number, in the inclusive range (`min`, `max`)
`static Column`	Functions.`unix_timestamp(Column c)`	Returns the current Unix timestamp (in seconds) as a long.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition)`	Updates all rows in the updatable that satisfy specified condition with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Updates all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Executes `Updatable.update` asynchronously.
`UpdateResult`	Updatable.`updateColumn(Map<String,Column> assignments, Column condition)`	Updates all rows in the updatable that satisfy specified condition with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`updateColumn(Map<String,Column> assignments, Column condition, DataFrame sourceData)`	Updates all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`updateColumn(Map<String,Column> assignments, Column condition)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`updateColumn(Map<String,Column> assignments, Column condition, DataFrame sourceData)`	Executes `Updatable.update` asynchronously.
`static Column`	Functions.`upper(Column e)`	Returns the input string with all characters converted to uppercase.
`static Column`	Functions.`var_pop(Column col)`	Returns the population variance of non-NULL records in a group.
`static Column`	Functions.`var_samp(Column col)`	Returns the sample variance of non-NULL records in a group.
`static Column`	Functions.`variance(Column col)`	Returns the sample variance of non-NULL records in a group.
`static Column`	Functions.`weekofyear(Column e)`	Extracts the week of year from a date or timestamp.
`CaseExpr`	CaseExpr.`when(Column condition, Column value)`	Appends one more WHEN condition to the CASE expression.
`static CaseExpr`	Functions.`when(Column condition, Column value)`	Works like a cascading if-then-else statement.
`MatchedClauseBuilder`	MergeBuilder.`whenMatched(Column condition)`	Adds a matched clause into the merge action.
`NotMatchedClauseBuilder`	MergeBuilder.`whenNotMatched(Column condition)`	Adds a matched clause into the merge action.
`DataFrame`	DataFrame.`where(Column condition)`	Filters rows based on the specified conditional expression (similar to WHERE in SQL).
`DataFrame`	DataFrame.`withColumn(String colName, Column col)`	Returns a DataFrame with an additional column with the specified name (`colName`).
`DataFrame`	DataFrame.`withColumns(String[] colNames, Column[] values)`	Returns a DataFrame with additional columns with the specified names (`colNames`).
`Column`	Column.`withinGroup(Column... cols)`	Returns a Column expression that adds a WITHIN GROUP clause to sort the rows by the specified sequence of columns.
`static Column`	Functions.`xmlget(Column xml, Column tag)`	Extracts the first XML element object (often referred to as simply a tag) from a content of outer XML element object by the name of the tag
`static Column`	Functions.`xmlget(Column xml, Column tag, Column instance)`	Extracts an XML element object (often referred to as simply a tag) from a content of outer XML element object by the name of the tag and its instance number (counting from 0).
`static Column`	Functions.`year(Column e)`	Extracts the year from a date or timestamp.

Method parameters in com.snowflake.snowpark_java with type arguments of type Column
Modifier and Type	Method	Description
`Column`	TableFunction.`call(Map<String,Column> args)`	Create a Column reference by passing arguments in the TableFunction object.
`MergeBuilder`	NotMatchedClauseBuilder.`insert(Map<Column,Column> assignments)`	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.
`MergeBuilder`	NotMatchedClauseBuilder.`insert(Map<Column,Column> assignments)`	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.
`MergeBuilder`	NotMatchedClauseBuilder.`insertRow(Map<String,Column> assignments)`	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.
`DataFrame`	DataFrame.`join(TableFunction func, Map<String,Column> args)`	Joins the current DataFrame with the output of the specified table function `func` that takes named parameters (e.g.
`DataFrame`	DataFrame.`join(TableFunction func, Map<String,Column> args, Column[] partitionBy, Column[] orderBy)`	Joins the current DataFrame with the output of the specified user-defined table function (UDTF) `func`.
`DataFrame`	Session.`tableFunction(TableFunction func, Map<String,Column> args)`	Creates a new DataFrame from the given table function and arguments.
`MergeBuilder`	MatchedClauseBuilder.`update(Map<Column,Column> assignments)`	Defines an update action for the matched clause, when a row in target is matched, update the row in target with `assignments`, where the key specifies column name and value specifies its assigned value.
`MergeBuilder`	MatchedClauseBuilder.`update(Map<Column,Column> assignments)`	Defines an update action for the matched clause, when a row in target is matched, update the row in target with `assignments`, where the key specifies column name and value specifies its assigned value.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments)`	Updates all rows in the Updatable with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments)`	Updates all rows in the Updatable with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition)`	Updates all rows in the updatable that satisfy specified condition with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition)`	Updates all rows in the updatable that satisfy specified condition with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Updates all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Updates all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`update(Map<Column,Column> assignments, Column condition, DataFrame sourceData)`	Executes `Updatable.update` asynchronously.
`MergeBuilder`	MatchedClauseBuilder.`updateColumn(Map<String,Column> assignments)`	Defines an update action for the matched clause, when a row in target is matched, update the row in target with `assignments`, where the key specifies column name and value specifies its assigned value.
`UpdateResult`	Updatable.`updateColumn(Map<String,Column> assignments)`	Updates all rows in the updatable with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`updateColumn(Map<String,Column> assignments, Column condition)`	Updates all rows in the updatable that satisfy specified condition with specified assignments and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`UpdateResult`	Updatable.`updateColumn(Map<String,Column> assignments, Column condition, DataFrame sourceData)`	Updates all rows in the updatable that satisfy specified condition where condition includes columns in other `DataFrame`, and returns a `UpdateResult`, representing number of rows modified and number of multi-joined rows modified.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`updateColumn(Map<String,Column> assignments)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`updateColumn(Map<String,Column> assignments, Column condition)`	Executes `Updatable.update` asynchronously.
`TypedAsyncJob<UpdateResult>`	UpdatableAsyncActor.`updateColumn(Map<String,Column> assignments, Column condition, DataFrame sourceData)`	Executes `Updatable.update` asynchronously.

Uses of Classcom.snowflake.snowpark_java.Column

Uses of Column in com.snowflake.snowpark_java

Uses of Class
com.snowflake.snowpark_java.Column