I want to create a Java UDF in a snowflake worksheet in order to query GeoIp2 library and get the ISO code of a given IP. I have ‘@AWS_CSV_STAGE/lib/geoip2-2.8.0.jar’,’@AWS_CSV_STAGE/geodata/GeoLite2-City.mmdb’ already staged. How can i direct the function handler to the method that cr…
Tag: snowflake-cloud-data-platform
Spring boot – Snowflake JDBC – Alter session automatically when application loads
I’m trying to connect Snowflake to Spring boot based application. Everything works well however due to some crazy defaults in snowflake, I’m having to deal with the below error: https://community.snowflake.com/s/article/SAP-BW-Java-lang-NoClassDefFoundError-for-Apache-arrow I can fire the queries …
Snowflake exception While unwrapping snowflake objects
I am Using snowflake-jdbc-13.3.8.jar. while executing below code having unwrap call, I am getting exception. Pls guide what am I missing? Answer You’re calling getQueryId() rather than getQueryID(), observe ID is in capitals. The unwrap works, here is an example. First I create a simple stored procedure…