Hello,
My organization is exploring efficiencies that can be made by utilizing In-DB tools in Alteryx Designer. For our first use case, i have been working with a table that when updated deletes the old data then appends the new data (delete data and append in the write data in-DB tool). When I attempt this however, I get an error saying the table doesn't exist, or i don't have permissions. Our IT team has given me delete, insert, create, read, etc. permissions, and on top of that, when I select the append existing option for the in-DB tool it works just fine... Anyone have this experience before/know how to correct it so the table properly deletes data, then appends the new data?
Looking at other forums on this some have mentioned checking the pre-SQL, but my use case is a little different as I am using the Data Stream In tool on a dynamic input. This little tidbit may not add value to the conversation, but thought i would add it just in case.
