Anonymous code blocks in "Pre SQL Statement" is split into several statements

Adalbert

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"?

photo1629449108.png

photo1629449123.png

mbarone

@Adalbert - did you ever find a workaround for your code to make your presql statement work?  encountering the same issue.