This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I am trying to have Alteryx drop a table after the workflow is done. If I run the following code in Aginity, it works fine:
DROP TABLE TEST.TEST.TEST_TABLE
I have tried putting that code in the "Post-SQL", and while the workflow runs without errors, it doesn't actually drop the table. I am using the same credentials in both software platforms. I've also tried using the "Connect In-DB" tool and used that as the only SQL, and there too it runs without errors, but fails to actually drop the table.
Any suggestions? I feel it's something basic that I'm overlooking, but I can't seem to figure it out.
I tried to do this, but to no avail. My thought is that since I have no export, I could use the In-DB tool. It runs and does not give an error of any kind, but it doesn't drop the table. I also tried using the regular input tool via the post-sql statement. There too, it runs without error but doesn't drop the table.
Drop statements won't work with Connect In-DB Tools, as they're meant to accept SELECT statements.
With an Input Tool as your Post-SQL statement, it should work. But the table must exist so the command can be executed. It depends how you're workflow is set up, maybe you're running this command before creating the table, we'd have to investigate to check deeper this issue.
I tried that as well and it doesn't work. It runs without errors, but the table is there before and after the workflow runs and does not actually drop. For what it's worth, I'm running version 2018.1.4.44311.