redshiftTools | R Tools to use Amazon Redshift with R | AWS library
kandi X-RAY | redshiftTools Summary
kandi X-RAY | redshiftTools Summary
R Tools to use Amazon Redshift with R
Support
Quality
Security
License
Reuse
Top functions reviewed by kandi - BETA
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of redshiftTools
redshiftTools Key Features
redshiftTools Examples and Code Snippets
Community Discussions
Trending Discussions on redshiftTools
QUESTION
I have the following data being sent to redshift with a replace table command- is there a command to instead add new rows to the table rather than replacing the entire thing?
...ANSWER
Answered 2017-Jul-19 at 22:29From How to bulk upload your data from R into Redshift:
rs_replace_table
truncates the target table and then loads it entirely from the data frame, only do this if you don't care about the current data it holds.On the other hand,
rs_upsert_table
replaces rows which have coinciding keys, and inserts those that do not exist in the table.
Does using rs_upsert_table
instead of rs_replace_table
solve your issue?
Community Discussions, Code Snippets contain sources that include Stack Exchange Network
Vulnerabilities
No vulnerabilities reported
Install redshiftTools
Support
Reuse Trending Solutions
Find, review, and download reusable Libraries, Code Snippets, Cloud APIs from over 650 million Knowledge Items
Find more librariesStay Updated
Subscribe to our newsletter for trending solutions and developer bootcamps
Share this Page