Did you know? SQL dataflow tip

AS

The dataflow text editor is pretty simple compared to other SQL enabled text editors out there.  You get to type your query without much assistance like you might find elsewhere.  On the plus side, however, there is some highlighting for reserved words (purple) and datatypes (green for numbers, red for strings):

 

 

Additionally, there is also a lesser-known autofill mechanism which can prove to save time and frustration.  

 

Want to insert the table name instead of copy/pasting or typing it?  Type the first letter and then hit CTRL+SPACE and see your input datasets that start with that letter:

 

Did you also notice FROM in the list?  That's because this same shortcut key works for many reserved words as well, and I started with the letter F, so I'm seeing all of the tables and reserved words starting with F.  But you don't have to type the first letter.  Hit CTRL+SPACE without any hints and see all of the autofill options, which include all of the dataflow reserved words as well as all of your input datasets.  The drop down list actively filters as you type:

 

And my favorite (though this is a bit buggier), load up your column names if you can't remember exactly what they are:

 

 

For this last one, you have to alias your tables and provide the alias and dot operator first, then hit CTRL+SPACE, before you see the column names.  It does seem to be finicky and doesn't always work, but is pretty helpful when it does.

 

 

For you SQL dataflow people, try this out and comment below with any additional features you find.

[Deleted User]

@AS,

 

Thanks for sharing this tip!

mlb

@AS If you type the table name, then a period, it will bring up the column names automatically.

[Deleted User]

@AS,

 

Thanks for sharing this tip!

Canioagain

Finally, this is awesome.  

mlb

Thanks for sharing this tip! This is an amazing time saver for making mysql data flows.

AS

UPDATE:

 

It appears Domo has made some changes to this feature, having automated the popup for reserved words and table names.  But I seem to have lost the ability to pull column names.

 

@DaniBoy would it be possible to get an official, current feature spec list from the PM over dataflow?

mlb

@AS If you type the table name, then a period, it will bring up the column names automatically.

AS

Thanks.  I'd still rather use the alias, but at least that has remained in some form.

[Deleted User]

Thanks @AS

 

@btm @JeriLarsen

 

Do we have an official document on the feature change per this thread?

 

Regards,