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…
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…
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.
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.
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.
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.) …
Introduction to Java UDFs
You can write the handler for a user - defined function (UDF) in 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.