Snowflake SQL error

[mikehong]

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.

[ipazin]

Hi there @mikehong,

Check here: https://support.snowflake.net/s/question/0D50Z00008Uvt1wSAB/select-statement-issue

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?

Br,
Ivan