Snowflake SQL error

I was able to set up snowflake connection in KNIME. I can see schema and list of all tables. But I can’t query any data. I keep getting this error.

ERROR DB SQL Executor 0:19 Execute failed: Cannot perform SELECT. This session does not have a current database. Call ‘USE DATABASE’, or use a qualified name.

Please advise how to proceed. Thank you so much for your help.

Hi there @mikehong,

Check here:

Also I see you are using DB SQL Executor node to select data from database or is it only example? Have you tried using DB Query Reader or DB Table Selector in combination with DB Reader?



This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.