-
Dataset dropdown for tile inputs and ETL update triggers should be searchable/filterable
In Magic ETL, the Inputs configuration tab for certain tiles includes dropdowns for selecting input datasets for that tile, but the width of the dropdown is limited and cuts off longer dataset titles, and the dropdown items are not in alphabetical order. In this scenario, or when there are a large number of inputs…
-
Tip of the week #30: JSON Expander Tile for Working with JSON Data 🧩📊
Working with JSON data often adds friction to your DataFlows. Nested structures, arrays, and long text fields usually mean custom parsing and extra logic. The JSON Expander Tile in Domo Magic ETL makes this much easier by letting you visually explore JSON structures and expand them into clean columns in just a few clicks ✨…
-
Add from Canvas
I received an email that add from canvas was added to my Domo instance, however I am not seeing the plus sign on the canvas in either existing ETLs or new ones. is there something I need to do to turn it on?
-
BUG - Constrained Joins not working
Noticed a few weeks ago that the constrained join feature on the join tile (one-to-many and many-to-one) in Magic ETL does not work, allowing joins that should fail to process. This is a big deal for us as we use the join constraints to ensure we don't have any cartesian joins in our data. This bug has huge implications…
-
Add Magic ETL Runtime History to History tab
The current magic ETL history page for any particular ETL shows the run successes near the top of the page, in a style that looks similar to a history of git-commits. Hovering over a square shows the number of successful runs on that date. We would like to implement some method of process control visible to all domo users…
-
Set a time threshold on dataflow runs to alert/cancel
We have a dataflow that runs quite frequently for an embedded dashboard. It usually takes under 1 minute to run, sometimes around 2 minutes. But over the last couple of weeks it took over 24 hours to run and fail twice. So it's technically running for 24 hours, without updating the embedded dashboard, and then I'm only…
-
Configuring ETL to pull from 2 datasets
I have a card that uses two datasets (A and B). A contains master information such as name, description, location, total1, total2, etc. B contains detail transactions that make up the totals. The card presents data from both: Name, Description, detail1, detail2. Detail fields are from B and summarized on Name field from A.…
-
Fixed Input Tile - subsequent join doesn't recognize column schema
I've used the Fixed Input tile several times and have noticed when I create a fixed input and then connect it to a subsequent join, the column selection in the join references a different input dataset upstream instead of the schema of the fixed input. I can eventually get it to recognize the right columns by clicking…
-
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…
-
Allow Group Ownership of Magic ETLs in DOMO
Currently only Datasets can have group ownership, however it would be a great timesaver if a group can have ownership of an ETL in Domo. It would make ownership more streamlined and controlled.
-
Magic ETL | CTRL + A to select all tiles
Instead of zooming out in the dataflow to select all tiles and then using “Copy to Clipboard”, it would be useful to allow users to simply hover the mouse over an empty (“No tile”) area and press Ctrl + A to select all tiles. Benefits: In large dataflows, this avoids the need for an extra click and a long drag to select…
-
Variables no longer carrying over datasets/cards
I used to be able to create a variable, and it would be available across all datasets and cards. I've recently noticed that variables no longer behave this way in our instance, and if I create a variable on one card, it doesn't even carry over to other cards in the same dataset. Is anyone else experiencing this behavior?
-
Optimizing Your Consumption: A New Governance Series 🔎 Session 2
Optimizing Your Consumption: Governance Strategies | Session 2 In continuation of our 3️⃣ Part Series , part 2️⃣ of these series we'll be covering ETL Best Practices and using the Governance Toolkit to automate the clean up process of your Domo instance. Reach out to your AE's if you have any extra questions or would like…
-
How can I get my navigation back when working in a Magic ETL?
Currently, when I am working in an ETL, the only way for me to return to the rest of Domo is to either run the ETL or open a new browser tab. Do I need to adjust my settings? I am tired of continually exiting. This is all I see when inside of an ETL. Domo to use Domo.
-
Trigger a workflow only when ALL the input datasets I selected have been updated
Most of our Magic ETL and Jupyter notebooks workflows require a trigger that triggers only when ALL the input datasets I selected have been updated. We update input datasets from Workbench. Larger datasets take longer to update than smaller ones. The Magic ETL must run only when all the input datasets are up to date, and…
-
Domo Community Declining - Oliver to Blame?
Hi my fellow Domo Sapiens, I've noticed a drastic drop in community activity now that the chat agent, Oliver, is present on the landing page and able to help answer questions. "Softball" questions (easy ones that I could answer) are less common now that Oliver handles the easy ones. While I do appreciate the efficiency of…
-
Allow Window Functions in MagicETL Formula Tile
It would be helpful to be able to write MagicETL formulas using window functions, similar to in beast mode. While the Rank & Window tile is often sufficient, there are some use cases where having this feature in the Formula tile would simplify the dataflow steps: Using a sum window function with unbounded rows This does…
-
Run only when all input datasets have been updated
Please add a run trigger that will trigger only when ALL the input datasets I selected have been updated. That applies to both Magic ETL and Jupyter notebook. Currently, when setting a run trigger and adding a condition to run when selected input datasets have been updated since the last successful run, the dataflow will…
-
Partitioning & Magic ETL Workflow - Does a Formula in an ETL happen retroactively?
Hi! We created a Magic ETL for GA4 data coming in. We are created a schedule to pull data through the connector every 7 days that we want to partition by the date field to make sure we have all of the data. Right now the output is Partition but within the Magic ETL flow we have a formula that might be changed quarterly. My…
-
Formula Editor Scrolling
Early last year, I reported an issue with the Magic ETL formula editor where it fails to function correctly once the amount of text requires scrolling. Because my data is healthcare-related, I’m unable to provide a screenshot. When the editor scrolls, it no longer accurately tracks cursor position or properly highlights…
-
Pivot Woes - Losing Rows causes total to change
I'm trying to Pivot out the "Actual or Budget" column so that I can create a variance calculation I'm using ALL columns (Except Actual or Budget in the "Group By" section, but I'm still losing some values. I know that values are lost because I'm comparing the total of a field before and after the pivot. Any ideas?
-
Magic ETL Search and Replace
Domo recently added search functionality in Magic ETL, which has been a fantastic enhancement—thank you for that. Would it be possible to add a Search and Replace feature as well? Often, after a dataset and ETL have been in use for some time, business requirements change and field names no longer align with their current…
-
ETL Development Assistant
I’d love to see a built-in “Magic ETL Help Bot” : a chat-style assistant that lives directly inside Magic ETL. The goal would be to let users ask questions about how to design, troubleshoot, or enhance their data flows, and the bot would return practical recommendations or step-by-step guidance. Essentially, it would feel…
-
Warning icon - clickable
When a DataFlow displays an orange warning icon in the upper left, users currently have no reliable way to determine the cause of the warning. I currently have a dataflow showing a warning indicator, but there is nothing visible on the page that explains what the warning is. I’ve checked the datasets and the tiles at the…
-
Feature Request: Allow Copying Tiles Between DataFlows While Retaining Dataset Connections
Currently, when copying a tile from one Dataflow to another, the copied tile does not retain its connection to the original dataset. This means the new tile effectively becomes a separate output with a new dataset ID, which can create duplication and disrupt downstream processes or cards connected to the original dataset.…
-
How to execute partition in output tile for 2 columns [Magic ETL]?
Hi, I am trying to to use partitions in 'Update Method' option in an output tile of a dataflow. I want to do a partition for 2 columns: date (date format) and brand (string format). So far, I have only been able to do it successfully by date. I see that there is a limitation for only one column when selecting Partition as…
-
See underlining SQL script in Magic ETL?
For example, I have this ETL and I want to see the underlining SQL script that DOMO use to run this ETL. Is it possible?
-
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…