Source
Analyzing queries and troubleshooting with Snowpark Java
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 running your…
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)…
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 is not keeping the timezone offset information when using Timestamp data type
ISSUE: When Timestamp data is being used in a Java UDF, the timezone information (offset) will be dropped, as can be seen from the following example:Example: CREATE OR REPLACE FUNCTION "JAVA_REFLECT_TIMESTAMP_TZ"("I" TIMESTAMP_TZ) RETURNS…
Enabling JDBC Driver Debugging in DBeaver
# Note that these classes must be on the system classpath. # ConsoleHandler and FileHandler are configured here such that # the logs are dumped into both a standard error and a file.