community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx Designer Ideas

Share your Designer product ideas - we're listening!
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

SQL syntax highlighting and formatting in SQL Editor

The SQL Editor window could have a better presentation of the SQL code; two issues observed

  • First, that it's simply plain text without even a fixed-width font, much less syntax highlighting
  • Second, if you type in some manually formatted SQL code (e.g. with line feeds and indentation), then click on the "Visual Query Builder" button, then click back to the "SQL Editor" button, all the formatting is lost as it is converted to one run-on line of code, which is very difficult to read.

I understand that going between the Visual Query Builder and the SQL Editor is bound to have some issues; nonetheless the "idea" is to allow a user friendly display in the SQL Editor window:

My "implementation ideas" are based on a couple minutes with google, so hopefully this is a very feasible request; my user base is very likely to spend more time in the SQL editor than not, so this would be a valuable UX addition.  Thanks!

 

25 Comments
Meteoroid

I was surprised at how poor the SQL editor was when I first opened Alteryx. Not having to constantly move back and forth from an editor would definitely help.

If motivation is needed to get this back to consideration, I could point out that Dataverse has both fixed-width fonts and syntax highlighting...

Alteryx Partner

+1

I agree... Somehow Alteryx devops don't wanna build capabilities on SQL but it's a legacy that no one would be able to kill for another 20 years...

 

So better increase the #qualityoflife for Alteryx users...

Thanks for sharing this information! You know, I also was searching for the right way for formatting SQL code and have tried various solutions. I think SQL Complete is a pretty good tool for advanced code formatting have a look at it

Alteryx Partner

There are at least five ideas on the same theme, all with a lot of stars.

 

@AlexP: You have the opportunity to satisfy a lot of users with a very light improvement existing in every DB tools, such as dbeaver, squirrel, dbviz, sqltools, flamerobin, razosql... and the other dataprep products already get it.

Alteryx Partner

Check out https://teamsql.io/ too...