Source
Quick reference: Snowpark Java APIs for SQL commands
This topic provides a quick reference of some of the Snowpark APIs that correspond to SQL commands. (Note that this is not a complete list of the APIs that correspond to SQL commands.)…
Analyzing queries and troubleshooting with Snowpark Java
To inspect the evaluation plan of a DataFrame, call the explain method of the DataFrame. This prints the SQL statements used to evaluate the DataFrame. If there is only one SQL statement, the method also prints the logical plan for the…
Calling functions and stored procedures in Snowpark Java
To process data in a DataFrame, you can call system - defined SQL functions, user - defined functions, and stored procedures.
Reading files with a Java stored procedure
You can read the contents of a file with handler code. The file must be on a Snowflake stage that’s available to your handler. For example, you might want to read a file to process unstructured data in the handler.
Creating a Session for Snowpark Java
To use Snowpark in your application, you need to create a session. For convenience in writing code, you can also import the names of packages and objects.
Java UDF handler examples
This code returns the VARCHAR passed to it. This function is declared with the optional CALLED ON NULL INPUT clause to indicate that the function is called even if the value of the input is NULL.