Source
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…
Python and Java support for serverless tasks
Serverless tasks can invoke the following object types and functions: user - defined functions (UDFs) and stored procedures written in Python, Java, and Scala. You can use Python or Java in your tasks in a few different ways.
Writing Java handlers for stored procedures created with SQL
You can create a stored procedure whose handler is written in Java. You can use the Snowpark library within your stored procedure to perform queries, updates, and other work on tables in Snowflake.
Error during ETL operations: JAVA PLUGIN_1762 [ERROR] java.lang.OutOfMemoryError: GC overhead limit exceeded
Error during ETL operations: JAVA PLUGIN_1762 [ERROR] java.
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.
Accessing data from a Java stored procedure
To access data with a stored procedure handler written in Java, use the Snowpark library APIs. When handling a call to your Java stored procedure, Snowflake creates a Snowpark Session object and passes the object to the method for your…
Emitting trace events in Java
You can use the com.snowflake.telemetry.Telemetry class in the Snowflake Telemetry API library to emit trace events from a function or procedure handler written in Java.
A Simple Example of Using Snowpark Java
The following example prints the count and names of tables in the current database. Replace the <placeholders> with values that you use to connect to Snowflake.
Enabling JDBC Driver Debugging in DBeaver
…specifies a comma - separated list of log Handler # classes. These handlers will be installed during VM startup. # Note that these classes must be on the system classpath.
Creating User-Defined Functions (UDFs) for DataFrames in Java
The Snowpark API provides methods that you can use to create a user - defined function from a lambda expression in Java. This topic explains how to create these types of functions.