redshiftTools
redshiftTools copied to clipboard
R: Error when I try to upload a data-frame to a new table in Redshift database
I'm trying to upload the content of a data frame into Redshift database using the following command:
redshiftTools::rs_upsert_table(MyDataFrame, dbcon=con, table_name='NewTableInDB', bucket="mybucket")
but it throws an error below:
Error in parse_aws_s3_response(r, Sig, verbose = verbose) : Forbidden (HTTP 403).
How can I resolve it?
Just saw it, most likely you don't have permissions to write in "mybucket" with the AWS Key or Role you have setup in your environment.