Dumps a data frame to disk, copies to S3 and runs COPY FROM on Redshift

Source: R/redshift.R

Note that the related database's YAML config should include s3_copy_bucket and s3_copy_iam_role fields with attr type pointing to a staging S3 bucket (to which the current node has write access, and the Redshift IAM Role has read access) and the full ARN of the Redshift IAM Role.

redshift_insert_via_copy_from_s3(df, table, db)

Arguments

df

data.frame
table

Redshift schema and table name (separated by a dot)
db

database reference by name or object