Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Embedded REAL SQL query builder and free SQL Query

As of today, you can pass SQL from :
-input tool

-output tool

-connect in-db

The user interface is very limited, the kind of query you can pass also, welll, not very user-friendly. This generates a lot of frustration among users.

What do I suggest :
1/ A direct button "Query Builder" without having to open a new wf and drop an input box and then go with the presql tool and fight to build a query.

2/ Basically the same features than Dbeaver (https://dbeaver.io ) or DBvisualizer (https://www.dbvis.com/) or SQUIRREL http://squirrel-sql.sourceforge.net/ 😞
  -Ability to pass any SQL Code I want (such as update, create, truncate, etc...) when I come from the button, "protected" sql when I am in a workflow
  -autocompletion

  -color coding (The idea is not new )

 
3/ A box "Free Sql Query" that I can branch on a indb or standard wf to pass any SQL query. The Output would be the same as input, just like it would be with a block until done.

5 Comments
simonaubert_bd
13 - Pulsar

(please note all the tools below are open-source)

simonaubert_bd
13 - Pulsar

For reference :

SQL Editor on Talend https://help.talend.com/reader/c_2Som3s_um3RPoWUM_SlQ/pv89bv2UgAhtCoBhtIGpOg

A screenshot from Dataiku with sql color coding:tshirt-sql-query-02

 

 

 

SeanAdams
17 - Castor
17 - Castor

Hey @simonaubert_bd 

 

I do agree with you that having a generic SQL tool would be very useful - in fact that was suggested by @chris_love  here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Have-an-SQL-Tool/idi-p/5392

(it's worth you adding your support and comments to that thread)

 

As to the colour coding - this has been delivered in a later release - the team did a great job of this.

 
simonaubert_bd
13 - Pulsar

Hello @SeanAdams ,

Old idea 😛

I already have commented and adding my support two years ago when I found it.

Best regards,

Simon

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes