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.
Using Redshift ODBC connector, if I configure a Pre SQL statement inside an Input Tool, as soon as the Input tool is deselected (white space is clicked in workflow area), the Pre SQL statement executes without even executing the workflow.
e.g. putting a CREATE TABLE statement as pre SQL will create the table prior to the workflow being executed.
There should be no reason for the Pre SQL statement to execute until you are ready to execute the whole workflow. If there is, then the Pre SQL statement should be done outside of Alteryx.
Please change Alteryx to NOT execute Pre SQL until workflow is executed