# load csv to AWS Redshift

**URL:** <https://forum.knime.com/t/load-csv-to-aws-redshift/43416>\
**Category:** KNIME Analytics Platform\
**Created:** [May 23, 2022, 9:46pm UTC](https://forum.knime.com/t/load-csv-to-aws-redshift/43416 "2022-05-23T21:46:55Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![dvkumaraws2019](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/d/278dde/32.png) [@dvkumaraws2019](https://forum.knime.com/u/dvkumaraws2019)\
**Post date:** [May 23, 2022, 9:46pm UTC](https://forum.knime.com/t/load-csv-to-aws-redshift/43416/1 "2022-05-23T21:46:55Z")

</div>

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.

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/4/0/405636258e10757a96f10f2050e1dca407a74173.png)

---

<div class="post-metadata">

**Author:** ![bruno29a](https://forum-cdn.knime.com/user_avatar/forum.knime.com/bruno29a/32/28802_2.png) [@bruno29a](https://forum.knime.com/u/bruno29a)\
**Post date:** [May 24, 2022, 2:53am UTC](https://forum.knime.com/t/load-csv-to-aws-redshift/43416/2 "2022-05-24T02:53:20Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![ipazin](https://forum-cdn.knime.com/user_avatar/forum.knime.com/ipazin/32/806_2.png) [@ipazin](https://forum.knime.com/u/ipazin)\
**Post date:** [May 24, 2022, 6:48am UTC](https://forum.knime.com/t/load-csv-to-aws-redshift/43416/3 "2022-05-24T06:48:05Z")

</div>

Hello @dvkumaraws2019,

from KNIME v4.5.0 you can use [DB Loader](https://kni.me/n/hp8L4I_m6lJfldj5) node for bulk load in Redshift. See here:

> [@Writing to Amazon redshift database table](https://forum.knime.com/t/writing-to-amazon-redshift-database-table/42793):
>
> 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

---

<div class="post-metadata">

**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\
**Post date:** [August 22, 2022, 6:48am UTC](https://forum.knime.com/t/load-csv-to-aws-redshift/43416/4 "2022-08-22T06:48:29Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.