cancel
Showing results for 
Search instead for 
Did you mean: 

Snowflake Select Snap

anupal_bora
New Contributor

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”

1 REPLY 1

Illiyas
New Contributor

Hi Anupal, are you able resolve this error?
I am also getting the same error.