# Writing to Amazon redshift database table **URL:** \ **Category:** KNIME Server\ **Created:** [May 10, 2022, 2:08pm UTC](https://forum.knime.com/t/writing-to-amazon-redshift-database-table/42793 "2022-05-10T14:08:52Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![ShinagdeS](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/s/b9bd4f/32.png) [@ShinagdeS](https://forum.knime.com/u/ShinagdeS)\ **Post date:** [May 10, 2022, 2:08pm UTC](https://forum.knime.com/t/writing-to-amazon-redshift-database-table/42793/1 "2022-05-10T14:08:52Z")
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 ---
**Author:** ![jeffgullick-knime](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/j/e36b37/32.png) [@jeffgullick-knime](https://forum.knime.com/u/jeffgullick-knime)\ **Post date:** [May 11, 2022, 5:05pm UTC](https://forum.knime.com/t/writing-to-amazon-redshift-database-table/42793/2 "2022-05-11T17:05:48Z")
Yes, the DB Loader, [here](https://kni.me/n/hp8L4I_m6lJfldj5) Since Redshift is a columnar store, single row inserts are incredibly slow. Bulk loading these types of databases is the best option. Another option would be to write your data out to S3, then using a SQL Statement you can load the data from the S3 location. This would require more nodes in the workflow, but is another option you could look into. -Jeff ---
**Author:** ![system](https://forum-cdn.knime.com/uploads/default/original/1X/ab3ccf34482a0329361734a18199390177204f15.png) [@system](https://forum.knime.com/u/system)\ **Post date:** [May 18, 2022, 5:05pm UTC](https://forum.knime.com/t/writing-to-amazon-redshift-database-table/42793/3 "2022-05-18T17:05:56Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.