Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Amazon S3 download fails - From Alteryx to Snowflake

srikant96
9 - Comet

From Amazon s3  download tool into snowflake output database - the ODBC works for few records and then aborts . Bulk load gives this bizarre error after showing 100% in the output tool . And when I click on the node to view data it shows 212,000 rows but table is empty 

 

Error: Output Data (7): The COPY failed with error: We were unable to remove some files from S3 after the copy operation!10Error from AWS: The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.
Error from AWS: The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.

2 REPLIES 2
srikant96
9 - Comet

Amazon S3 to database Bulk load error.PNG

srikant96
9 - Comet

Endpoint on output tool was incorrect as generated by ALTERYX . Default END points worked for Amazon s3 download and amazon S3 upload but writing into table ( output tool) failed with this error . 

 

The bucket you are attempting to access must be addressed using the specified endpoint. Please send all future requests to this endpoint.

 

Our default is us-west-2 . Alteryx tool generates us-east-1 and hence the error 

 

Solution : Keep default everywhere but override in output tool 

 

This is valid only if settings by Amzon S3 folks in your company is done right ( Default Region set up , Bucket Assigned to this . Encryption enabled AE 256)

Labels