In DB Input tool to Support CTE statements

[AdrianaCortesB_7]

Sometimes I need to connect to the data in my Database after doing some filtering and modeling with CTEs. To ensure that the connection runs quicker than by using the regular input tool, I would like to use the in DB tool. But is doesn't working because the in DB input tool doesn't support CTEs. CTEs are helpful for everyday life and it would be terribly tedious to replicate all my SQL logic into Alteryx additionally to what I'm already doing inside the tool. 

I found a lot of people having the same issue, it would be great if we can have that feature added to the tool. 

[simonaubert_bd]

Hello @AdrianaCortesB_7 

could you clarify where you have an issue ? is it with the visual query builder or when you run your workflow?

Best regards,

Simon

[AdrianaCortesB_7]

Hi @simonaubert_bd,

An error appears while running the workflow. And only when writing a CTE logic in the query builder of an In-DB input tool. After checking Alteryx documentation I realized that In-DB tools do not support CTE logic. Which is why I would love to rise this request. So that the tools can support it. 

[simonaubert_bd]

hello @AdrianaCortesB_7 

Found this existing idea with more votes ;)
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-to-Allow-Common-Table-Expressions-in-C...