-
MetaData for datasets in Magic ETL
It'd be nice to have some basic metadata like last updated, row count etc on the datasets to better align data based on the dates or to do validation to check against missing data
-
Top 5 Selections within 7 day Rolling Period
I'm creating a dashboard to track complaints filed against a facility. Each record in my dataset is assigned to a unique ID. Each unique record displays 1 "topic" they selected. The "topic" is the reason for their complaint. I need to find the Top 5 Topics selected on each ROLLING 7 day period. So today's 7 day period…
-
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…
-
View older ETL version without making that version the active version
I would like to be able to view older versions of ETLs without needing to make them active first. The way I envision it you would go to the Versions tab of an existing ETL and see a new menu item when you click on a version's ellipsis: View Version. Choosing this would open up that version of the ETL in read-only mode,…
-
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…