-
Create a SQL tile within Magic ETL
It would be great to have a SQL tile within Magic ETL where users can write SQL much like what users can do with the Python tile. This would open up the ability to do conditional joins and looping in Magic ETL. It would also remove some of the dependencies on MySQL, Redshift dataflows which can be very slow to run.
-
Option to align Magic ETL functions to a grid
I'd like to be able to have my ETL functions precisely aligned in the Magic ETL editor so that they're easier to read quickly. When I'm creating an ETL, I tend to place functions where it makes the most sense to me, but if a function is a little bit off-centre it's not obvious which function it's supposed to be next to…
-
Ideas for new features in Domo from AMRO
Hi! We came up with some suggestions for new features in Domo in one of our recent internal discussions, that we would like to share with Dojo members. We think these enhancements could be useful not only to us but other Domo clients too. (if the image is not clear please see the attached excel instead) Really looking…
-
Global Formulas in ETLs
I would like to have a way to create complex formulas, save them (similar to the Beast Mode Manager) , and then have them available for use in ETLs; when an ETL that contains one of these formulas is executed the current version of the formula would always be used. This would have two use cases (for me): If there is a need…
-
What does the "Use Raw Numbers" setting for email connectors do?
Recently, we ran into an issue with one of our email connector datasets where a "Currency" column was being formatted as a string which was causing issues down the line in other dataflows. We're not sure how the problem initially started, but we found that enabling the "Use Raw Numbers" setting seemed to fix it and…
-
Estimate processing time of each step in Magic ETL v2
When creating any ETL the user interface is unable to alert you the impact of the change will make on the dataflow. If I create a transformation that is not optimized I should be alerted this will increase process time. It would be helpful to have a time estimation in Magic ETL itself as to how long each step will take…