I am receiving the below error when I am querying Snowflake. I am not sure why first the CURRENT_SESSION() is being executed instead of a select * from table.
Jar: snowflake-jdbc-3.12.1.jar
JDBC Driver Class: net.snowflake.client.jdbc.SnowflakeDriver
“error”:
“Error while fetching Snowflake session id”
“stacktrace”:
“java.sql.SQLException: Column not found: CURRENT_SESSION()\n\tat net.snowflake.client.jdbc.SnowflakeBaseResultSet.findColumn(SnowflakeBaseResultSet.java:353)\n\tat net.snowflake.client.jdbc.SnowflakeBaseResultSet.getString(SnowflakeBaseResultSet.java:159)\n\tat com.zaxxer.hikari.pool.HikariProxyResultSet.getString(HikariProxyResultSet.java)\n\tat com.snaplogic.snaps.sql.SimpleSqlSnap.startQueryIDThread(SimpleSqlSnap.java:195)\n\tat com.snaplogic.snaps.snowflake.Select.processDocument(Select.java:134)\n\tat com.snaplogic.snaps.sql.SimpleSqlSnap.process(SimpleSqlSnap.java:384)\n\tat com.snaplogic.snap.api.ExecutionUtil.process(ExecutionUtil.java:106)\n\tat com.snaplogic.snap.api.ExecutionUtil.execute(ExecutionUtil.java:70)\n\tat com.snaplogic.snaps.sql.SimpleSqlSelectSnap.executeForSuggest(SimpleSqlSelectSnap.java:863)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.executeSnap(SnapRunnableImpl.java:763)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.executeForSuggest(SnapRunnableImpl.java:612)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.doRun(SnapRunnableImpl.java:821)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:400)\n\tat com.snaplogic.cc.snap.common.SnapRunnableImpl.call(SnapRunnableImpl.java:116)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)\n\tat java.util.concurrent.FutureTask.run(FutureTask.java:266)\n\tat java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)\n\tat java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)\n\tat java.lang.Thread.run(Thread.java:748)\n”
“reason”:
“Error while fetching Snowflake session id”
