Write In-DB tool not working as expected

abacon

I am pretty new to the In-DB tools, we have always been fine with the normal Input/Output tools for DB's but I wanted to test them.

We have them working and data is passing through, however when I try to writeback to the database, the option to delete data and append only deletes data, and my table ends up empty. If I do the Overwrite (drop) option, connections from a few tools work but others won't, it almost seems as if the pre-sql scripts the tool runs to drop then create the table don't run in the correct order as I get an "invalid object error".

Anybody have any tips or fixes for this?

Bacon

jrlindem

Warning: This is not a direct answer to your need 😅

...but, I have often found that since In-DB tools require you to be in the same database environment (meaning it just manipulates data in the same space), then using procedure language SQL or Tasks ends up working better.  The benefits are you get to avoid some of the In-DB quirks of Alteryx (shhh don't sell me out for saying that) and you get to retain code logic in a repository friendly format.

To that end... do you NEED to use the In-DB tools?  -Jay