community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.

where the data is loaded in S3 before copying to Redshift

Meteoroid

Dear All,

 

I met a question when trying to load data from my local PC to Redshift. I am using Redshift Bulk and I learned that the mechanism of this tool is to upload the data to S3 and then copy from S3 to Redshift.

 

I would like to know where the data is uploaded in S3. As I am facing an error as below.

 

I am assuming it is due to permission issue and I uploaded the data to somewhere in S3 where I do not have permission to delete.

 

Error: Output Data (3): The COPY failed with error: We were unable to remove some files from S3 after the copy operation!10Error from AWS: Access Denied

Alteryx
Alteryx

@francis2016 make sure the bulk loader is set to the following settings. They are stored as temp files and deleted after the bulk upload process is done. 

Digan
Alteryx
Labels