SQL Editor Tool for In-DB Workflow

[hsinom1]

While In-db tools are very helpful and cut down the time needed to write complex SQL , there are some steps that are faster by directly writing SQL like window functions- OVER (PARTITION BY .....). In Alteryx, we need to create multiple joins and summaries to perform a window function. It would be immensely helpful if there was a SQL editor tool for in-db workflows where we can edit the SQL code at any point in the workflow, or even better, if they can add an "edit" function to every in-db tool where we can customize the SQL code generated and then send to the next tool.

This will cut down the time immensely and streamline the workflow to make Alteryx a true contender for the ETL solution space.

[simonaubert_bd]

Hello @hsinom1 

1/you can use pure sql in in-db formula but I think you already knew it

2/there are already a few idea about this topic such as this one :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Embedded-REAL-SQL-query-builder-and-free-SQL...

you can find other ideas here :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas/label-name/category%20in...

and here :
https://community.alteryx.com/t5/Alteryx-Designer-Ideas/idb-p/product-ideas/label-name/in%20database

[SeanAdams]

Agree with you @hsinom1 - general support for Window functions in the push-down in-DB tooling.