Hi All,
Trying to load a simple csv file to Redshift Cluster. The DB Insert is very slow, and no data is inserted into the database. I tried both DB Writer also, no results.
Hi @dvkumaraws2019 , probably the best way to write as csv to Redshift is via S3, and Knime is able to connect to S3.
Hello @dvkumaraws2019,
from KNIME v4.5.0 you can use DB Loader node for bulk load in Redshift. See here:
Br,
Ivan
1 Like