writing db data to Snowflake
Hi all,
I am new to KNIME and I need your help.
Currently I am using the process in the workflow shared to write a KNIME table to Snowflake using the nodes you see.
As the workflow takes too long to run and I need to improve it, I transformed all the nodes to db nodes. In the steps shared, I need a way to write my db-data to Snowflake without having to use the DB reader node.
Any suggestions?
Note: steps of the extractions are
Create the table if it does not exist
Check if the data for this specific entity and month (2 flow variables) exist and if they do delete the rows
Write the data in the table.