Source
Quick reference: Snowpark Java APIs for SQL commands
This topic provides a quick reference of some of the Snowpark APIs that correspond to SQL commands. (Note that this is not a complete list of the APIs that correspond to SQL commands.)…
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 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 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.nonProxyHosts=* JVM argument is set, the following exception can occur on some Java versions: java.lang.RuntimeException: java.lang.St…
A Simple Example of Using Snowpark Java
A Simple Example of Using Snowpark Java The following example prints the count and names of tables in the current database. Replace the <placeholders> with values that you use to connect to Snowflake.
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…
Java handler examples for stored procedures
Java handler examples for stored procedures Using Snowpark APIs for asynchronous processing In the following example, the getResultJDBC procedure executes an asynchronous child job that waits 10 seconds.
Accessing data from a Java stored procedure
To access data with a stored procedure handler written in Java, use the Snowpark library APIs. When handling a call to your Java stored procedure, Snowflake creates a Snowpark Session object and passes the object to the method for your…
Enabling JDBC Driver Debugging in DBeaver
"handlers" specifies a comma - separated list of log Handler # classes. These handlers will be installed during VM startup. # Note that these classes must be on the system classpath. # ConsoleHandler and FileHandler are configured here such…
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.