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

'Tis the season to be spooky! Read our new blog, How Spooky is Your City? Mapping and Predicting Scary Stuff. In it, @SusanCS provides a fun glimpse into using data to figure out the creepy quotient of where you live! And don't forget to check out our Digital Costume Thread to get yourself in the mood for a candy binge!

Guys Please, Color Coding in the SQL Qry Editing Window - we need this

We need color coding in the SQL Editor Window for input tools.  We are always having to pull our code out of there and copy it into a Teradata window so it is easier to ready/trouble shoot.  This would save us some time and some hassle and would improve the Alteryx user experience. ( I think you've used a couple of my ideas already. This one is a good one too. )

2018-10-18_7-49-16.jpg2018-10-18_7-50-52.jpg

 

15 Comments
16 - Nebula
16 - Nebula

+1 I would love to see this

Alteryx Certified Partner

giphy

11 - Bolide

Also, pls fix the bug I found.  Thanks in advance.

7 - Meteor

Coming from a purely SQL background and using existing SQL queries, this is probably my biggest complaint about Alteryx. It's nearly impossible to read SQL code in that box and i end up copying it into SQL mgmt studio to read it but then it comes over as one long string.

Alteryx Partner

Such a good idea and basic features I allowed myself to take it in https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Embedded-REAL-SQL-query-builder-and-free-SQL...

 

 

11 - Bolide

I'm hopeful.

7 - Meteor

+1

5 - Atom

+1

We are currently in testing and this was one of my first thoughts!

Colors + indentation for sub queries. 

 

 

Alteryx
Alteryx
Status changed to: Coming Soon

Thank you for this suggestion. The SQL editor will have color coding in an upcoming release.

16 - Nebula
16 - Nebula

Outstanding!  Great news.   

And will it respect food indenting practices too?

 

Select

      FieldA,

      FieldB 

From

      Table1

       Inner join table2

             On table1.fk = table2.pk

Where

       Field3= x

 

 

Right now the editor scrubs all your correct indenting if you change tabs