load csv to AWS Redshift

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