SQL Workflow Runs Fine Locally but Gives Error on Alteryx Server

Question

I have a workflow that create temporary tables in Teradata and does inserts and updates to the table (using PreSql). When I run the workflow locally it runs fine but on Alteryx server I get an error saying 'object (the temporary table I created) could not be found' even though it has already been created. Please help.

Thank you!

gandhineel26 · Answer

The Temp table is being created but I get an error during an update statement.

jrgo · Answer

Hi @gandhineel26

Does your connection string embed the credentials it should use or is it using Windows authentication? If the latter, it could be that the service account your server is configured to run jobs as may not have the necessary permissions to create temp tables.

You may also check the version the server has of the ODBC Teradata driver and confirm that it's a version that Alteryx has validated (https://help.alteryx.com/20212/designer/teradata).

If neither of these apply, reaching out to your DB admin would be your best option so that they can review the TD logs to see why  the temp table is not being created.

Hope this helps!

-Jimmy