community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

Redshift Bulk Loader Failing

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?

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