Magic ETL

Need to display total count to be displayed on Grouped bar chart.
How to display a total rows count for each individual. Our major need to show the total inside the same chart.No option in chart properties to select show total rows count under data label settings.Is it possible to display a total for each series in a domo grouped bar chart.
Variables inside Magic ETL
It would be nice to be able to declare a variable inside the ETL whose value could be used elsewhere like you would in a TSQL script declare @Date as date set @date='20260712' then for anyplace you want to reference a date you can drop in @Date. This would help make using the date tiles so I can have a single branch to…
Magic ETL: AI Text Generation Tile
Has anyone noticed a pattern in the AI Text Generation Tile regarding run time? Two days ago, I passed through 100 rows to test the prompt and my ETL ran successfully in 10 minutes. Then I passed through 23k rows and it ran in about 55minutes. However today, processing 23k rows again after 9 hours with an "unknown error"…
Semantic modeling - support for repositories needs to be added
We are taking part in the semantic modeling beta. The feature is coming together nicely and we were looking forward to using it behind some of our dashboards. However, we're running into problems on this front: it's currently not possible to use repositories to deploy a semantic model from one environment to another. On…
Can we use a semantic model as a data source in Magic ETL?
I'd like to use one of our semantic models as the basis for a new dataset, rather than having to recreate all of the joins in Magic ETL. Is it possible to use a semantic model as the input to an ETL? The only workaround I've come up with is creating a table card from the semantic model and exporting the data from that, but…
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…
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…
SQL Script
In standard SQL, aggregate functions such as SUM(), AVG(), COUNT(), MIN(), and MAX() are typically used in conjunction with a GROUP BY clause when selecting non-aggregated columns. This ensures that the output is deterministic and logically grouped. In the Domo SQL Script tile, it appears that aggregate functions can be…
Control ETL Trigger Refreshes Based On Root Datasets Or a SQL Query Result
Currently we have a Domo view that is comprised of 4 or 5 different datasets. These datasets individually refresh the time between the first dataset updates and the last one updates is about 5-10 minutes. I have ETLs that have this singular view as my source input, if I put a trigger condition on it for when datasets…
Mini Window gone
I don't know why but for about a week now, my ETLs don't have that little mini window you can use to move around the ETL. I'm thinking I must have toggled that feature off, but is that even possible? Thank you
Dataset Deletion - Disable Upstream Dataflow Branch / Allow Upstream Dataflow to Still Run
When viewing a dataset, you can see the downstream impact of deleting that dataflow. The problem is, if you delete a dataset that is an output of a dataflow, it makes it so that dataflow can't run. This is an issue if that dataflow has multiple outputs and other outputs are still needed. It would be nice to have the option…
How To Use DomoGPT Large V2.2 AI Service Layer In Text Generation Tile
I can't find the DomoGPT Large V2.2 AI service layer in the text generation tile, is it not available in the beta program?
Same period last year measure
Is there a way I can get the data for the same period last year? Example, I am comparing the sales of a salesperson for the first 3 months of 2026 and trying to see what the same sales would be for the first 3 months of 2025.
Field contains apostrophes(') likely introduced through HTML encoding, showing differently in hover
Field contains apostrophes (') introduced via HTML encoding, causing inconsistent rendering between table cards (which display values as-is) and bar charts (where apostrophes are missing or altered in hover text/tooltips). Beast Mode REPLACE functions did not resolve. How to solve this functionality. eg: " &#12"
Allow Groups as Owners of DataFlows
Today, groups cannot be assigned as the owner of any dataflows. This means, that any output of a given dataflow is by default set as the same owner. It also means that by default, error alerts are only sent to one person instead of a team. We have a use case involving a development team who cannot be granted the manage…
beastmode versus ETL formula - same formula, different result
In my screenshot, the "charge_hour_test" column and "test3" column are the exact same copy and pasted formula, but the "charge_hour_test" is being performed in the ETL and is incorrectly showing 7.0.00 whereas the "test3" is a beastmode and correctly showing 7.00. I can't figure out why they are mismatching each other. The…
Long Running Dataflow Alerting/Auto-Restart
We need to have the ability to understand when dataflows are running longer than the average duration. We would like to set user defined alert criteria based upon the dataflow's duration. For example: alert when dataflow has been running 15min, 1hr, etc. longer than the average for the dataflow. Having the functionality of…
Update Extract Dataflow Logic
This is the current return block of the domo function for Extract Dataflow Logic: return { dataFlowID, dataFlowName, parentObjects, enrichedActions, triggerSettings: metadata?.triggerSettings }; } When I pass a dataflow id that doesn't have a trigger I get an error in my workflow Function output results had the following…
Announcing the Datasource Swapper: Move your existing Cards, Views, and ETLs to new datasets in bulk
Hi everyone, I am excited to announce the release of the Datasource Swapper! Whether you are building new datasets because you are moving to a new data provider, transitioning away from materialized datasets in favor of Cloud Amplifier, or dealing with forced changes caused by vendor API deprecations, this tool was created…
MagicETL Completing, but Dataset not showing as updated. Fixes?
I have an ETL that runs every morning at ~3:30 AM. It usually runs about 1.5 hrs, then outputs 3 datasets. The ETL shows that is ran successfully. Two of the three datasets are updated to show the new data in the dataset. The 3rd (and most important) is still showing the data from the previous day and the time stamp on the…
Editable Dataset use as an input dataset in Magic ETL error
I created a Magic ETL using a Editable Dataset as an Input. When I run pre-view for the ETL, it show "Failed to get details for required DataSet 'editable_dataset_id' But when I click on the Tile "Input Dataset" in the ETL, go to "Data" Tab, I can see the column populated in there. Does anyone know why? And how to fix this?
Can output dataset be the same as an input/existing dataset in Magic?
I am trying to join form responses on a dataset to update the approval status of some journal entries, but don't want to create a completely new dataset. There are cards built to show statuses based on the input dataset, so the idea is that the form responses approving the entries would just update the status instead of…
Enhancement Request: Wildcard Column Search in ETL
The current ETL search functionality is useful, but it becomes limiting in complex pipelines where column names include prefixes and suffixes. In large-scale ETLs with multiple datasets, joins, and transformations, locating specific columns during logic updates is time-consuming and inefficient. Requesting a wildcard-based…
Dark Mode - AI Generate Formula
When using dark mode and using "Generate Formula" in Formula Editor, the text typed in is also black so you can't see what you type.
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…
Add which dataset triggered the Magic ETL to the execution details
Something really helpful is to add which dataset triggered a run on the details view of a Magic ETL run. A lot of times flows have many triggers and being able to quickly figure out which one can be valuable to make sure that run has the data needed or if it has ran due to some other dataset, etc.
Preview Row Count Estimates Can Round Differently/Strangely
My coworker, Nathan, sent me this meme which I think explains things pretty sufficiently. I imagine this is just a case of rounding up vs rounding down leading to the discrepancy. I doubt this would happen very frequently, but 1,000K does require a bit more mental effort to process 😂
Add AI in Formula
Add the "Write with AI" feature to the Formula tile in Magic ETL, similar to what's in the beastmode editor
Creative assets from Facebook
Has anyone had luck pulling in creative assets (links to content or embeddable content) from Facebook? I've tried many different configurations on the Facebook Ads Advanced connector and I assume I need a few different tables and some ETL work - but if anyone has some pointers on what components to grab I would be…

Upcoming Events

ACE WEBINAR | Change Detection, Decoded: Catching Drift Before It Becomes a Problem
Join David Brader in this hands-on AI Academy session, "Change Detection, Decoded: Catching Drift Before It Becomes a Problem," where he walks you through building a production-grade change detection system entirely inside Domo. No machine learning required. You'll be provided with all the assets you need: a sample…
ACE WEBINAR | Change Detection, Decoded: Beyond the Alert
Join David Brader in Part 2 of "Change Detection, Decoded," where we take the change detection system built in Session 1 and give it a brain. In this hands-on session, we'll layer a Domo AI Agent on top of the existing pipeline. One that doesn't just detect a signal, but understands what it means and recommends what to do…

Magic ETL

Discussion List