Alteryx SQL "Text Truncated"

Question

Hello,

Came across something I have never seen before.  On input data tool, I am querying oracle database and when the sql reaches a certain length, I get the error "Text Truncated".  This causes the query to error and no results returned.  See highlight in attached screenshot.

Any help is appreciated!

Jesse

Text Truncated.PNG

nagols5445 · Answer

I am.  Increase the size of the string?  Different data type?

apathetichell · Answer

are you using dynamic input in-db and passing the query in as a value there? I find that string column size tends to be more of an issue than SQL query size.

nagols5445 · Answer

If this was a SQL query if you break up the where clause you will get a different result.  I am running into this issue also.  My result contains 26 columns.  The where clause contains 13 conditions and there is a group by.  The total length of the SQL is about 3500 characters.