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 · Accepted solution]

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

[abacon]

@jrlindem That makes sense, it definitely has been quirky.

No, I don't need to use the In-DB tools, this can be done quite easily with the regular input/output tools. However, this has become something I personally NEED to figure out for my sanity and want to know for future reference so I/our team can leverage effectively in the future.

Bacon

[jrlindem]

@abacon Yep, I totally get that.  I too, have not spent a ton of time learning those tools.  I probably should too.  When you get it figured out, 'cause I know you will, let me know how you resolved it.  -Jay

[abacon · Accepted solution]

@jrlindem User error lol. I had setup a union to auto configure by position, not name. Somehow my data streams had different schema setups so that was jacking up the overwrite (drop). Still haven't figured out why my delete and append isn't working but I got it working enough to use so I am satisfied for now haha.

Bacon

[jrlindem]

@abacon Nice find and thanks for circling back.  Glad you're able to move forward.  Cheers, -Jay