Error on uploading data into AWS S3 bucket

Hello,

I tried to upload data into snowflake using an output tool with ODBC snowflake bulk loading. It was working fine until yesterday. I received this error message:

Error: Output Data (1849): The COPY failed with error: Error from AWS: One or more of the specified parts could not be found. The part may not have been uploaded, or the specified entity tag may not match the part's entity tag.

I looked at this article, but there was no information how to fix this issue.

Sincerely,

knozawa

Output

Tips and Tricks

Amazon S3

Best Practices

Database Connection

Accepted answers

knozawa

Hi @ntobon ,

Interestingly, when I decreased the size of bulk load chunks to 100, it gave me the same error. On the other hand, when I increased the size of bulk load chunks to be 1000, I could successfully upload the data into AWS S3 and then snowflake database.

Size of bulk load chunks.png

Sincerely,

knozawa

All comments

ntobon

Please review the following article has some explanation of what is happening and what you may need to adjust:

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-uploading-to-S3/td-p/55232

ntobon

Did you have a chance to review that discussion?

Quick Links

This months top contributors

AkimasaKajitani 387

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335