Hello Everyone,
I have a SQL query that contains several "WITH AS" statements in the very beginning and then a SELECT statement that pulls from those WITH AS statements. When I use the "CONNECT IN DB" tool, the query will run with no issue, but then when Alteryx sends it to the "Data Stream Out Tool", I get an error that begins with "Error: Data Stream Out (3): Error opening "SELECT * FROM "WITH cgGrouplvl AS (......". I have another simple query with only 1 WITH AS statement in the beginning and there is no problem with Alteryx, but I am experiencing this issue with a query that has multiple WITH AS statements in the beginning. Is there any other tool that can accommodate this? Please note that the query works perfectly fine in SQL tools like ORACLE SQL Developer.
