ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Ideas

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

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

Submission Guidelines

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!

 

36 Comments
SeanAdams
17 - Castor
17 - Castor

Very good idea - we use Aqua Data Studio to reformat and clean up query structuring (indenting etc) and then paste it back into alteryx.   As you say - this is a very easy thing to implement (text colour based on tokenizing SQL which has a very limited set of primitives / keywords); and creating a simple indenting scheme.

 

This would make SQL queries much easier to read and work with.

JeffP
Alteryx Alumni (Retired)

+1!

Matt_Curtis
9 - Comet

+1

 

AliKat
8 - Asteroid

Yes, please! I'm trying to learn basic SQL commands, and this would be really helpful...

shoesnsocks4
7 - Meteor

+1

NickDuncan
7 - Meteor

+5

This would make a big difference for sql experienced analysts

@DawsonM @anthonyd @sharjosh @YeungDa @VizChic

ydmuley
12 - Quasar
12 - Quasar

This is a Great Idea!

 

It would be great to know the progress and possible timelines for the implementation!

 

1. Auto Format (Indentation of SQL Queries)

2. Intellisense while writing SQL Queries - This is a new suggestion

 

Thank You

SeanAdams
17 - Castor
17 - Castor

Fully agree with you @ydmuley

 

There are a few SQL related suggestion in the ideas section that may be worth adding your input to, give your deep knowledge of SQL!

ARich
Alteryx
Alteryx
Status changed to: Not Planned

This is not currently planned, but we'll consider this in the future.

JohnJPS
15 - Aurora

Thanks for the heads up Alex. For me this would be my #1 wish and I hope they at least consider some sort of fixed-width font and auto-formatting of the SQL, even if full-on syntax highlighting isn't offered.