Amazon S3 download fails - From Alteryx to Snowflake

[srikant96]

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.

[srikant96]

 

[srikant96 · Accepted solution]

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)