Redshift Bulk Loader Failing
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I have been able to write to my Redshift db using the ODBC driver but it is very slow.
A colleague who uses Alteryx said it is very fast if I use the Redshift Bulk loader.
So I got the AWS Access and Secret Key and tried to create a table using the bulk loader. It kept failing with the following message.
Error: Write Data In-DB (7): Error SQLDriverConnect: [Amazon][DSI] (20032) Required setting 'PWD' is not present in the connection settings.
Has anyone encountered this issue before?
Note: I do not know what a bucket name is, so i just entered random text there, could that be causing this issue?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi,
I was able to figure out the issue. Although it says that the Username and Password is optional and I saved it in the driver, we apparently need to enter them in the box.
It worked right after.
![](/skins/images/1AD6617C767659D8A9F9801BEDFCFB20/responsive_peak/images/icon_anonymous_message.png)