2

Recently I am curious in whether upload data to redshift through node js is possible. i followed the link below: https://walkingtree.tech/loading-data-to-redshift-using-nodejs/ but i dont understand what it has been done via S3? I would like to upload data to redshift through node js specifying the specific table and attribute field that i want to insert the data. Is it possible?

Improve this question
2
  • When you say attribute, do you mean column? Commented Jul 8, 2021 at 7:46
  • yes, like in a table there are id, name etc Commented Jul 9, 2021 at 1:01

1 Answer 1

Reset to default
1

Amazon Redshift is a database. You can certainly connect to it using a JDBC connection and perform INSERT statements to add data.

However, adding individual rows is very inefficient in Redshift and stores data in a less-than-optimal format. When loading large amounts of data, it is best to load the data via Amazon S3. This allows Redshift to load the data in parallel across multiple nodes, and sort it for best database performance.

See: Amazon Redshift best practices for loading data - Amazon Redshift

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.