Magic ETL

Paired coloured brackets in formulas
Would it be possible to implement paired coloured brackets into beast modes and Magic ETL formulas (a la Excel)? This would make it far easier to work with large and complex beast modes, especially with only single-level nesting currently available.
Does this count as a manual run if we are under a Consumption model
Does anyone know if this scenario counts as a manual run in Domo? If I modify the logic of an existing tile or add a tile to a legacy ETL in Domo and then adjust its schedule so that it runs 5 minutes after I make the changes so I could test the output. For context, my company just switched to a Consumption based model…
Run Dataset Input From Inside Magic ETL
There is often a situation where I am developing or troubleshooting a dataflow where I need to have the most updated version of a data input in order to continue my work in Magic ETL. The current process is to click on the dataset in Magic, go to the Details tab, click the link to open the dataset, click the options…
Overhead in Financial Statements
I'm trying to build out a financial statement from account level values. I'm almost there. I've got Gross Profit, Net Revenue, and EBITDA like so: CASE WHEN Account IN (Gross Revenue, Other Revenue) THEN VALUE ELSE 0 END AS 'Net Revenue' And then at the card level I can SUM(Net Revenue) to get totals for different…
Magic Power User Feature Ideas
I love magic and a lot of the new upcoming beta's like add node from tile will be a big help. I've created a custom chrome extension that I use to add features/fix bugs in Domo. I've got a few ideas from it that I think would fit within the ideas for power users. - Easier Re-order Select Columns Allow for the re-ordering…
Semantic Model vs MagicETL/Dataset Use Cases + Next Steps to Migrate
Now that Semantic Models are released to the Beta program, has any written or started to write up use cases for when to leverage them over MagicETL? What are the benefits? How can we migrate from one to the other simply? After some initial testing, semantic models seem like a viable alternative to a MagicETL dataflow for…
Label ETL execution "Successful" only after all outputs have been indexed
Current behavior: An ETL execution with multiple output datasets will be labeled with "Successful" status after any one of the outputs has finished indexing. If outputs vary significantly in size, larger outputs may not finish indexing (and therefore will not have new/updated data available) for some time after the ETL…
AI-Driven Documentation of Changes
When saving a dataflow, an optional text box appears where version changes can be manually documented. How cool would it be if Domo could pre-fill that text box with an AI-driven summary of the changes that occurred 🤩?? That summary could be edited by the user (or not, if they're lazy) and then saved, giving each version…
Changing dataset update method from Replace to Partition doubles data
We've noticed that if we change the update method of an existing dataset to Partition from replace, we end up with two records in the dataset for every new one (and both of them look identical, down to the field we're using for partitioning): it was quite the shock to see a dataset I expected to have 91 million rows…
Magic ETL | Split Join and Split Filter tiles
Hi friends, After a brief hiatus, the beta is back for the Split Join and Split Filter tiles! Split Join The Split Join tile is a new tile that allows you to configure multiple join types in a single tile and output the results of each join in its own output stream. This allows you to see not only what DID join as a result…
Anyone having issues with Split Filter in Beta?
I thought it was maybe something I did wrong, so I commented one out and tested my ETL using a simple, straightforward set of filters, and I am still getting an error, and it won't run.
Renaming Columns and NOT breaking cards
I am barely getting started with the vast DOMO world so forgive me if this is an obvious thing. I was recently creating a dataflow and some cards from that dataflow and decided to test something out. I created the card using a column from that dataflow and then proceeded to change the name of that column in the dataflow.…
Does Auto ML work with non-dataset inputs?
I have only ever seen this: But I want to do this: Oliver the AI says its possible, but it… has been known to hallucinate. Is it possible to preprocess data in MagicETL so that it matches the AutoML expected input and run it through the AutoML Inference in one go?
Updating Column Names Breaks Filters in Cards (and ETLs)
We have found an issue where updating the name of a field in a dataset causes filters using that column to break in ways that can be difficult to correct, and in the case of cards, disappear entirely without notification. For example, if the MajorAccountTypeCode column is renamed, the column disappears from the Filters and…
Turn on/off Magic ETL tiles
It would be really helpful to have the ability to turn on/off Magic ETL tiles. This is the equivalent of commenting out lines in a SQL dataflow so they don't execute when the dataflow runs but the effort in that section of the ETL is not lost and can easily be re-added.
Comment out tiles in MagicETL
When building complex ETLs it would be handy to be able to "comment out" tiles so they are ignored for execution. For bonus points, I'd like to be able to have an unterminated chain of commented-out tiles not block the ETL's execution.
Saved but Incomplete - where and why? - no explanation
The preview will run with a disconnected tile but the flow won't. In large ETLs it's not clear what the issue is and the error is not clear.
Making Sense of Wildly Unstructured Data
A system we use for event planning gives a report like I'm seeing below. Every bit of this data needs to be in a single row. Sometimes the data is given in the same cell as the data label, and others live in the following cell. Is there any way an ETL (or any other Domo solution) can help me with this? I don't have a lot…
Targeted Data freshness check during Dataflow execution
When a Dataflow executes with a Snowflake dataset it will use the previously staged dataset, and only copy in a update if the results of the previous data freshness check indicate that it should. Consequently, the dataflow will miss any updates that have happened since the last Data Freshness check. Considering the…
Instance Wide Magic Canvas Settings
A small thing, but can we set a default for Magic ETL canvas instance wide? Every time I create a new Magic ETL I must go into the setting to adjust to Large Canvas and Lines. All my older ETLs are on the default empty and small. It would be nice to have the option to sync all the settings across these ETLs. So two…
Any way to view schedule for dataflows?
Hi y'all! Hope everyone's having a good Monday so far. I'm trying to create a table card with a row for each DataFlow that has a trigger to run on a schedule. I looked through the DomoStats DataFlow History Dataset and Domo's Dataflow Details, but I can't find it. Is it accessible anywhere? I also looked through the API…
Dataflow Schedule
A schedule to view what dataflows are currently scheduled would be extremely useful to my team. Whether it's exposed as part of the dataflow object, in a report, domostats db, or Domo UI element, this feature would be appreciated. This would give us much more clarity into our current schedule for dataflows and allow us to…
This posted 3 times and you seemingly can't delete a post so I'm just editing it out
This posted 3 times and you seemingly can't delete a post so I'm just editing it out
This posted 3 times and you seemingly can't delete a post so I'm just editing it out
This posted 3 times and you seemingly can't delete a post so I'm just editing it out
Improve Error Messaging and Alerts in Magic ETL
A user recently shared this challenge while debugging a dataflow they found that a Group By tile not connected between the input and output tiles was causing the entire dataflow to fail. Since the tile wasn’t in the main path, it wasn’t obvious that it was the cause, and no error message pointed to it. Suggestion: Please…
How do we request a Beta Feature to be enabled? (can we join a beta pilot late?)
hi! when the whole domo beta program kinda regrouped, i had a form to indicate which Beta's we wanted to participate in. after recently joining a Domo Connectors stop, there's at least a few others that i wish we had tested out (like split tiles for example) - is it possible to request those to be enabled or did we miss…
Is it possible to get Jupyter Workspaces enabled in a student instance of Domo?
I am using Domo for my masters program and have a need for more advanced features like the data science tiles and Jupyter Workspaces. Is it possible to get this enabled?

Magic ETL

Discussion List