- 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, 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(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_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.
- 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.
- apply(Column...) - Method in class com.snowflake.snowpark_java.UserDefinedFunction
-
Apply the UDF to one or more columns to generate a Column expression.
- 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 a specified numeric column and an array of desired quantiles, returns an approximate value
for the column at each of the desired quantiles.
- 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.
- 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_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.
- 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.
- 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, 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) - Method in interface com.snowflake.snowpark_java.udf.JavaUDF2
-
- 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(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
-
- 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.
- 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(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.
- col(DataFrame) - Static method in class com.snowflake.snowpark_java.Functions
-
Generates a Column representing the result of the input DataFrame.
- 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.
- 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.
- 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.
- Column - Class in com.snowflake.snowpark_java
-
Represents a column or an expression in a DataFrame.
- 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.
- columnIdentifier() - Method in class com.snowflake.snowpark_java.types.StructField
-
Retrieves the column identifier.
- 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.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, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the given sourceTimestampNTZ from sourceTimeZone to targetTimeZone.
- convert_timezone(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts the given sourceTimestampNTZ 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, 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[], 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.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) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- 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.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- copyInto(String, String[], Column[], Map<String, ?>) - Method in class com.snowflake.snowpark_java.CopyableDataFrameAsyncActor
-
Executes `CopyableDataFrame.copyInto` asynchronously.
- corr(String, String) - Method in class com.snowflake.snowpark_java.DataFrameStatFunctions
-
Calculates the correlation coefficient for non-null pairs in two numeric columns.
- corr(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the correlation coefficient for non-null pairs in a group.
- 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(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() - Method in class com.snowflake.snowpark_java.RelationalGroupedDataFrame
-
Return the number of rows for each group.
- 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.
- 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(Set<Column>...) - Static method in class com.snowflake.snowpark_java.GroupingSets
-
Creates a GroupingSets object from a list of column/expression sets.
- create(Object...) - Static method in class com.snowflake.snowpark_java.Row
-
Creates a Row based on the given values.
- 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
- 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
-
- cube(String...) - Method in class com.snowflake.snowpark_java.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.
- 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 - Class in com.snowflake.snowpark_java.types
-
Snowpark data types
- DataType() - Constructor for class com.snowflake.snowpark_java.types.DataType
-
- dataType() - Method in class com.snowflake.snowpark_java.types.StructField
-
Retrieves the column data type.
- DataTypes - Class in com.snowflake.snowpark_java.types
-
This class contains all singleton DataTypes and factory methods.
- 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 - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the DateType object.
- DateType - Class in com.snowflake.snowpark_java.types
-
Date data type.
- 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(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, 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 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.UpdatableAsyncActor
-
Executes `Updatable.delete` asynchronously.
- 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_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 - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the DoubleType object.
- DoubleType - Class in com.snowflake.snowpark_java.types
-
Double data type.
- downloadStream(String, boolean) - Method in class com.snowflake.snowpark_java.FileOperation
-
Download file from the given stage and return an input stream
- 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.
- 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 columns cols.
- dropDuplicates(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
Creates a new DataFrame by removing duplicated rows on given subset of columns.
- 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 - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the GeographyType object.
- GeographyType - Class in com.snowflake.snowpark_java.types
-
Geography data type.
- geq(Column) - Method in class com.snowflake.snowpark_java.Column
-
Greater than or equal to.
- 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 by targetLocation.
- 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 by targetLocation.
- 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(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_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.
- 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.
- 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(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.
- 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.
- getKeyType() - Method in class com.snowflake.snowpark_java.types.MapType
-
Retrieves the data type of this MapType's key.
- 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.
- 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).
- 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 - Class in com.snowflake.snowpark_java
-
Represents the results of downloading a file from a stage location to the local file system.
- getResult(int) - Method in class com.snowflake.snowpark_java.TypedAsyncJob
-
Returns the result for the specific DataFrame action.
- getResult() - Method in class com.snowflake.snowpark_java.TypedAsyncJob
-
Returns the result for the specific DataFrame action.
- getRows(int) - 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.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.
- 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.
- 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.
- 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.
- 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
-
- 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.
- iff(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns one of two specified expressions, depending on a condition.
- 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 ...
- 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(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(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 ...
- 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, 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(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(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 - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the IntegerType object.
- IntegerType - Class in com.snowflake.snowpark_java.types
-
Integer data type.
- 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.
- 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.
- 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(DataFrame) - Method in class com.snowflake.snowpark_java.DataFrame
-
Performs a default inner join of the current DataFrame and another DataFrame (`right`).
- 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(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(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, 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.
- 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.
- 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.
- 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) - 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_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, 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.
- 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) - 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, String, boolean) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by `delimiter` string.
- listagg(Column, String) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by `delimiter` string.
- listagg(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the concatenated input values, separated by empty string.
- lit(Object) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a Column expression for a literal value.
- log(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the logarithm of a numeric expression.
- LongType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the LongType object.
- LongType - Class in com.snowflake.snowpark_java.types
-
Long integer data type.
- 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, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes leading characters, including whitespace, from a string.
- ltrim(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes leading characters, including whitespace, from a string.
- radians(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Converts degrees to radians.
- random(long) - Static method in class com.snowflake.snowpark_java.Functions
-
Each call returns a pseudo-random 64-bit integer.
- random() - 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, long) - Method in class com.snowflake.snowpark_java.Session
-
Creates a new DataFrame from a range of numbers.
- range(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, 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) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the number of times that a pattern occurs in a strExpr.
- 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, 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, 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, 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, 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, JavaUDTF, String) - Method in class com.snowflake.snowpark_java.UDTFRegistration
-
Registers an UDTF instance as a Snowflake UDTF.
- 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(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(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(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(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(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, 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, 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, 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, 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(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, 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(String, Map<?, ?>) - Method in class com.snowflake.snowpark_java.DataFrameNaFunctions
-
Returns a new DataFrame that replaces values in a specified column.
- 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(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes all occurrences of a specified strExpr, and optionally replaces them with replacement.
- 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
-
- rollup(String...) - Method in class com.snowflake.snowpark_java.DataFrame
-
- round(Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns rounded values for the specified column.
- round(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns rounded values for the specified column.
- 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, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes trailing characters, including whitespace, from a string.
- rtrim(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Removes trailing characters, including whitespace, from a string.
- sample(long) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame with a sample of N rows from the underlying DataFrame.
- sample(double) - Method in class com.snowflake.snowpark_java.DataFrame
-
Returns a new DataFrame that contains a sampling of rows from the current 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.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.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.
- ShortType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the ShortType object.
- ShortType - Class in com.snowflake.snowpark_java.types
-
Short integer data type.
- 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.
- 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.
- skew(Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Returns the sample skewness of non-NULL records.
- 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.
- 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.
- StringType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the StringType object.
- StringType - Class in com.snowflake.snowpark_java.types
-
String data type.
- 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, boolean) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField.
- StructField(ColumnIdentifier, 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.
- StructField(String, DataType) - Constructor for class com.snowflake.snowpark_java.types.StructField
-
Creates a new StructField with nullable column.
- StructType - Class in com.snowflake.snowpark_java.types
-
StructType data type, represents table schema.
- StructType(StructType) - Constructor for class com.snowflake.snowpark_java.types.StructType
-
Clones the given StructType object.
- StructType(StructField[]) - Constructor for class com.snowflake.snowpark_java.types.StructType
-
Creates a StructType object based on the given Array of StructField.
- subField(String) - Method in class com.snowflake.snowpark_java.Column
-
- 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.
- 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.
- 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_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.
- 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(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 and Session.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, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a time from individual numeric components.
- time_from_parts(Column, Column, Column) - Static method in class com.snowflake.snowpark_java.Functions
-
Creates a time 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_from_parts(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, 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_ntz_from_parts(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 - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the TimestampType object.
- TimestampType - Class in com.snowflake.snowpark_java.types
-
Timestamp data type.
- TimeType - Static variable in class com.snowflake.snowpark_java.types.DataTypes
-
Retrieves the TimeType object.
- TimeType - Class in com.snowflake.snowpark_java.types
-
Time data type.
- 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 a List of Object.
- 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.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.
- 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(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(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.
- 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(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() - Method in class com.snowflake.snowpark_java.Session
-
Returns a UDFRegistration object that you can use to register UDFs.
- 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.
- 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.
- 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.
- 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>, 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, 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 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.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- 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>, 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, 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 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.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- updateColumn(Map<String, Column>, Column, DataFrame) - Method in class com.snowflake.snowpark_java.UpdatableAsyncActor
-
Executes `Updatable.update` asynchronously.
- 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, or Functions.udf.