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…
JDBC Driver Compatibility Issue With JDK 16 and Later: Exception creating result java.lang.ExceptionInInitializerError at net.snowflake.client.jdbc.internal.apache.arrow.memory.UnsafeAllocationManager
CAUSE: The failure is directly caused by one of the JDBC driver's dependencies, Apache Arrow, when attempting to use reflection in order to access a private member of the java.
JDBC driver throws javax.naming.CommunicationException: DNS error (Root exception: java.net.SocketTimeoutException)
ISSUE: The following exception occurs on macOS (aarch64) when using the JDBC driver’s diagnostic feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1: javax.naming.CommunicationException: DNS error [Root exception is java.net.SocketTimeoutException];…
Error during ETL operations: JAVA PLUGIN_1762 [ERROR] java.lang.OutOfMemoryError: GC overhead limit exceeded
ISSUE: While performing ETL (Extract, Transform, and Load) operations between third-party software and Snowflake, the following errors are encountered: ERROR 1/13/2016 10:00:33 AM node01 WRITER_1*_1 JAVA PLUGIN_1762 [ERROR] at java.lang.S…
Creating a Java UDF handler
When you write a Java UDF, you write Java code for Snowflake to execute as UDF logic. This Java code is the UDF’s handler. You deploy the UDF with CREATE FUNCTION, giving the UDF a name and specifying the Java method as the handler to…
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.
Tabular Java UDFs (UDTFs)
Your Java UDTF handler class processes rows received in the UDTF call and returns a tabular result. The received rows are partitioned, either implicitly by Snowflake or explicitly in the syntax of the function call.