redshiftTools icon indicating copy to clipboard operation
redshiftTools copied to clipboard

R: Error when I try to upload a data-frame to a new table in Redshift database

Open AlexSiormpas opened this issue 5 years ago • 1 comments

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?

AlexSiormpas avatar Jun 05 '19 07:06 AlexSiormpas

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.

sicarul avatar Jul 11 '19 21:07 sicarul