I am using Knime with the Snowflake JDBC driver which is great to leverage the computation power of Snowflake.
I need to save the result of my workflow (completely realised with DB nodes) into a new table and thus trying to use the DB Connection table writer (Labs).
I get the following error:
ERROR DB Connection Table Writer (Labs) 0:828 Execute failed: CREATE TABLE AS SELECT is not part of the SQL-92 syntax.
Which is true. But Snowflake supports this simple but useful instruction.
But declaring my Snowflake JDBC driver as “default” (only possible choice) does forces me to select the SQL-92 database dialect in the DB Connector node.
Do you see any solution to this (beyond using the DB reader node to store locally the data and then insert them into the Snowflake table using the DB Insert node)?