Redshift Bulk Loader Failing

[hsinom1]

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?

[hsinom1 · Accepted solution]

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.