Error while creating table in Redshift
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
ishajindal
5 - Atom
‎01-19-2021
05:54 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I am getting The COPY failed with error: Error from AWS: The Content-MD5 you specified did not match what we received. error while creating a table in Redshift using Amazon Redshift Bulk Loader.
Previously the same workflow was working fine. From the past few days I am getting such COPY errors.
Labels:
- Labels:
- Amazon S3
- Database Connection
2 REPLIES 2
Amarendra
10 - Fireball
‎01-19-2021
06:35 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ishajindal Can you check if your file formats have changed?
Also, here is a reference - https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-on-uploading-data-into-AWS-S3-bu...
‎01-19-2021
06:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank You @Amarendra!! Increasing the size of bulk load chunks from 128 to 1000 did resolve the issue. The data got uploaded.
