Dataflow: Ability to write SQL within a ETL-Dataflow

Godiepi

ETL dataflows are very user friendly and great to work with in some cases but, sometimes I have found the need to be able to drag and drop a control that would allow me to write a piece of MySQL code to do a more complex transformation.  Since it is not an available option I have had gotten to use either ETL or MySQL.

 

I like how easy it is in ETL to drag and drop a control and after few clicks selecting what you need, the job is done and it came to my mind that if there was an option to write MySQL , the ETL dataflow would be way more powerful.

AS

@DaniBoy or @mattchandler, is there another thread out there for this great and much anticipated idea?  It's been in the hopper for a while.

btm

Thank you for submitting this @Godiepi. I am assigning to our product manager @StevenC to review and comment.

StevenC

@Godiepi fantastic idea!!!  We are currently working to improve Magic ETL, and this definetly is something that we are considering (among other things as well ). Having a more-powerful and easy to use Magic ETL is a high priority for us, so please keep watching for imporvements and submitting your ideas and suggestions.  

 

amycaroline

yes, please!

this would be amazing!

AlexDengate

Noticed this thread hasn't been updated in a while.

 

New to Domo, but I feel this would be amazing.

Pretty new to regex expressions and not quite super comfortable with them yet, but I can get the job done.

However, instead of writing regex, being able to use built in SQL functions or code would be great!