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.
When trying to create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
Error: "The following fields are not updatable members of the target table" received when performing an update to a record with the Salesforce Output Tool. The column is locked for editing by your Salesforce Administrator or is the incorrect primary key to reference for updating the record.
When Alteryx creates a query determined by an In-DB workflow, if the workflow includes a Join In-DB tool, Alteryx aliases the tables to be joined as "Left" and "Right". These are reserved words for some databases.
Image Input tool fails with the "unable to open " error if the length of the path (including filename) exceeds 260 characters in Windows 10 and Server 2019. However, there is no issue in Server 2016. All have long path enabled.