Hi!
I'm using Input Data Tool with SingleStore and want to execute an anonymous code block in the "Pre SQL Statement".
The problem is that Alteryx splits it by semicolon and sends it to the ODBC driver one by one.
The same problem happens with create procedure statements.
Is there a way to configure Alteryx to not split statements in the "Pre SQL Statement"?
@Adalbert - did you ever find a workaround for your code to make your presql statement work? encountering the same issue.