Connect R to Amazon Redshift Database
This is a quick technical post for anyone who needs full CRUD capabilities to retrieve their data from a Redshift table, manipulate data in #rstats and sending it all back up again. Dependencies Load libraries library(tidyverse) library(RPostgreSQL) # INTERACT WITH REDSHIFT DATABASE library(glue) # FORMAT AND INTERPOLATE STRINGS Amazon S3 For this data pipeline to work you’ll also need the AWS command line interface installed. # RUN THESE COMMANDS INSIDE TERMINAL brew install awscli aws configure # ANSWER QUESTIONS access / secret / zone Read data Set connection You’ll need to replace with your own database credentials below:...