Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Alteryx is here to help you solve your biggest data challenges. Read about the new Virtual Solution Center here.

Vertica Write Data In-DB error

5 - Atom

I'm attempting to use write data in-DB on Vertica and am getting the following error message:


Error: Write Data In-DB (46): Error running PreSQL on "NoTable": ERROR 4566: Relation "Tool44False_5247" does not exist


I'm creating a new table and have permissions ( this works using Alteryx standard workflow).

I've tried changing the Table/Field sql name style for write to none.


Any suggestions on this would be very welcome.

5 - Atom

After further digging, the problem is with using the sample in-DB tool to sort my output before writing it back to the database.