Source
Java requirements for the JDBC Driver
The Snowflake JDBC driver requires Java LTS (Long - Term Support) versions 1.8 or higher. If the minimum required version of Java is not installed on the client machines where the JDBC driver is installed, you must install either Oracle Java…
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.
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.
JDBC connections requiring a proxy generate 'Encountered exception (connect timed out) during upload' exceptions for PUT operations using downscoped tokens
JDBC connections requiring a proxy generate 'Encountered exception (connect timed out) during upload'…
Creating a Session for Snowpark 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.
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)…
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.nio.Buffer class. This was allowed by Java previously, but not…
Exception 'java.net.UnknownHostException' when connecting to scoped stage file URLs within Snowpark Java functions
ISSUE: When using dynamic file access URLs such as via function BUILD_SCOPED_FILE_URL(@stage, path) in Snowpark Java functions (UDFs, SPs, etc.), attempting to directly connect to the passed scoped file URL in the following manner fails wit…
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.