CODEWITHSUNDEEP
node.jsamazon-web-servicesamazon-redshift
user16304829
user16304829

Reputation:

Upload data to redshift through node js

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?

Upvotes: 2

Views: 760

Answers (1)

John Rotenstein
John Rotenstein

Reputation: 269091

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

Upvotes: 1

Related Questions