load csv to AWS Redshift

[dvkumaraws2019]

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.

[bruno29a]

Hi @dvkumaraws2019 , probably the best way to write as csv to Redshift is via S3, and Knime is able to connect to S3.

[ipazin]

Hello @dvkumaraws2019,

from KNIME v4.5.0 you can use DB Loader node for bulk load in Redshift. See here:

Writing to Amazon redshift database table

Hi Team, I have a database reader node and want to insert or add that data into my redshift database table. I am using DB writer node to insert the data but it is extremely slow. Is there any workaround for this? Thank you Srinivas

Br,
Ivan