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 creates the Database Reader as explained here in the documentation for Java: https://dev.maxmind.com/geoip/geolocate-an-ip/databases?lang=en#1-install-the-geoip2-client-library in general how can i
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 via Spring data JPA but not able to map the results at all. The solution asks for changing the default resultset format from ARROW to
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: I test it to see it works: It returns to me just the