Source
Analyzing queries and troubleshooting with Snowpark Java
This is because Snowpark uses the Apache Arrow connector, which depends on internal Java APIs that are not exposed by default after Java 9. To work around this error, set the following parameter either as a command - line argument when…
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.
JDBC Driver Failure - net.snowflake.client.jdbc.internal.io.netty.util.internal.OutOfDirectMemoryError: failed to allocate xxx byte(s) of direct memory (used: yyy, max: zzz)
CAUSE: Java allows applications to write bytes directly to memory outside of the JVM's heap space. Other terminologies used to describe that portion of the memory include native memory, off - heap memory, non - heap memory, and direct memory.
Exception 'java.net.UnknownHostException' when connecting to scoped stage file URLs within Snowpark Java functions
…required to permit authorized access to stage file resources from within the secure execution sandbox.
JDBC driver with -Dhttp.nonProxyHosts=* set throws java.lang.StringIndexOutOfBoundsException: begin 1, end 0, length 1
ISSUE: When using the JDBC driver's diagnostics feature (i.e., ENABLE_DIAGNOSTICS=TRUE)1, if the - Dhttp.
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.
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'…
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.
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.