Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Redshift Bulk Loader Failing

hsinom1
6 - Meteoroid

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?

1 REPLY 1
hsinom1
6 - Meteoroid

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.

Labels