A B C D E F G H I J K L M N O P Q R S T U V W X Y
All Classes All Packages
All Classes All Packages
All Classes All Packages
A
- abs(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the absolute value of a numeric expression.
- acos(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the inverse cosine (arc cosine) of its input; the result is a number in the interval [-pi, pi].
- add(StructField) - Method in class com.snowflake.snowpark_java.types.StructType
-
Creates new StructType by appending the given StructField to the end of this StructType.
- add(String, DataType) - Method in class com.snowflake.snowpark_java.types.StructType
-
Creates new StructType by appending a new StructField with the given info to the end of this StructType.
- add(String, DataType, boolean) - Method in class com.snowflake.snowpark_java.types.StructType
-
Creates new StructType by appending a new StructField with the given info to the end of this StructType.
- add_months(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Adds or subtracts a specified number of months to a date or timestamp, preserving the end-of-month information.
- addDependency(String) - Method in class com.snowflake.snowpark_java.Session
-
Registers a file in stage or a local file as a dependency of a user-defined function (UDF).
- agg(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Aggregate the data in the DataFrame.
- agg(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Returns a DataFrame with aggregated computed according to the supplied Column expressions.
- alias(String) - Method in class com.snowflake.snowpark_java.Column
-
Retrieves s new renamed Column.
- alias(String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns the current DataFrame aliased as the input alias name.
- and(Column) - Method in class com.snowflake.snowpark_java.Column
-
And.
- any_value(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a non-deterministic value for the specified column.
- any_value(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Returns non-deterministic values for the specified columns.
- Append - com.snowflake.snowpark_java.SaveMode
- apply(Column...) - Method in class com.snowflake.snowpark_java.UserDefinedFunction
-
Apply the UDF to one or more columns to generate a Column expression.
- appName(String) - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Adds the app name to set in the query_tag after session creation.
- approx_count_distinct(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Uses HyperLogLog to return an approximation of the distinct cardinality of the input (i.e.
- approx_percentile(Column, double) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an approximated value for the desired percentile.
- approx_percentile_accumulate(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the internal representation of the t-Digest state (as a JSON object) at the end of aggregation.
- approx_percentile_combine(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Combines (merges) percentile input states into a single output state.
- approx_percentile_estimate(Column, double) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the desired approximated percentile value for the specified t-Digest state.
- approxQuantile(String[], double[]) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
For an array of numeric columns and an array of desired quantiles, returns a matrix of approximate values for each column at each of the desired quantiles.
- approxQuantile(String, double[]) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
For a specified numeric column and an array of desired quantiles, returns an approximate value for the column at each of the desired quantiles.
- array(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY constructed from zero, one, or more inputs.
- array_agg(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the input values, pivoted into an ARRAY.
- array_append(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY containing all elements from the source ARRAYas well as the new element.
- array_cat(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenation of two ARRAYs.
- array_compact(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a compacted ARRAY with missing and null values removed, effectively converting sparse arrays into dense arrays.
- array_construct(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY constructed from zero, one, or more inputs.
- array_construct_compact(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY constructed from zero, one, or more inputs; the constructed ARRAY omits any NULL input values.
- array_contains(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns
true
if the specified VARIANT is found in the specified ARRAY. - array_insert(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY containing all elements from the source ARRAY as well as the new element.
- array_intersection(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY that contains the matching elements in the two input ARRAYs.
- array_position(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the index of the first occurrence of an element in an ARRAY.
- array_prepend(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY containing the new element as well as all elements from the source ARRAY.
- array_size(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the size of the input ARRAY.
- array_slice(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an ARRAY constructed from a specified subset of elements of the input ARRAY.
- array_to_string(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
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).
- arrays_overlap(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Compares whether two arrays have at least one element in common.
- ArrayType - Class in com.snowflake.snowpark_java.types
-
Array data type.
- as(String) - Method in class com.snowflake.snowpark_java.Column
-
Retrieves s new renamed Column.
- as_array(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to an array.
- as_binary(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a binary string.
- as_char(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a string.
- as_date(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a date.
- as_decimal(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
- as_decimal(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
- as_decimal(Column, int, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
- as_double(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a floating-point value.
- as_integer(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to an integer.
- as_number(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values).
- as_number(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision and scale.
- as_number(Column, int, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a fixed-point decimal (does not match floating-point values), with precision.
- as_object(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to an object.
- as_real(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a floating-point value.
- as_time(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a time value.
- as_timestamp_ltz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a TIMESTAMP value with local timezone.
- as_timestamp_ntz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a TIMESTAMP value with no timezone.
- as_timestamp_tz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a TIMESTAMP value with timezone.
- as_varchar(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Casts a VARIANT value to a string.
- asArray() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as array of Variant.
- asBigDecimal() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as BigDecimal value.
- asBigInteger() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as BigInteger value.
- asBinary() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as binary value.
- asBoolean() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as boolean value.
- asc() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in ascending order.
- asc(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a Column expression with values sorted in ascending order.
- asc_nulls_first() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in ascending order, null values sorted before non-null values.
- asc_nulls_last() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in ascending order, null values sorted after non-null values.
- ascii(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the ASCII code for the first character of a string.
- asDate() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as Date value.
- asDouble() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as double value.
- asFloat() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as float value.
- asGeoJSON() - Method in class com.snowflake.snowpark_java.types.Geography
-
Converts this Geography object to a GeoJSON string.
- asin(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the inverse sine (arc sine) of its argument; the result is a number in the interval [-pi, pi].
- asInt() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as int value.
- asJsonNode() - Method in class com.snowflake.snowpark_java.types.Variant
-
Return the variant value as a JsonNode.
- asJsonString() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as valid Json String.
- asList() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as list of Variant.
- asLong() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as long value.
- asMap() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as map of Variant.
- asShort() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as short value.
- asString() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as String value.
- asTime() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as Time value.
- asTimestamp() - Method in class com.snowflake.snowpark_java.types.Variant
-
Converts the variant as Timestamp value.
- async() - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Returns a CopyableDataFrameAsyncActor object that can be used to execute CopyableDataFrame actions asynchronously.
- async() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrameAsyncActor object that can be used to execute DataFrame actions asynchronously.
- async() - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Returns a DataFrameWriterAsyncActor object that can be used to execute DataFrameWriter actions asynchronously.
- async() - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Returns a
MergeBuilderAsyncActor
object that can be used to execute MergeBuilder actions asynchronously. - async() - Method in class com.snowflake.snowpark_java.Updatable
-
Returns an UpdatableAsyncActor object that can be used to execute Updatable actions asynchronously.
- AsyncJob - Class in com.snowflake.snowpark_java
-
Provides a way to track an asynchronous query in Snowflake.
- atan(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the inverse tangent (arc tangent) of its argument; the result is a number in the interval [-pi, pi].
- atan2(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the inverse tangent (arc tangent) of the ratio of its two arguments.
- avg(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the average of non-NULL records.
- avg(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the average for the specified numeric columns.
- avro(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified Avro file.
B
- base64(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the BASE64 encoding of a column and returns it as a string column.
- between(Column, Column) - Method in class com.snowflake.snowpark_java.Column
-
Between lower bound (including) and upper bound (including).
- BinaryType - Class in com.snowflake.snowpark_java.types
-
Binary data type.
- BinaryType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the BinaryType object.
- bitand(Column) - Method in class com.snowflake.snowpark_java.Column
-
Bitwise and.
- bitnot(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the bitwise negation of a numeric expression.
- bitor(Column) - Method in class com.snowflake.snowpark_java.Column
-
Bitwise or.
- bitshiftleft(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Shifts the bits for a numeric expression numBits positions to the left.
- bitshiftright(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Shifts the bits for a numeric expression numBits positions to the right.
- bitxor(Column) - Method in class com.snowflake.snowpark_java.Column
-
Bitwise xor.
- BooleanType - Class in com.snowflake.snowpark_java.types
-
Boolean data type.
- BooleanType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the BooleanType object.
- builder() - Static method in class com.snowflake.snowpark_java.Session
-
Returns a builder you can use to set configuration properties and create a
Session
object. - builtin(String, Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Computes the builtin aggregate 'aggName' over the specified columns.
- ByteType - Class in com.snowflake.snowpark_java.types
-
Byte data type.
- ByteType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the ByteType object.
C
- cacheResult() - Method in class com.snowflake.snowpark_java.DataFrame
-
Caches the content of this DataFrame to create a new cached DataFrame.
- call() - Method in interface com.snowflake.snowpark_java.udf.JavaUDF0
- call(A1) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF1
- call(A1, A2) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF2
- call(A1, A2, A3) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF3
- call(A1, A2, A3, A4) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF4
- call(A1, A2, A3, A4, A5) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF5
- call(A1, A2, A3, A4, A5, A6) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF6
- call(A1, A2, A3, A4, A5, A6, A7) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF7
- call(A1, A2, A3, A4, A5, A6, A7, A8) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF8
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF9
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF10
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF11
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF12
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF13
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF14
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF15
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF16
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF17
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF18
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF19
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF20
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF21
- call(A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21, A22) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF22
- call(Column...) - Method in class com.snowflake.snowpark_java.TableFunction
-
Create a Column reference by passing arguments in the TableFunction object.
- call(Session) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc0
- call(Session, A1) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc1
- call(Session, A1, A2) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc2
- call(Session, A1, A2, A3) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc3
- call(Session, A1, A2, A3, A4) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc4
- call(Session, A1, A2, A3, A4, A5) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc5
- call(Session, A1, A2, A3, A4, A5, A6) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc6
- call(Session, A1, A2, A3, A4, A5, A6, A7) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc7
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc8
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc9
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc10
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc11
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc12
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc13
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc14
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc15
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc16
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc17
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc18
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc19
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc20
- call(Session, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21) - Method in interface com.snowflake.snowpark_java.sproc.JavaSProc21
- call(Map<String, Column>) - Method in class com.snowflake.snowpark_java.TableFunction
-
Create a Column reference by passing arguments in the TableFunction object.
- callUDF(String, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Calls a user-defined function (UDF) by name.
- cancel() - Method in class com.snowflake.snowpark_java.AsyncJob
-
Cancel the underlying query if it is running.
- cancelAll() - Method in class com.snowflake.snowpark_java.Session
-
Cancel all action methods that are running currently.
- CaseExpr - Class in com.snowflake.snowpark_java
-
Represents a CASE expression.
- cast(DataType) - Method in class com.snowflake.snowpark_java.Column
-
Casts the values in the Column to the specified data type.
- ceil(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns values from the specified column rounded to the nearest equal or larger integer.
- charindex(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
- charindex(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Searches for targetExpr in sourceExpr and, if successful, returns the position (1-based) of the targetExpr in sourceExpr.
- check_json(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Checks the validity of a JSON document.
- check_xml(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Checks the validity of an XML document.
- chr(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts a Unicode code point (including 7-bit ASCII) into the character that matches the input Unicode.
- clone() - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Returns a clone of this CopyableDataFrame.
- clone() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a clone of this DataFrame.
- clone() - Method in class com.snowflake.snowpark_java.Row
-
Creates a clone of this
Row
object. - clone() - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Creates a clone of this
ColumnIdentifier
object. - clone() - Method in class com.snowflake.snowpark_java.Updatable
-
Returns a clone of this Updatable.
- close() - Method in class com.snowflake.snowpark_java.Session
-
Close this session.
- CloudProviderToken - Class in com.snowflake.snowpark_java.types
-
The Snowflake class provides access to the CloudProviderToken secret object with the following properties: accessKeyId, secretAccessKey, and token.
- CloudProviderToken(String, String, String) - Constructor for class com.snowflake.snowpark_java.types.CloudProviderToken
- coalesce(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the first non-NULL expression among its arguments, or NULL if all its arguments are NULL.
- col(DataFrame) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a Column representing the result of the input DataFrame.
- col(String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Retrieves a reference to a column in this DataFrame.
- col(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a Column with the specified name.
- collate(Column, String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a copy of expr, but with the specified collationSpec property instead of the original collation specification property.
- collate(String) - Method in class com.snowflake.snowpark_java.Column
-
Returns a copy of the original Column with the specified 'collateSpec` property, rather than the original collation specification property.
- collation(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the collation specification of expr.
- collect() - Method in class com.snowflake.snowpark_java.DataFrame
-
Executes the query representing this DataFrame and returns the result as an array of Row objects.
- collect() - Method in class com.snowflake.snowpark_java.DataFrameAsyncActor
-
Executes
DataFrame.collect
asynchronously. - collect() - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Executes the merge action and returns a
MergeResult
, representing number of rows inserted, updated and deleted by this merge action. - collect() - Method in class com.snowflake.snowpark_java.MergeBuilderAsyncActor
-
Executes `MergeBuilder.collect()` asynchronously.
- collect_list(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the input values, pivoted into an ARRAY.
- Column - Class in com.snowflake.snowpark_java
-
Represents a column or an expression in a DataFrame.
- columnIdentifier() - Method in class com.snowflake.snowpark_java.types.StructField
-
Retrieves the column identifier.
- ColumnIdentifier - Class in com.snowflake.snowpark_java.types
-
Represents Column Identifier
- ColumnIdentifier(String) - Constructor for class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Creates a ColumnIdentifier object for the giving column name.
- com.snowflake.snowpark - package com.snowflake.snowpark
-
Provides the
@PublicPreview
annotation. - com.snowflake.snowpark_java - package com.snowflake.snowpark_java
-
Provides most of the classes for the Snowpark Java API.
- com.snowflake.snowpark_java.sproc - package com.snowflake.snowpark_java.sproc
- com.snowflake.snowpark_java.types - package com.snowflake.snowpark_java.types
-
Provides the classes specifying the schema (the data types of the fields) of semi-structured data.
- com.snowflake.snowpark_java.udf - package com.snowflake.snowpark_java.udf
-
Provides the interfaces for user-defined functions (UDFs).
- com.snowflake.snowpark_java.udtf - package com.snowflake.snowpark_java.udtf
- concat(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Concatenates one or more strings, or concatenates one or more binary values.
- concat_ws(Column, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Concatenates two or more strings, or concatenates two or more binary values.
- config(String, String) - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Adds the specified configuration property and value to the SessionBuilder configuration.
- configFile(String) - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Adds the configuration properties in the specified file to the
SessionBuilder
configuration. - configs(Map<String, String>) - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Adds the specified Map of configuration properties to the SessionBuilder configuration.
- contains(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if col contains str.
- convert_timezone(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the given sourceTimestampNTZ to targetTimeZone.
- convert_timezone(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the given sourceTimestampNTZ from sourceTimeZone to targetTimeZone.
- CopyableDataFrame - Class in com.snowflake.snowpark_java
-
DataFrame for loading data from files in a stage to a table.
- CopyableDataFrameAsyncActor - Class in com.snowflake.snowpark_java
-
Provides APIs to execute CopyableDataFrame actions asynchronously.
- copyInto(String) - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Executes a `COPY INTO 'table_name'` command to load data from files in a stage into a specified table.
- copyInto(String) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- copyInto(String, Column[]) - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
- copyInto(String, Column[]) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- copyInto(String, Column[], Map<String, ?>) - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
- copyInto(String, Column[], Map<String, ?>) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- copyInto(String, String[], Column[], Map<String, ?>) - Method in class com.snowflake.snowpark_java.CopyableDataFrame
-
Executes a `COPY INTO 'table_name'` command with the specified transformations to load data from files in a stage into a specified table.
- copyInto(String, String[], Column[], Map<String, ?>) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- corr(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the correlation coefficient for non-null pairs in a group.
- corr(String, String) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Calculates the correlation coefficient for non-null pairs in two numeric columns.
- cos(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the cosine of its argument; the argument should be expressed in radians.
- cosh(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the hyperbolic cosine of its argument.
- count() - Method in class com.snowflake.snowpark_java.DataFrame
-
Executes the query representing this DataFrame and returns the number of rows in the result (similar to the COUNT function in SQL).
- count() - Method in class com.snowflake.snowpark_java.DataFrameAsyncActor
-
Executes
DataFrame.count
asynchronously. - count() - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the number of rows for each group.
- count(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns either the number of non-NULL records for the specified columns, or the total number of records.
- count_distinct(Column, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
- countDistinct(Column, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
- countDistinct(String, String...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns either the number of non-NULL distinct records for the specified columns, or the total number of the distinct records.
- cov(String, String) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Calculates the sample covariance for non-null pairs in two numeric columns.
- covar_pop(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Calculates the population covariance for non-null pairs in a group.
- covar_samp(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Calculates the sample covariance for non-null pairs in a group.
- create() - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Creates a new
Session
. - create(StructField...) - Static method in class com.snowflake.snowpark_java.types.StructType
-
Creates a StructType object based on the given StructField
- create(Object...) - Static method in class com.snowflake.snowpark_java.Row
-
Creates a
Row
based on the given values. - create(Set<Column>...) - Static method in class com.snowflake.snowpark_java.GroupingSets
-
Creates a GroupingSets object from a list of column/expression sets.
- createArrayType(DataType) - Static method in class com.snowflake.snowpark_java.types.DataTypes
-
Creates a new ArrayType object.
- createAsyncJob(String) - Method in class com.snowflake.snowpark_java.Session
-
Returns an AsyncJob object that you can use to track the status and get the results of the asynchronous query specified by the query ID.
- createDataFrame(Row[], StructType) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame that uses the specified schema and contains the specified Row objects.
- createDecimalType(int, int) - Static method in class com.snowflake.snowpark_java.types.DataTypes
-
Creates a new DecimalType object.
- createMapType(DataType, DataType) - Static method in class com.snowflake.snowpark_java.types.DataTypes
-
Create a new MapType object.
- createOrReplaceTempView(String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a temporary view that returns the same results as this DataFrame.
- createOrReplaceTempView(String[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a temporary view that returns the same results as this DataFrame.
- createOrReplaceView(String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a view that captures the computation expressed by this DataFrame.
- createOrReplaceView(String[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a view that captures the computation expressed by this DataFrame.
- crossJoin(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a cross join, which returns the cartesian product of the current DataFrame and another DataFrame (`right`).
- crosstab(String, String) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Computes a pair-wise frequency table (a ''contingency table'') for the specified columns.
- csv(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified CSV file.
- csv(String) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Saves the contents of the DataFrame to a CSV file on a stage.
- csv(String) - Method in class com.snowflake.snowpark_java.DataFrameWriterAsyncActor
-
Executes `DataFrameWriter.csv()` asynchronously.
- cube(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs an SQL GROUP BY CUBE on the DataFrame.
- cube(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs an SQL GROUP BY CUBE on the DataFrame.
- cume_dist() - Static method in class com.snowflake.snowpark_java.Functions
-
Finds the cumulative distribution of a value with regard to other values within the same window partition.
- current_account() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the account used by the user's current session.
- current_available_roles() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a JSON string that lists all roles granted to the current user.
- current_database() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the database in use for the current session.
- current_date() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current date of the system.
- current_region() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the region for the account where the current user is logged in.
- current_role() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the role in use for the current session.
- current_schema() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the schema in use by the current session.
- current_schemas() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns active search path schemas.
- current_session() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a unique system identifier for the Snowflake session corresponding to the present connection.
- current_statement() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the SQL text of the statement that is currently executing.
- current_time() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current time for the system.
- current_timestamp() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current timestamp for the system.
- current_user() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the user currently logged into the system.
- current_version() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current Snowflake version.
- current_warehouse() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the name of the warehouse in use for the current session.
- currentRow() - Static method in class com.snowflake.snowpark_java.Window
-
Returns a value representing current row.
D
- DataFrame - Class in com.snowflake.snowpark_java
-
Represents a lazily-evaluated relational dataset that contains a collection of
Row
objects with columns defined by a schema (column name and type). - DataFrameAsyncActor - Class in com.snowflake.snowpark_java
-
Provides APIs to execute DataFrame actions asynchronously.
- DataFrameNaFunctions - Class in com.snowflake.snowpark_java
-
Provides functions for handling missing values in a DataFrame.
- DataFrameReader - Class in com.snowflake.snowpark_java
-
Provides methods to load data in various supported formats from a Snowflake stage to a DataFrame.
- DataFrameStatFunctions - Class in com.snowflake.snowpark_java
-
Provides eagerly computed statistical functions for DataFrames.
- DataFrameWriter - Class in com.snowflake.snowpark_java
-
Provides methods for writing data from a DataFrame to supported output destinations.
- DataFrameWriterAsyncActor - Class in com.snowflake.snowpark_java
-
Provides APIs to execute DataFrameWriter actions asynchronously.
- dataType() - Method in class com.snowflake.snowpark_java.types.StructField
-
Retrieves the column data type.
- DataType - Class in com.snowflake.snowpark_java.types
-
Snowpark data types
- DataType() - Constructor for class com.snowflake.snowpark_java.types.DataType
- DataTypes - Class in com.snowflake.snowpark_java.types
-
This class contains all singleton DataTypes and factory methods.
- date_format(Column, String) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression into the corresponding date in the specified date format.
- date_from_parts(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a date from individual numeric components that represent the year, month, and day of the month.
- date_trunc(String, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Truncates a DATE, TIME, or TIMESTAMP to the specified precision.
- dateadd(String, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Adds the specified value for the specified date or time art to date or time expr.
- datediff(String, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Calculates the difference between two date, time, or timestamp columns based on the date or time part requested.
- DateType - Class in com.snowflake.snowpark_java.types
-
Date data type.
- DateType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the DateType object.
- dayname(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the three-letter day-of-week name from the specified date or timestamp.
- dayofmonth(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the day of month from a date or timestamp.
- dayofweek(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the day of week from a date or timestamp.
- dayofyear(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the day of year from a date or timestamp.
- DecimalType - Class in com.snowflake.snowpark_java.types
-
Decimal data type.
- degrees(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts radians to degrees.
- delete() - Method in class com.snowflake.snowpark_java.MatchedClauseBuilder
-
Defines a delete action for the matched clause, when a row in target is matched, delete it from target.
- delete() - Method in class com.snowflake.snowpark_java.Updatable
-
Deletes all rows in the updatable and returns a
DeleteResult
, representing number of rows deleted. - delete() - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.delete` asynchronously.
- delete(Column) - Method in class com.snowflake.snowpark_java.Updatable
-
Deletes all rows in the updatable that satisfy specified condition and returns a
DeleteResult
, representing number of rows deleted. - delete(Column) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.delete` asynchronously.
- delete(Column, DataFrame) - Method in class com.snowflake.snowpark_java.Updatable
-
Deletes all rows in the updatable that satisfy specified condition where condition includes columns in other
DataFrame
, and returns aDeleteResult
, representing number of rows deleted. - delete(Column, DataFrame) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.delete` asynchronously.
- DeleteResult - Class in com.snowflake.snowpark_java
-
Result of deleting rows in an Updatable
- dense_rank() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the rank of a value within a group of values, without gaps in the ranks.
- desc() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in descending order.
- desc(String) - Static method in class com.snowflake.snowpark_java.Functions
- desc_nulls_first() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in descending order, null values sorted before non-null values.
- desc_nulls_last() - Method in class com.snowflake.snowpark_java.Column
-
Sorts this column in descending order, null values sorted after non-null values.
- distinct() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains only the rows with distinct values from the current DataFrame.
- div0(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Performs division like the division operator (/), but returns 0 when the divisor is 0 (rather than reporting an error).
- divide(Column) - Method in class com.snowflake.snowpark_java.Column
-
Divide
- DoubleType - Class in com.snowflake.snowpark_java.types
-
Double data type.
- DoubleType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the DoubleType object.
- downloadStream(String, boolean) - Method in class com.snowflake.snowpark_java.FileOperation
-
Download file from the given stage and return an input stream
- drop(int, String[]) - Method in class com.snowflake.snowpark_java.DataFrameNaFunctions
-
Returns a new DataFrame that excludes all rows containing fewer than
minNonNullsPerRow
non-null and non-NaN values in the specified columnscols
. - drop(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that excludes the columns with the specified names from the output.
- drop(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that excludes the columns with the specified names from the output.
- dropDuplicates(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a new DataFrame by removing duplicated rows on given subset of columns.
E
- endPartition() - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF
- endswith(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns TRUE if expr ends with str.
- equal_nan() - Method in class com.snowflake.snowpark_java.Column
-
Is NaN.
- equal_nan(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the value in the column is not a number (NaN).
- equal_null(Column) - Method in class com.snowflake.snowpark_java.Column
-
Equal to.
- equal_to(Column) - Method in class com.snowflake.snowpark_java.Column
-
Equal to.
- equals(Object) - Method in class com.snowflake.snowpark_java.Row
-
Verifies the equality of two
Row
objects. - equals(Object) - Method in class com.snowflake.snowpark_java.types.ArrayType
-
Verifies if a DataType equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Compares this ColumnIdentifier with the giving one
- equals(Object) - Method in class com.snowflake.snowpark_java.types.DataType
-
Verifies if a DataType equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.DecimalType
-
Verifies if a DataType equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.Geography
-
Checks whether two Geography object are equal.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.Geometry
-
Checks whether two Geometry object are equal.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.MapType
-
Verifies if a DataType equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.StructField
-
Verifies if a StructField equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.StructType
-
Verifies if a StructType equals to this one.
- equals(Object) - Method in class com.snowflake.snowpark_java.types.Variant
-
Checks whether two Variants are equal.
- ErrorIfExists - com.snowflake.snowpark_java.SaveMode
- except(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains all the rows from the current DataFrame except for the rows that also appear in another DataFrame (`other`).
- exp(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes Euler's number e raised to a floating-point value.
- explain() - Method in class com.snowflake.snowpark_java.DataFrame
-
Prints the list of queries that will be executed to evaluate this DataFrame.
- explode(Column) - Static method in class com.snowflake.snowpark_java.TableFunctions
-
Flattens a given array or map type column into individual rows.
- expr(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a Column expression from row SQL text.
F
- factorial(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the factorial of its input.
- file() - Method in class com.snowflake.snowpark_java.Session
-
Returns a FileOperation object that you can use to perform file operations on stages.
- FileOperation - Class in com.snowflake.snowpark_java
-
Provides methods for working on files in a stage.
- fill(Map<String, ?>) - Method in class com.snowflake.snowpark_java.DataFrameNaFunctions
-
Returns a new DataFrame that replaces all null and NaN values in the specified columns with the values provided.
- filter(Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Filters rows based on the specified conditional expression (similar to WHERE in SQL).
- first() - Method in class com.snowflake.snowpark_java.DataFrame
-
Executes the query representing this DataFrame and returns the first row of results.
- first(int) - Method in class com.snowflake.snowpark_java.DataFrame
-
Executes the query representing this DataFrame and returns the first
n
rows of the results. - flatten() - Static method in class com.snowflake.snowpark_java.TableFunctions
-
Flattens (explodes) compound values into multiple rows.
- flatten(Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Flattens (explodes) compound values into multiple rows (similar to the SQL FLATTEN
- flatten(Column) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame by flattening compound values into multiple rows.
- flatten(Column) - Static method in class com.snowflake.snowpark_java.TableFunctions
-
Flattens (explodes) compound values into multiple rows.
- flatten(Column, String, boolean, boolean, String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Flattens (explodes) compound values into multiple rows (similar to the SQL FLATTEN
- flatten(Column, String, boolean, boolean, String) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame by flattening compound values into multiple rows.
- flatten(Column, String, boolean, boolean, String) - Static method in class com.snowflake.snowpark_java.TableFunctions
-
Flattens (explodes) compound values into multiple rows.
- FloatType - Class in com.snowflake.snowpark_java.types
-
Float data type.
- FloatType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the FloatType object.
- floor(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns values from the specified column rounded to the nearest equal or smaller integer.
- fromGeoJSON(String) - Static method in class com.snowflake.snowpark_java.types.Geography
-
Creates a Geography object from a GeoJSON string.
- fromGeoJSON(String) - Static method in class com.snowflake.snowpark_java.types.Geometry
-
Creates a Geometry object from a GeoJSON string.
- funcName() - Method in class com.snowflake.snowpark_java.TableFunction
-
Returns the function name.
- Functions - Class in com.snowflake.snowpark_java
-
Provides utility functions that generate Column expression that you can pass to DataFrame transformation methods.
G
- generator(long, Column...) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame via Generator function.
- Geography - Class in com.snowflake.snowpark_java.types
-
Java representation of Snowflake Geography data.
- GeographyType - Class in com.snowflake.snowpark_java.types
-
Geography data type.
- GeographyType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the GeographyType object.
- Geometry - Class in com.snowflake.snowpark_java.types
-
Java representation of Snowflake Geometry data.
- GeometryType - Class in com.snowflake.snowpark_java.types
-
Geography data type.
- GeometryType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the GeometryType object.
- geq(Column) - Method in class com.snowflake.snowpark_java.Column
-
Greater than or equal to.
- get(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of column in the
Row
at the given index. - get(int) - Method in class com.snowflake.snowpark_java.types.StructType
-
Retrieves the StructField object from the given index.
- get(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts a value from an object or array; returns NULL if either of the arguments is NULL.
- get(String, String) - Method in class com.snowflake.snowpark_java.FileOperation
-
Downloads the specified files from a path in a stage (specified by
stageLocation
) to the local directory specified bytargetLocation
. - get(String, String, Map<String, String>) - Method in class com.snowflake.snowpark_java.FileOperation
-
Downloads the specified files from a path in a stage (specified by
stageLocation
) to the local directory specified bytargetLocation
. - get_ignore_case(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts a field value from an object; returns NULL if either of the arguments is NULL.
- get_path(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts a value from semi-structured data using a path name.
- getAccessKeyId() - Method in class com.snowflake.snowpark_java.types.CloudProviderToken
- getBinary(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as an array of byte.
- getBoolean(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a boolean value.
- getByte(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a byte value.
- getCurrentDatabase() - Method in class com.snowflake.snowpark_java.Session
-
Returns the name of the current database for the JDBC session attached to this session.
- getCurrentSchema() - Method in class com.snowflake.snowpark_java.Session
-
Returns the name of the current schema for the JDBC session attached to this session.
- getDate(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Date value.
- getDecimal(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a BigDecimal value.
- getDefaultDatabase() - Method in class com.snowflake.snowpark_java.Session
-
Returns the name of the default database configured for this session in
Session.builder
. - getDefaultSchema() - Method in class com.snowflake.snowpark_java.Session
-
Returns the name of the default schema configured for this session in
Session.builder
. - getDependencies() - Method in class com.snowflake.snowpark_java.Session
-
Returns the list of URLs for all the dependencies that were added for user-defined functions (UDFs).
- getDouble(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a double value.
- getElementType() - Method in class com.snowflake.snowpark_java.types.ArrayType
-
Retrieves the type of this array's element.
- getEncryption() - Method in class com.snowflake.snowpark_java.GetResult
-
Retrieves the encryption status
- getEncryption() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the encryption status
- getFileName() - Method in class com.snowflake.snowpark_java.GetResult
-
Retrieves the file name
- getFloat(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a float value.
- getFullyQualifiedCurrentSchema() - Method in class com.snowflake.snowpark_java.Session
-
Returns the fully qualified name of the current schema for the session.
- getGeography(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Geography value.
- getGeometry(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Geometry value.
- getInputStream() - Method in class com.snowflake.snowpark_java.types.SnowflakeFile
-
Obtain and return the input stream for the file.
- getInt(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a int value.
- getIterator() - Method in class com.snowflake.snowpark_java.AsyncJob
-
Returns an iterator of Row objects that you can use to retrieve the results for the underlying query.
- getIterator(int) - Method in class com.snowflake.snowpark_java.AsyncJob
-
Returns an iterator of Row objects that you can use to retrieve the results for the underlying query.
- getKeyType() - Method in class com.snowflake.snowpark_java.types.MapType
-
Retrieves the data type of this MapType's key.
- getList(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a list of Object.
- getListOfVariant(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a list of Variant.
- getLong(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a long value.
- getMap(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Java Map
- getMapOfVariant(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a map of Variant
- getMessage() - Method in class com.snowflake.snowpark_java.GetResult
-
Retrieves the message
- getMessage() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the message
- getMultiJoinedRowsUpdated() - Method in class com.snowflake.snowpark_java.UpdateResult
-
Retrieves the number of multi-joined row has been updated.
- getName() - Method in class com.snowflake.snowpark_java.Column
-
Retrieves the column name (if the column has a name).
- getName() - Method in class com.snowflake.snowpark_java.StoredProcedure
-
Get the name of the given stored procedure
- getObject(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Row
- getOrCreate() - Method in class com.snowflake.snowpark_java.SessionBuilder
-
Returns the existing session if already exists or create it if not.
- getPrecision() - Method in class com.snowflake.snowpark_java.types.DecimalType
-
Retrieves the precision of this decimal number.
- getQueryId() - Method in class com.snowflake.snowpark_java.AsyncJob
-
Get the query ID for the underlying query.
- getQueryTag() - Method in class com.snowflake.snowpark_java.Session
-
Returns the query tag that you set by calling
setQueryTag
. - getResult() - Method in class com.snowflake.snowpark_java.TypedAsyncJob
-
Returns the result for the specific DataFrame action.
- getResult(int) - Method in class com.snowflake.snowpark_java.TypedAsyncJob
-
Returns the result for the specific DataFrame action.
- GetResult - Class in com.snowflake.snowpark_java
-
Represents the results of downloading a file from a stage location to the local file system.
- getRows() - Method in class com.snowflake.snowpark_java.AsyncJob
-
Returns an Array of Row objects that represent the results of the underlying query.
- getRows() - Method in class com.snowflake.snowpark_java.WriteFileResult
-
Retrieve the output rows produced by the COPY INTO <location> command.
- getRows(int) - Method in class com.snowflake.snowpark_java.AsyncJob
-
Returns an Array of Row objects that represent the results of the underlying query.
- getRowsDeleted() - Method in class com.snowflake.snowpark_java.DeleteResult
-
Retrieves the number of rows have deleted.
- getRowsDeleted() - Method in class com.snowflake.snowpark_java.MergeResult
-
Retrieves the number of rows have been deleted.
- getRowsInserted() - Method in class com.snowflake.snowpark_java.MergeResult
-
Retrieves the number of rows have been inserted.
- getRowsUpdated() - Method in class com.snowflake.snowpark_java.MergeResult
-
Retrieves the number of rows have been updated.
- getRowsUpdated() - Method in class com.snowflake.snowpark_java.UpdateResult
-
Retrieves the number of row has been updated.
- getScale() - Method in class com.snowflake.snowpark_java.types.DecimalType
-
Retrieves the scale of this decimal number.
- getSchema() - Method in class com.snowflake.snowpark_java.WriteFileResult
-
Retrieve the names and types of the fields in the output rows.
- getSecretAccessKey() - Method in class com.snowflake.snowpark_java.types.CloudProviderToken
- getSessionInfo() - Method in class com.snowflake.snowpark_java.Session
-
Get the session information.
- getSessionStage() - Method in class com.snowflake.snowpark_java.Session
-
Returns the name of the temporary stage created by the Snowpark library for uploading and store temporary artifacts for this session.
- getShort(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a short value.
- getSize() - Method in class com.snowflake.snowpark_java.types.SnowflakeFile
-
Total size of the file obtained from the cloud storage provider when available, returns null otherwise.
- getSizeBytes() - Method in class com.snowflake.snowpark_java.GetResult
-
Retrieves the file size in bytes
- getSourceCompression() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the source file compression status
- getSourceFileName() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the source file name
- getSourceSizeBytes() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the source file size in bytes
- getStatus() - Method in class com.snowflake.snowpark_java.GetResult
-
Retrieves the file status
- getStatus() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the status
- getString(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a String value.
- getTargetCompression() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the target file compression status
- getTargetFileName() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the target file name
- getTargetSizeBytes() - Method in class com.snowflake.snowpark_java.PutResult
-
Retrieves the target file size in bytes
- getTime(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Time value.
- getTimestamp(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Timestamp value.
- getToken() - Method in class com.snowflake.snowpark_java.types.CloudProviderToken
- getValueType() - Method in class com.snowflake.snowpark_java.types.MapType
-
Retrieves the data type of this MapType's value.
- getVariant(int) - Method in class com.snowflake.snowpark_java.Row
-
Retrieves the value of the column at the given index as a Variant value.
- greatest(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the largest value from a list of expressions.
- groupBy(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Groups rows by the columns specified by expressions (similar to GROUP BY in SQL).
- groupBy(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Groups rows by the columns specified by name (similar to GROUP BY in SQL).
- groupByGroupingSets(GroupingSets...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs an SQL GROUP BY GROUPING SETS on the DataFrame.
- grouping(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
- grouping_id(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Describes which of a list of expressions are grouped in a row produced by a GROUP BY query.
- GroupingSets - Class in com.snowflake.snowpark_java
-
A Container of grouping sets that you pass to
DataFrame.groupByGroupingSets
- gt(Column) - Method in class com.snowflake.snowpark_java.Column
-
Greater than.
H
- HasCachedResult - Class in com.snowflake.snowpark_java
-
A DataFrame that returns cached data.
- hash(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a signed 64-bit hash value.
- hashCode() - Method in class com.snowflake.snowpark_java.Row
-
Calculates the hash code of this Row object
- hashCode() - Method in class com.snowflake.snowpark_java.types.ArrayType
-
Calculates the hash code of this Array Type Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Calculates the hash code of this ColumnIdentifier.
- hashCode() - Method in class com.snowflake.snowpark_java.types.DataType
-
Calculates the hash code of this DataType Type Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.DecimalType
-
Calculates the hash code of this Decimal Type Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.Geography
-
Calculates the hash code of this Geography Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.Geometry
-
Calculates the hash code of this Geometry Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.MapType
-
Calculates the hash code of this Map Type Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.StructField
-
Calculates the hash code of this StructField Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.StructType
-
Calculates the hash code of this StructType Object.
- hashCode() - Method in class com.snowflake.snowpark_java.types.Variant
-
Calculates the hash code of this Variant Object.
- hex(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes hex value of the given column.
- hour(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the hour from a date or timestamp.
I
- iff(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns one of two specified expressions, depending on a condition.
- Ignore - com.snowflake.snowpark_java.SaveMode
- in(Column[], DataFrame) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
- in(Column[], List<List<Object>>) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
- in(DataFrame) - Method in class com.snowflake.snowpark_java.Column
-
Returns a conditional expression that you can pass to the filter or where method to perform a WHERE ...
- in(Object...) - Method in class com.snowflake.snowpark_java.Column
-
Returns a conditional expression that you can pass to the filter or where method to perform the equivalent of a WHERE ...
- initcap(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the input string with the first letter of each word in uppercase and the subsequent letters in lowercase.
- inputSchema() - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF
- insert(Column[]) - Method in class com.snowflake.snowpark_java.NotMatchedClauseBuilder
-
Defines an insert action for the not matched clause, when a row in source is not matched, insert a row in target with 'values'.
- insert(Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Replaces a substring of the specified length, starting at the specified position, with a new string or binary value.
- insert(Map<Column, Column>) - Method in class com.snowflake.snowpark_java.NotMatchedClauseBuilder
-
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.
- insertRow(Map<String, Column>) - Method in class com.snowflake.snowpark_java.NotMatchedClauseBuilder
-
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.
- IntegerType - Class in com.snowflake.snowpark_java.types
-
Integer data type.
- IntegerType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the IntegerType object.
- intersect(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains the intersection of rows from the current DataFrame and another DataFrame (`other`).
- is_array(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains an ARRAY value.
- is_binary(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a binary value.
- is_boolean(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a Boolean value.
- is_char(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a string value.
- is_date(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a DATE value.
- is_date_value(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a DATE value.
- is_decimal(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a fixed-point decimal value or integer.
- is_double(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
- is_integer(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains an integer value.
- is_not_null() - Method in class com.snowflake.snowpark_java.Column
-
Is not null.
- is_null() - Method in class com.snowflake.snowpark_java.Column
-
Is null.
- is_null(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the value in the column is null.
- is_null_value(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column is a JSON null value.
- is_object(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains an OBJECT value.
- is_real(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a floating-point value, fixed-point decimal, or integer.
- is_time(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a TIME value.
- is_timestamp_ltz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a TIMESTAMP value to be interpreted using the local time zone.
- is_timestamp_ntz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a TIMESTAMP value with no time zone.
- is_timestamp_tz(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a TIMESTAMP value with a time zone.
- is_varchar(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if the specified VARIANT column contains a string value.
- isDone() - Method in class com.snowflake.snowpark_java.AsyncJob
-
Returns true if the underlying query completed.
- isnull(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Wrapper for Snowflake built-in isnull function.
- isNull() - Method in class com.snowflake.snowpark_java.Column
-
Wrapper for is_null function.
- isNullAt(int) - Method in class com.snowflake.snowpark_java.Row
-
Verifies if the value of the column at the given index is null.
- iterator() - Method in class com.snowflake.snowpark_java.types.StructType
-
Creates an Iterator of StructFields.
J
- JavaSProc0<RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 0 argument.
- JavaSProc1<A1,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 1 argument.
- JavaSProc10<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 10 arguments.
- JavaSProc11<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 11 arguments.
- JavaSProc12<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 12 arguments.
- JavaSProc13<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 13 arguments.
- JavaSProc14<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 14 arguments.
- JavaSProc15<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 15 arguments.
- JavaSProc16<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 16 arguments.
- JavaSProc17<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 17 arguments.
- JavaSProc18<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 18 arguments.
- JavaSProc19<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 19 arguments.
- JavaSProc2<A1,A2,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 2 arguments.
- JavaSProc20<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 20 arguments.
- JavaSProc21<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 21 arguments.
- JavaSProc3<A1,A2,A3,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 3 arguments.
- JavaSProc4<A1,A2,A3,A4,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 4 arguments.
- JavaSProc5<A1,A2,A3,A4,A5,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 5 arguments.
- JavaSProc6<A1,A2,A3,A4,A5,A6,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 6 arguments.
- JavaSProc7<A1,A2,A3,A4,A5,A6,A7,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 7 arguments.
- JavaSProc8<A1,A2,A3,A4,A5,A6,A7,A8,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 8 arguments.
- JavaSProc9<A1,A2,A3,A4,A5,A6,A7,A8,A9,RT> - Interface in com.snowflake.snowpark_java.sproc
-
A Java SProc interface that has 9 arguments.
- JavaUDF0<RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 0 argument.
- JavaUDF1<A1,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 1 argument.
- JavaUDF10<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 10 arguments.
- JavaUDF11<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 11 arguments.
- JavaUDF12<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 12 arguments.
- JavaUDF13<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 13 arguments.
- JavaUDF14<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 14 arguments.
- JavaUDF15<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 15 arguments.
- JavaUDF16<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 16 arguments.
- JavaUDF17<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 17 arguments.
- JavaUDF18<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 18 arguments.
- JavaUDF19<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 19 arguments.
- JavaUDF2<A1,A2,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 2 arguments.
- JavaUDF20<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 20 arguments.
- JavaUDF21<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 21 arguments.
- JavaUDF22<A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 22 arguments.
- JavaUDF3<A1,A2,A3,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 3 arguments.
- JavaUDF4<A1,A2,A3,A4,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 4 arguments.
- JavaUDF5<A1,A2,A3,A4,A5,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 5 arguments.
- JavaUDF6<A1,A2,A3,A4,A5,A6,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 6 arguments.
- JavaUDF7<A1,A2,A3,A4,A5,A6,A7,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 7 arguments.
- JavaUDF8<A1,A2,A3,A4,A5,A6,A7,A8,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 8 arguments.
- JavaUDF9<A1,A2,A3,A4,A5,A6,A7,A8,A9,RT> - Interface in com.snowflake.snowpark_java.udf
-
A Java UDF interface that has 9 arguments.
- JavaUDTF - Interface in com.snowflake.snowpark_java.udtf
-
The base interface for JavaUDTF[N].
- JavaUDTF0 - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 0 arguments.
- JavaUDTF1<A0> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 1 argument.
- JavaUDTF10<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 10 arguments.
- JavaUDTF11<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 11 arguments.
- JavaUDTF12<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 12 arguments.
- JavaUDTF13<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 13 arguments.
- JavaUDTF14<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 14 arguments.
- JavaUDTF15<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 15 arguments.
- JavaUDTF16<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 16 arguments.
- JavaUDTF17<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 17 arguments.
- JavaUDTF18<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 18 arguments.
- JavaUDTF19<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 19 arguments.
- JavaUDTF2<A0,A1> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 2 arguments.
- JavaUDTF20<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 20 arguments.
- JavaUDTF21<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 21 arguments.
- JavaUDTF22<A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 22 arguments.
- JavaUDTF3<A0,A1,A2> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 3 arguments.
- JavaUDTF4<A0,A1,A2,A3> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 4 arguments.
- JavaUDTF5<A0,A1,A2,A3,A4> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 5 arguments.
- JavaUDTF6<A0,A1,A2,A3,A4,A5> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 6 arguments.
- JavaUDTF7<A0,A1,A2,A3,A4,A5,A6> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 7 arguments.
- JavaUDTF8<A0,A1,A2,A3,A4,A5,A6,A7> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 8 arguments.
- JavaUDTF9<A0,A1,A2,A3,A4,A5,A6,A7,A8> - Interface in com.snowflake.snowpark_java.udtf
-
A Java UDTF interface that has 9 arguments.
- jdbcConnection() - Method in class com.snowflake.snowpark_java.Session
-
Returns the JDBC Connection object used for the connection to the Snowflake database.
- join(Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified table function `func`.
- join(Column, Column[], Column[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified table function `func`.
- join(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a default inner join of the current DataFrame and another DataFrame (`right`).
- join(DataFrame, Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a default inner join of the current DataFrame and another DataFrame (`right`) using the join condition specified in an expression (`joinExpr`).
- join(DataFrame, Column, String) - Method in class com.snowflake.snowpark_java.DataFrame
-
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`).
- join(DataFrame, String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a default inner join of the current DataFrame and another DataFrame (`right`) on a column (`usingColumn`).
- join(DataFrame, String[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a default inner join of the current DataFrame and another DataFrame (`right`) on a list of columns (`usingColumns`).
- join(DataFrame, String[], String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a join of the specified type (`joinType`) with the current DataFrame and another DataFrame (`right`) on a list of columns (`usingColumns`).
- join(TableFunction, Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified table function `func`.
- join(TableFunction, Column[], Column[], Column[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified user-defined table function (UDTF) `func`.
- join(TableFunction, Map<String, Column>) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified table function `func` that takes named parameters (e.g.
- join(TableFunction, Map<String, Column>, Column[], Column[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Joins the current DataFrame with the output of the specified user-defined table function (UDTF) `func`.
- json(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified JSON file.
- json(String) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Saves the contents of the DataFrame to a JSON file on a stage.
- json(String) - Method in class com.snowflake.snowpark_java.DataFrameWriterAsyncActor
-
Executes `DataFrameWriter.json()` asynchronously.
- json_extract_path_text(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Parses a JSON string and returns the value of an element at a specified path in the resulting JSON document.
K
- kurtosis(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the population excess kurtosis of non-NULL records.
L
- lag(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a previous row in the same result set without having to join the table to itself.
- lag(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a previous row in the same result set without having to join the table to itself.
- lag(Column, int, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a previous row in the same result set without having to join the table to itself.
- last(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the last value of the column in a group.
- last_day(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the last day of the specified date part for a date or timestamp.
- lead(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a subsequent row in the same result set without having to join the table to itself.
- lead(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a subsequent row in the same result set without having to join the table to itself.
- lead(Column, int, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Accesses data in a subsequent row in the same result set without having to join the table to itself.
- least(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the smallest value from a list of expressions.
- left(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a left most substring of strExpr.
- length(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the length of an input string or binary value.
- leq(Column) - Method in class com.snowflake.snowpark_java.Column
-
Less than or equal to.
- like(Column) - Method in class com.snowflake.snowpark_java.Column
-
Allows case-sensitive matching of strings based on comparison with a pattern.
- limit(int) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains at most `n` rows from the current DataFrame (similar to LIMIT in SQL).
- listagg(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by empty string.
- listagg(Column, String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by `delimiter` string.
- listagg(Column, String, boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by `delimiter` string.
- lit(Object) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a Column expression for a literal value.
- locate(Column, Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Locate the position of the first occurrence of substr in a string column, after position pos.
- locate(String, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Locate the position of the first occurrence of substr in a string column, after position pos.
- log(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the logarithm of a numeric expression.
- log10(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the logarithm of the given value in base 10.
- log10(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the logarithm of the given value in base 10.
- log1p(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the logarithm of the given value in base 10.
- log1p(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the logarithm of the given value in base 10.
- LongType - Class in com.snowflake.snowpark_java.types
-
Long integer data type.
- LongType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the LongType object.
- lower(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the input string with all characters converted to lowercase.
- lpad(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Left-pads a string with characters from another string, or left-pads a binary value with bytes from another binary value.
- lt(Column) - Method in class com.snowflake.snowpark_java.Column
-
Less than.
- ltrim(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes leading characters, including whitespace, from a string.
- ltrim(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes leading characters, including whitespace, from a string.
M
- MapType - Class in com.snowflake.snowpark_java.types
-
Map data type.
- MatchedClauseBuilder - Class in com.snowflake.snowpark_java
-
Builder for a matched clause.
- max(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the maximum value for the records in a group.
- max(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the max for the specified numeric columns.
- max(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the maximum value for the records in a group.
- MAX_PRECISION - Static variable in class com.snowflake.snowpark_java.types.DecimalType
- MAX_SCALE - Static variable in class com.snowflake.snowpark_java.types.DecimalType
- md5(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a 32-character hex-encoded string containing the 128-bit MD5 message digest.
- mean(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the average of non-NULL records.
- mean(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the average for the specified numeric columns.
- mean(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the average of non-NULL records.
- median(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the median value for the records in a group.
- median(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the median for the specified numeric columns.
- merge(DataFrame, Column) - Method in class com.snowflake.snowpark_java.Updatable
-
Initiates a merge action for this updatable with
DataFrame
source on specified join expression. - MergeBuilder - Class in com.snowflake.snowpark_java
-
Builder for a merge action.
- MergeBuilderAsyncActor - Class in com.snowflake.snowpark_java
-
Provides APIs to execute MergeBuilder actions asynchronously.
- MergeResult - Class in com.snowflake.snowpark_java
-
Result of merging a DataFrame into an Updatable DataFrame
- min(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the minimum value for the records in a group.
- min(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the min for the specified numeric columns.
- min(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the minimum value for the records in a group.
- minus(Column) - Method in class com.snowflake.snowpark_java.Column
-
Minus
- minute(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the minute from a date or timestamp.
- mod(Column) - Method in class com.snowflake.snowpark_java.Column
-
Remainder
- mode(SaveMode) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Returns a new DataFrameWriter with the specified save mode configuration.
- mode(String) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Returns a new DataFrameWriter with the specified save mode configuration.
- month(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the month from a date or timestamp.
- monthname(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the three-letter month name from the specified date or timestamp.
- multiply(Column) - Method in class com.snowflake.snowpark_java.Column
-
Multiply
N
- na() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a
DataFrameNaFunctions
object that provides functions for handling missing values in the DataFrame. - name() - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Returns the name of column.
- name() - Method in class com.snowflake.snowpark_java.types.StructField
-
Retrieves the column name.
- names() - Method in class com.snowflake.snowpark_java.types.StructType
-
Retrieves the names of StructField.
- nameToField(String) - Method in class com.snowflake.snowpark_java.types.StructType
-
Retrieves the corresponding StructField object of the given name.
- naturalJoin(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a natural join (a default inner join) of the current DataFrame and another DataFrame (`right`).
- naturalJoin(DataFrame, String) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a natural join of the specified type (`joinType`) with the current DataFrame and another DataFrame (`right`).
- negate(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the negation of the value in the column (equivalent to a unary minus).
- newInstance(String) - Static method in class com.snowflake.snowpark_java.types.SnowflakeFile
-
Create a new instance of SnowflakeFile.
- newInstance(String, boolean) - Static method in class com.snowflake.snowpark_java.types.SnowflakeFile
-
Create a new instance of SnowflakeFile.
- newInstanceFromOwnerFileUrl(String) - Static method in class com.snowflake.snowpark_java.types.SnowflakeFile
-
Deprecated.Use newInstance(String, bool) instead.
- next_day(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the date of the first specified DOW (day of week) that occurs after the input date.
- not(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the inverse of a boolean expression.
- not_equal(Column) - Method in class com.snowflake.snowpark_java.Column
-
Not equal to.
- NotMatchedClauseBuilder - Class in com.snowflake.snowpark_java
-
Builder for a not matched clause.
- ntile(int) - Static method in class com.snowflake.snowpark_java.Functions
-
Window function: returns the ntile group id (from 1 to `n` inclusive) in an ordered window partition.
- ntile(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Divides an ordered data set equally into the number of buckets specified by n.
- nullable() - Method in class com.snowflake.snowpark_java.types.StructField
-
Verifies if this column is nullable.
O
- object_construct(Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an OBJECT constructed from the arguments.
- object_delete(Column, Column, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an object containing the contents of the input (i.e.source) object with one or more keys removed.
- object_insert(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an object consisting of the input object with a new key-value pair inserted.
- object_insert(Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an object consisting of the input object with a new key-value pair inserted (or an existing key updated with a new value).
- object_keys(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns an array containing the list of keys in the input object.
- object_pick(Column, Column, Column...) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a new OBJECT containing some of the key-value pairs from an existing object.
- objectagg(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns one OBJECT per group.
- option(String, Object) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Sets the specified option in the DataFrameReader.
- option(String, Object) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Sets the specified option in the DataFrameWriter.
- options(Map<String, Object>) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Sets multiple specified options in the DataFrameReader.
- options(Map<String, Object>) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Sets multiple specified options in the DataFrameWriter.
- or(Column) - Method in class com.snowflake.snowpark_java.Column
-
Or.
- orc(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified ORC file.
- orderBy(Column...) - Static method in class com.snowflake.snowpark_java.Window
-
Returns WindowSpec object with order by clause.
- orderBy(Column...) - Method in class com.snowflake.snowpark_java.WindowSpec
-
Returns a new WindowSpec object with the new order by clause.
- otherwise(Column) - Method in class com.snowflake.snowpark_java.CaseExpr
-
Sets the default result for this CASE expression.
- outputSchema() - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF
- over() - Method in class com.snowflake.snowpark_java.Column
-
Returns a windows frame, based on the specified WindowSpec.
- over(WindowSpec) - Method in class com.snowflake.snowpark_java.Column
-
Returns a windows frame, based on the specified WindowSpec.
- Overwrite - com.snowflake.snowpark_java.SaveMode
P
- parquet(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified Parquet file.
- parquet(String) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Saves the contents of the DataFrame to a Parquet file on a stage.
- parquet(String) - Method in class com.snowflake.snowpark_java.DataFrameWriterAsyncActor
-
Executes `DataFrameWriter.parquet()` asynchronously.
- parse_json(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Parse the value of the specified column as a JSON string and returns the resulting JSON document.
- parse_xml(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Parse the value of the specified column as a JSON string and returns the resulting XML document.
- partitionBy(Column...) - Static method in class com.snowflake.snowpark_java.Window
-
Returns WindowSpec object with partition by clause.
- partitionBy(Column...) - Method in class com.snowflake.snowpark_java.WindowSpec
-
Returns a new WindowSpec object with the new partition by clause.
- percent_rank() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the relative rank of a value within a group of values, specified as a percentage ranging from 0.0 to 1.0.
- pivot(Column, Object[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
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.
- pivot(String, Object[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
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.
- plus(Column) - Method in class com.snowflake.snowpark_java.Column
-
Plus
- pow(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a number (l) raised to the specified power (r).
- previous_day(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the date of the first specified DOW (day of week) that occurs before the input date.
- printTreeString() - Method in class com.snowflake.snowpark_java.types.StructType
-
Prints the schema StructType content in a tree structure diagram.
- process() - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF0
- process(A0) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF1
- process(A0, A1) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF2
- process(A0, A1, A2) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF3
- process(A0, A1, A2, A3) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF4
- process(A0, A1, A2, A3, A4) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF5
- process(A0, A1, A2, A3, A4, A5) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF6
- process(A0, A1, A2, A3, A4, A5, A6) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF7
- process(A0, A1, A2, A3, A4, A5, A6, A7) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF8
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF9
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF10
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF11
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF12
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF13
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF14
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF15
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF16
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF17
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF18
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF19
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF20
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF21
- process(A0, A1, A2, A3, A4, A5, A6, A7, A8, A9, A10, A11, A12, A13, A14, A15, A16, A17, A18, A19, A20, A21) - Method in interface com.snowflake.snowpark_java.udtf.JavaUDTF22
- PublicPreview - Annotation Type in com.snowflake.snowpark
-
The annotation of all Snowpark public preview features.
- put(String, String) - Method in class com.snowflake.snowpark_java.FileOperation
-
Uploads the local files specified by
localFileName
to the stage location specified instageLocation
. - put(String, String, Map<String, String>) - Method in class com.snowflake.snowpark_java.FileOperation
-
Uploads the local files specified by
localFileName
to the stage location specified instageLocation
. - PutResult - Class in com.snowflake.snowpark_java
-
Represents the results of uploading a local file to a stage location.
Q
- quarter(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the quarter from a date or timestamp.
- quotedName() - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Returns the quoted name of this column Name Format: 1.
R
- radians(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts degrees to radians.
- randn() - Static method in class com.snowflake.snowpark_java.Functions
-
Generate a column with independent and identically distributed (i.i.d.) samples from the standard normal distribution.
- randn(long) - Static method in class com.snowflake.snowpark_java.Functions
-
Generate a column with independent and identically distributed (i.i.d.) samples from the standard normal distribution.
- random() - Static method in class com.snowflake.snowpark_java.Functions
-
Each call returns a pseudo-random 64-bit integer.
- random(long) - Static method in class com.snowflake.snowpark_java.Functions
-
Each call returns a pseudo-random 64-bit integer.
- randomSplit(double[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Randomly splits the current DataFrame into separate DataFrames, using the specified weights.
- range(long) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from a range of numbers starting from 0.
- range(long, long) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from a range of numbers.
- range(long, long, long) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from a range of numbers.
- rangeBetween(long, long) - Static method in class com.snowflake.snowpark_java.Window
-
Returns WindowSpec object with range frame clause.
- rangeBetween(long, long) - Method in class com.snowflake.snowpark_java.WindowSpec
-
Returns a new WindowSpec object with the new range frame clause.
- rank() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the rank of a value within an ordered group of values.
- read() - Method in class com.snowflake.snowpark_java.Session
-
Returns a DataFrameReader that you can use to read data from various supported sources (e.g.
- regexp(Column) - Method in class com.snowflake.snowpark_java.Column
-
Returns true if this column matches the specified regular expression.
- regexp_count(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the number of times that a pattern occurs in a strExpr.
- regexp_count(Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the number of times that a pattern occurs in a strExpr.
- regexp_extract(Column, String, Integer, Integer, Integer) - Static method in class com.snowflake.snowpark_java.Functions
-
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.
- regexp_replace(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the subject with the specified pattern (or all occurrences of the pattern) removed.
- regexp_replace(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the subject with the specified pattern (or all occurrences of the pattern) replaced by a replacement string.
- registerPermanent(String, JavaSProc0<?>, DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 0 argument as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc1<?, ?>, DataType, DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 1 argument as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 10 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 11 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 12 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 13 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 14 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 15 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 16 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 17 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 18 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 19 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc2<?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 2 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 20 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 21 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc3<?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 3 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc4<?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 4 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc5<?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 5 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 6 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 7 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 8 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaSProc9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String, boolean) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 9 arguments as a permanent Snowflake Stored Procedure.
- registerPermanent(String, JavaUDF0<?>, DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 0 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF1<?, ?>, DataType, DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 1 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 10 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 11 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 12 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 13 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 14 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 15 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 16 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 17 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 18 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 19 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF2<?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 2 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 20 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 21 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 22 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF3<?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 3 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF4<?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 4 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF5<?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 5 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 6 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 7 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 8 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDF9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType, String) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 9 argument as a Snowflake Java UDF.
- registerPermanent(String, JavaUDTF, String) - Method in class com.snowflake.snowpark_java.UDTFRegistration
-
Registers an UDTF instance as a Snowflake UDTF.
- registerTemporary(JavaSProc0<?>, DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 0 argument as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc1<?, ?>, DataType, DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 1 argument as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 10 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 11 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 12 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 13 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 14 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 15 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 16 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 17 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 18 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 19 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc2<?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 2 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 20 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 21 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc3<?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 3 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc4<?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 4 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc5<?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 5 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 6 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 7 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 8 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaSProc9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 9 arguments as a temporary anonymous Stored Procedure that is scoped to this session.
- registerTemporary(JavaUDF0<?>, DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 0 argument as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF1<?, ?>, DataType, DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 1 argument as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 10 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 11 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 12 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 13 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 14 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 15 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 16 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 17 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 18 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 19 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF2<?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 2 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 20 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 21 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 22 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF3<?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 3 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF4<?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 4 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF5<?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 5 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 6 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 7 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 8 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDF9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 9 arguments as a temporary anonymous UDF that is scoped to this session.
- registerTemporary(JavaUDTF) - Method in class com.snowflake.snowpark_java.UDTFRegistration
-
Registers an UDTF instance as a temporary anonymous UDTF that is scoped to this session.
- registerTemporary(String, JavaSProc0<?>, DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 0 argument as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc1<?, ?>, DataType, DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 1 argument as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 10 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 11 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 12 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 13 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 14 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 15 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 16 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 17 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 18 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 19 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc2<?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 2 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 20 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 21 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc3<?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 3 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc4<?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 4 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc5<?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 5 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 6 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 7 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 8 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaSProc9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Registers a Java Lambda of 9 arguments as a temporary named Stored Procedure that is scoped to this session.
- registerTemporary(String, JavaUDF0<?>, DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 0 argument as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF1<?, ?>, DataType, DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 1 argument as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 10 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 11 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 12 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 13 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 14 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 15 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 16 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 17 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 18 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 19 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF2<?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 2 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 20 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 21 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 22 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF3<?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 3 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF4<?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 4 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF5<?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 5 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 6 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 7 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 8 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDF9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Method in class com.snowflake.snowpark_java.UDFRegistration
-
Registers a Java Lambda of 9 arguments as a temporary UDF that is scoped to this session.
- registerTemporary(String, JavaUDTF) - Method in class com.snowflake.snowpark_java.UDTFRegistration
-
Registers an UDTF instance as a temporary Snowflake UDTF that you plan to use in the session.
- RelationalGroupedDataFrame - Class in com.snowflake.snowpark_java
-
Represents an underlying DataFrame with rows that are grouped by common values.
- removeDependency(String) - Method in class com.snowflake.snowpark_java.Session
-
Removes a path from the set of dependencies.
- rename(String, Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrame with the specified column `col` renamed as `newName`.
- repeat(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Builds a string by repeating the input for the specified number of times.
- replace(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
- replace(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
- replace(String, Map<?, ?>) - Method in class com.snowflake.snowpark_java.DataFrameNaFunctions
-
Returns a new DataFrame that replaces values in a specified column.
- reverse(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Wrapper for Snowflake built-in reverse function.
- right(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a right most substring of strExpr.
- rollup(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs an SQL GROUP BY ROLLUP on the DataFrame.
- rollup(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs an SQL GROUP BY ROLLUP on the DataFrame.
- round(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Rounds the numeric values of the given column
e
to 0 decimal places using the half away from zero rounding mode. - round(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Rounds the numeric values of the given column
e
to thescale
decimal places using the half away from zero rounding mode. - round(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Rounds the numeric values of the given column
e
to thescale
decimal places using the half away from zero rounding mode. - Row - Class in com.snowflake.snowpark_java
-
Represents a row returned by the evaluation of a
DataFrame
. - Row(Object[]) - Constructor for class com.snowflake.snowpark_java.Row
-
Creates a
Row
based on the values in the given array. - row_number() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a unique row number for each row within a window partition.
- rowsBetween(long, long) - Static method in class com.snowflake.snowpark_java.Window
-
Returns WindowSpec object with row frame clause.
- rowsBetween(long, long) - Method in class com.snowflake.snowpark_java.WindowSpec
-
Returns a new WindowSpec object with the new row frame clause.
- rpad(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Right-pads a string with characters from another string, or right-pads a binary value with bytes from another binary value.
- rtrim(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes trailing characters, including whitespace, from a string.
- rtrim(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes trailing characters, including whitespace, from a string.
- runLocally(JavaSProc, Object...) - Method in class com.snowflake.snowpark_java.SProcRegistration
-
Executes a Stored Procedure lambda function with current Snowpark session in the local environment.
S
- sample(double) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains a sampling of rows from the current DataFrame.
- sample(long) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame with a sample of N rows from the underlying DataFrame.
- sampleBy(Column, Map<?, Double>) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Returns a DataFrame containing a stratified sample without replacement, based on a Map that specifies the fraction for each stratum.
- sampleBy(String, Map<?, Double>) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Returns a DataFrame containing a stratified sample without replacement, based on a Map that specifies the fraction for each stratum.
- saveAsTable(String) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Writes the data to the specified table in a Snowflake database.
- saveAsTable(String) - Method in class com.snowflake.snowpark_java.DataFrameWriterAsyncActor
-
Executes `DataFrameWriter.saveAsTable` asynchronously.
- saveAsTable(String[]) - Method in class com.snowflake.snowpark_java.DataFrameWriter
-
Writes the data to the specified table in a Snowflake database.
- saveAsTable(String[]) - Method in class com.snowflake.snowpark_java.DataFrameWriterAsyncActor
-
Executes `DataFrameWriter.saveAsTable` asynchronously.
- SaveMode - Enum in com.snowflake.snowpark_java
-
SaveMode configures the behavior when data is written from a DataFrame to a data source using a DataFrameWriter instance.
- schema() - Method in class com.snowflake.snowpark_java.DataFrame
-
Retrieves the definition of the columns in this DataFrame (the "relational schema" for the DataFrame).
- schema(StructType) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a DataFrameReader instance with the specified schema configuration for the data to be read.
- second(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the second from a date or timestamp.
- select(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Generates a new DataFrame with the specified Column expressions as output (similar to SELECT in SQL).
- select(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame with a subset of named columns (similar to SELECT in SQL).
- seq1() - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq1(boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq2() - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq2(boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq4() - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq4(boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq8() - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- seq8(boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a sequence of monotonically increasing integers, with wrap-around.
- session - Variable in class com.snowflake.snowpark_java.DataFrameAsyncActor
- Session - Class in com.snowflake.snowpark_java
-
Establishes a connection with a Snowflake database and provides methods for creating DataFrames and accessing objects for working with files in stages.
- SessionBuilder - Class in com.snowflake.snowpark_java
-
Provides methods to set configuration properties and create a
Session
. - setQueryTag(String) - Method in class com.snowflake.snowpark_java.Session
-
Sets a query tag for this session.
- sha1(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a 40-character hex-encoded string containing the 160-bit SHA-1 message digest.
- sha2(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a hex-encoded string containing the N-bit SHA-2 message digest, where N is the specified output digest size.
- shiftleft(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Shift the given value numBits left.
- shiftright(Column, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Shift the given value numBits right.
- ShortType - Class in com.snowflake.snowpark_java.types
-
Short integer data type.
- ShortType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the ShortType object.
- show() - Method in class com.snowflake.snowpark_java.DataFrame
-
Evaluates this DataFrame and prints out the first ten rows.
- show(int) - Method in class com.snowflake.snowpark_java.DataFrame
-
Evaluates this DataFrame and prints out the first `''n''` rows.
- show(int, int) - Method in class com.snowflake.snowpark_java.DataFrame
-
Evaluates this DataFrame and prints out the first `''n''` rows with the specified maximum number of characters per column.
- sign(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sign of its argument:
- signum(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sign of its argument:
- sin(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the sine of its argument; the argument should be expressed in radians.
- sinh(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the hyperbolic sine of its argument.
- size() - Method in class com.snowflake.snowpark_java.Row
-
Counts the number of column in this
Row
. - size() - Method in class com.snowflake.snowpark_java.types.StructType
-
Counts the number of StructFields in this StructType object.
- size(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the size of the input ARRAY.
- skew(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample skewness of non-NULL records.
- SnowflakeFile - Class in com.snowflake.snowpark_java.types
-
Custom Snowflake class that provides users with additional information on top of the core capability of reading Snowflake files.
- SnowflakeFile() - Constructor for class com.snowflake.snowpark_java.types.SnowflakeFile
- sort(Column...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Sorts a DataFrame by the specified expressions (similar to ORDER BY in SQL).
- soundex(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a string that contains a phonetic representation of the input string.
- split(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Splits a given string with a given separator and returns the result in an array of strings.
- split_to_table() - Static method in class com.snowflake.snowpark_java.TableFunctions
-
This table function splits a string (based on a specified delimiter) and flattens the results into rows.
- split_to_table(Column, String) - Static method in class com.snowflake.snowpark_java.TableFunctions
-
This table function splits a string (based on a specified delimiter) and flattens the results into rows.
- sproc() - Method in class com.snowflake.snowpark_java.Session
-
Returns a SProcRegistration object that you can use to register Stored Procedures.
- SProcRegistration - Class in com.snowflake.snowpark_java
-
Provides methods to register a SProc (Stored Procedure) in the Snowflake database.
- sql(String) - Method in class com.snowflake.snowpark_java.Session
-
Returns a new
DataFrame
representing the results of a SQL query. - sqlExpr(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a Column expression from row SQL text.
- sqrt(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the square-root of a non-negative numeric expression.
- startswith(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns true if col starts with str.
- stat() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrameStatFunctions object that provides statistic functions.
- stddev(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample standard deviation (square root of sample variance) of non-NULL values.
- stddev_pop(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the population standard deviation (square root of variance) of non-NULL values.
- stddev_samp(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample standard deviation (square root of sample variance) of non-NULL values.
- storedProcedure(StoredProcedure, Object...) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from the given Stored Procedure and arguments.
- storedProcedure(String, Object...) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from the given Stored Procedure and arguments.
- StoredProcedure - Class in com.snowflake.snowpark_java
-
This reference to a Stored Procedure which can be created by
Session.sproc().register
methods, and used inSession.storedProcedure()
method. - StringType - Class in com.snowflake.snowpark_java.types
-
String data type.
- StringType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the StringType object.
- strip_null_value(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts a JSON "null" value in the specified column to a SQL NULL value.
- strtok_to_array(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
- strtok_to_array(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Tokenizes the given string using the given set of delimiters and returns the tokens as an array.
- StructField - Class in com.snowflake.snowpark_java.types
-
Represents the content of StructType.
- StructField(ColumnIdentifier, DataType) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField with nullable column.
- StructField(ColumnIdentifier, DataType, boolean) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField.
- StructField(String, DataType) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField with nullable column.
- StructField(String, DataType, boolean) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField.
- StructType - Class in com.snowflake.snowpark_java.types
-
StructType data type, represents table schema.
- StructType(StructField[]) - Constructor for class com.snowflake.snowpark_java.types.StructType
-
Creates a StructType object based on the given Array of StructField.
- StructType(StructType) - Constructor for class com.snowflake.snowpark_java.types.StructType
-
Clones the given StructType object.
- subField(int) - Method in class com.snowflake.snowpark_java.Column
-
Retrieves the element (field) at the specified index in a column that contains semi-structured data.
- subField(String) - Method in class com.snowflake.snowpark_java.Column
-
Retrieves the specified element (field) in a column that contains semi-structured data.
- substring(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the portion of the string or binary value str, starting from the character/byte specified by pos, with limited length.
- substring_index(String, String, Integer) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the substring from string str before count occurrences of the delimiter delim.
- sum(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sum of non-NULL records in a group.
- sum(Column...) - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the sum for the specified numeric columns.
- sum(String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sum of non-NULL records in a group.
- sum_distinct(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sum of non-NULL distinct records in a group.
- sysdate() - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current timestamp for the system, but in the UTC time zone.
T
- table(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a DataFrame that is set up to load data from the specified table.
- table(String) - Method in class com.snowflake.snowpark_java.Session
-
Returns a Updatable that points to the specified table.
- table(String[]) - Method in class com.snowflake.snowpark_java.Session
-
Returns an Updatable that points to the specified table.
- tableFunction(Column) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from the given table function and arguments.
- tableFunction(TableFunction, Column...) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from the given table function and arguments.
- tableFunction(TableFunction, Map<String, Column>) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from the given table function and arguments.
- TableFunction - Class in com.snowflake.snowpark_java
-
Looks up table functions by funcName and returns tableFunction object which can be used in
DataFrame.join
andSession.tableFunction
methods. - TableFunction(String) - Constructor for class com.snowflake.snowpark_java.TableFunction
-
Create a new table function reference.
- TableFunctions - Class in com.snowflake.snowpark_java
-
Provides utility functions that generate table function expressions that can be passed to DataFrame join method and Session tableFunction method.
- tan(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the tangent of its argument; the argument should be expressed in radians.
- tanh(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Computes the hyperbolic tangent of its argument.
- time_from_parts(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a time from individual numeric components.
- time_from_parts(Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a time from individual numeric components.
- timestamp_from_parts(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_from_parts(Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_from_parts(Column, Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_ltz_from_parts(Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_ltz_from_parts(Column, Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_ntz_from_parts(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_ntz_from_parts(Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_ntz_from_parts(Column, Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_tz_from_parts(Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_tz_from_parts(Column, Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- timestamp_tz_from_parts(Column, Column, Column, Column, Column, Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a timestamp from individual numeric components.
- TimestampType - Class in com.snowflake.snowpark_java.types
-
Timestamp data type.
- TimestampType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the TimestampType object.
- TimeType - Class in com.snowflake.snowpark_java.types
-
Time data type.
- TimeType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the TimeType object.
- to_array(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the input expression into an array:
- to_date(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression to a date.
- to_date(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression to a date.
- to_decimal(Column, int, int) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression to a decimal
- to_json(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts any VARIANT value to a string containing the JSON representation of the value.
- to_object(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the input value to an object:
- to_timestamp(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression into the corresponding timestamp.
- to_timestamp(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts an input expression into the corresponding timestamp.
- to_variant(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts any value to VARIANT value or NULL (if input is NULL).
- to_xml(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts any VARIANT value to a string containing the XML representation of the value.
- toDF(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a new DataFrame containing the data in the current DataFrame but in columns with the specified names.
- toList() - Method in class com.snowflake.snowpark_java.Row
-
Converts this
Row
to aList
ofObject
. - toLocalIterator() - Method in class com.snowflake.snowpark_java.DataFrame
-
Executes the query representing this DataFrame and returns an iterator of Row objects that you can use to retrieve the results.
- toLocalIterator() - Method in class com.snowflake.snowpark_java.DataFrameAsyncActor
-
Executes
DataFrame.toLocalIterator
asynchronously. - toScalar(DataFrame) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a Column representing the result of the input DataFrame.
- toString() - Method in class com.snowflake.snowpark_java.Column
-
Retrieves a string representation of the expression corresponding to this Column instance.
- toString() - Method in class com.snowflake.snowpark_java.Row
-
Generates a string value to represent the content of this row.
- toString() - Method in class com.snowflake.snowpark_java.types.ArrayType
-
Generates a String value to represent this array type.
- toString() - Method in class com.snowflake.snowpark_java.types.ColumnIdentifier
-
Generates a String value to represent this Column Identifier.
- toString() - Method in class com.snowflake.snowpark_java.types.DataType
-
Generates a String value to represent this DataType object.
- toString() - Method in class com.snowflake.snowpark_java.types.DecimalType
-
Generates a String value to represent this DecimalType.
- toString() - Method in class com.snowflake.snowpark_java.types.Geography
-
Converts this Geography object to a String value.
- toString() - Method in class com.snowflake.snowpark_java.types.Geometry
-
Converts this Geometry object to a String value.
- toString() - Method in class com.snowflake.snowpark_java.types.MapType
-
Generates a String value to represent this map type.
- toString() - Method in class com.snowflake.snowpark_java.types.StructField
-
Generates a String value to represent this StructField.
- toString() - Method in class com.snowflake.snowpark_java.types.StructType
-
Generates a String value to represent this StructType.
- toString() - Method in class com.snowflake.snowpark_java.types.Variant
-
An alias of
asString()
- translate(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Translates src from the characters in matchingString to the characters in replaceString.
- trim(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes leading and trailing characters from a string.
- trunc(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
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.
- TypedAsyncJob<T> - Class in com.snowflake.snowpark_java
-
Provides a way to track an asynchronously executed action in a DataFrame.
- typeName() - Method in class com.snowflake.snowpark_java.types.DataType
-
Retrieves the String name of this DataType object.
U
- udf() - Method in class com.snowflake.snowpark_java.Session
-
Returns a UDFRegistration object that you can use to register UDFs.
- udf(JavaUDF0<?>, DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 0 argument as a Snowflake UDF and returns the UDF.
- udf(JavaUDF1<?, ?>, DataType, DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 1 argument as a Snowflake UDF and returns the UDF.
- udf(JavaUDF10<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 10 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF11<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 11 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF12<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 12 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF13<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 13 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF14<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 14 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF15<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 15 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF16<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 16 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF17<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 17 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF18<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 18 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF19<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 19 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF2<?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 2 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF20<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 20 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF21<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 21 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF22<?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 22 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF3<?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 3 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF4<?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 4 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF5<?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 5 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF6<?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 6 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF7<?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 7 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF8<?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 8 arguments as a Snowflake UDF and returns the UDF.
- udf(JavaUDF9<?, ?, ?, ?, ?, ?, ?, ?, ?, ?>, DataType[], DataType) - Static method in class com.snowflake.snowpark_java.Functions
-
Registers a Java Lambda of 9 arguments as a Snowflake UDF and returns the UDF.
- UDFRegistration - Class in com.snowflake.snowpark_java
-
Provides methods to register lambdas and functions as UDFs in the Snowflake database.
- udtf() - Method in class com.snowflake.snowpark_java.Session
-
Returns a UDTFRegistration object that you can use to register UDTFs.
- UDTFRegistration - Class in com.snowflake.snowpark_java
-
Provides methods to register a UDTF (user-defined table function) in the Snowflake database.
- unary_minus() - Method in class com.snowflake.snowpark_java.Column
-
Unary minus.
- unary_not() - Method in class com.snowflake.snowpark_java.Column
-
Unary not.
- unbase64(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Decodes a BASE64 encoded string column and returns it as a column.
- unboundedFollowing() - Static method in class com.snowflake.snowpark_java.Window
-
Returns a value representing unbounded following.
- unboundedPreceding() - Static method in class com.snowflake.snowpark_java.Window
-
Returns a value representing unbounded preceding.
- unhex(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Inverse of hex.
- uniform(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns a uniformly random number, in the inclusive range (`min`, `max`)
- union(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains all the rows in the current DataFrame and another DataFrame (`other`), excluding any duplicate rows.
- unionAll(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains all the rows in the current DataFrame and another DataFrame (`other`), including any duplicate rows.
- unionAllByName(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains all the rows in the current DataFrame and another DataFrame (`other`), including any duplicate rows.
- unionByName(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains all the rows in the current DataFrame and another DataFrame (`other`), excluding any duplicate rows.
- unix_timestamp(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the current Unix timestamp (in seconds) as a long.
- unsetQueryTag() - Method in class com.snowflake.snowpark_java.Session
-
Unset query_tag parameter for this session.
- Updatable - Class in com.snowflake.snowpark_java
-
Represents a lazily-evaluated Updatable.
- UpdatableAsyncActor - Class in com.snowflake.snowpark_java
-
Provides APIs to execute Updatable actions asynchronously.
- update(Map<Column, Column>) - Method in class com.snowflake.snowpark_java.MatchedClauseBuilder
-
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. - update(Map<Column, Column>) - Method in class com.snowflake.snowpark_java.Updatable
-
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. - update(Map<Column, Column>) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- update(Map<Column, Column>, Column) - Method in class com.snowflake.snowpark_java.Updatable
-
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. - update(Map<Column, Column>, Column) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- update(Map<Column, Column>, Column, DataFrame) - Method in class com.snowflake.snowpark_java.Updatable
-
Updates all rows in the updatable that satisfy specified condition where condition includes columns in other
DataFrame
, and returns aUpdateResult
, representing number of rows modified and number of multi-joined rows modified. - update(Map<Column, Column>, Column, DataFrame) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- updateColumn(Map<String, Column>) - Method in class com.snowflake.snowpark_java.MatchedClauseBuilder
-
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. - updateColumn(Map<String, Column>) - Method in class com.snowflake.snowpark_java.Updatable
-
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. - updateColumn(Map<String, Column>) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- updateColumn(Map<String, Column>, Column) - Method in class com.snowflake.snowpark_java.Updatable
-
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. - updateColumn(Map<String, Column>, Column) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- updateColumn(Map<String, Column>, Column, DataFrame) - Method in class com.snowflake.snowpark_java.Updatable
-
Updates all rows in the updatable that satisfy specified condition where condition includes columns in other
DataFrame
, and returns aUpdateResult
, representing number of rows modified and number of multi-joined rows modified. - updateColumn(Map<String, Column>, Column, DataFrame) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- updateQueryTag(String) - Method in class com.snowflake.snowpark_java.Session
-
Updates the query tag that is a JSON encoded string for the current session.
- UpdateResult - Class in com.snowflake.snowpark_java
-
Result of updating rows in an Updatable
- uploadStream(String, InputStream, boolean) - Method in class com.snowflake.snowpark_java.FileOperation
-
Method to compress data from a stream and upload it at a stage location.
- upper(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the input string with all characters converted to uppercase.
- UserDefinedFunction - Class in com.snowflake.snowpark_java
-
Encapsulates a user defined lambda or function that is returned by
UDFRegistration.registerTemporary
,UDFRegistration.registerPermanent
, orFunctions.udf
.
V
- valueOf(String) - Static method in enum com.snowflake.snowpark_java.SaveMode
-
Returns the enum constant of this type with the specified name.
- values() - Static method in enum com.snowflake.snowpark_java.SaveMode
-
Returns an array containing the constants of this enum type, in the order they are declared.
- var_pop(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the population variance of non-NULL records in a group.
- var_samp(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample variance of non-NULL records in a group.
- variance(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample variance of non-NULL records in a group.
- Variant - Class in com.snowflake.snowpark_java.types
-
Representation of Snowflake Variant data
- Variant(boolean) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from boolean value.
- Variant(byte[]) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from binary value.
- Variant(double) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from double value.
- Variant(float) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from float value.
- Variant(int) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from int value.
- Variant(long) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from long value.
- Variant(short) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from short value.
- Variant(Object) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from Object value.
- Variant(Object[]) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from an array.
- Variant(String) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from String value.
- Variant(BigDecimal) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from BigDecimal value.
- Variant(BigInteger) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from BigInteger value.
- Variant(Date) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from Date value.
- Variant(Time) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from Time value.
- Variant(Timestamp) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from Timestamp value.
- Variant(List<Object>) - Constructor for class com.snowflake.snowpark_java.types.Variant
-
Creates a Variant from a list.
- VariantType - Class in com.snowflake.snowpark_java.types
-
Variant data type.
- VariantType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the VariantType object.
W
- weekofyear(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the week of year from a date or timestamp.
- when(Column, Column) - Method in class com.snowflake.snowpark_java.CaseExpr
-
Appends one more WHEN condition to the CASE expression.
- when(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Works like a cascading if-then-else statement.
- whenMatched() - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Adds a matched clause into the merge action.
- whenMatched(Column) - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Adds a matched clause into the merge action.
- whenNotMatched() - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Adds a not matched clause into the merge action.
- whenNotMatched(Column) - Method in class com.snowflake.snowpark_java.MergeBuilder
-
Adds a matched clause into the merge action.
- where(Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Filters rows based on the specified conditional expression (similar to WHERE in SQL).
- Window - Class in com.snowflake.snowpark_java
-
Contains functions to form WindowSpec.
- WindowSpec - Class in com.snowflake.snowpark_java
-
Represents a window frame clause.
- withColumn(String, Column) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrame with an additional column with the specified name (`colName`).
- withColumns(String[], Column[]) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrame with additional columns with the specified names (`colNames`).
- withinGroup(Column...) - Method in class com.snowflake.snowpark_java.Column
-
Returns a Column expression that adds a WITHIN GROUP clause to sort the rows by the specified sequence of columns.
- write() - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a DataFrameWriter object that you can use to write the data in the DataFrame to any supported destination.
- WriteFileResult - Class in com.snowflake.snowpark_java
-
Represents the results of writing data from a DataFrame to a file in a stage.
X
- xml(String) - Method in class com.snowflake.snowpark_java.DataFrameReader
-
Returns a CopyableDataFrame that is set up to load data from the specified XML file.
- xmlget(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
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
- xmlget(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
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).
Y
- year(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Extracts the year from a date or timestamp.
All Classes All Packages