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 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.
Exception 'java.net.UnknownHostException' when connecting to scoped stage file URLs within Snowpark Java functions
CAUSE: Snowpark (Java, Scala, Python, etc.) functions execute in secure sandboxes over the Snowflake virtual warehouses and are not permitted to make any network related syscalls, including DNS resolution.
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.
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.
Java UDF handler examples
The following statements create and call an in - line Java UDF. 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…
Introduction to Java UDFs
You can write the handler for a user - defined function (UDF) in Java.
Logging messages in Java
You can log messages from a function or procedure handler written in Java by using the SLF4J API. When you’ve set up an event table to store log entries, Snowflake stores log entries generated by your handler code in the table.
Enabling JDBC Driver Debugging in DBeaver
FAQ: Instructions:1.) Locate the dbeaver.ini file using the default locations below:MacOS: /Applications/DBeaver.app/Contents/Eclipse/dbeaver.ini Windows: C:\Program Files\DBeaver\dbeaver.ini Linux: /usr/share/dbeaver/dbeaver.ini 2.) …
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.