Introduce CTE Functions and temp tables reading from SQL databases into Alteryx

[dharamyiyer29590]

Introduce CTE Functions and temp tables reading from SQL databases into Alteryx.I have faced use cases where I need to bring in table from multiple source tables based on certain delta condition. However, since the SQL queries turn to be complex in nature; I want to leverage an option to wrap it in a CTE function and then use the CTE function as an input for In-DB processing for Alteryx workflows.  

[simonaubert_bd]

Hello @dharamyiyer29590 

There is already an idea CTE here : 
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/In-DB-Input-tool-to-Support-CTE-statements/i...

Does it cover your need?

Best regards

[dharamyiyer29590]

Yes it gets covered for me.