Conditional Gateway Tile

sstorm183 · 2025-03-24T14:12:37+00:00

There was an error rendering this rich post.

Greetings,

I would like to propose the addition of a tile that enables early termination of a dataflow without writing to the output dataset when specific conditions are met.

A key use case for this feature would be terminating the dataflow if the input dataset contains zero rows. In such cases, the process should end, and a notification should be sent indicating a failure. This functionality would play a crucial role in our data sanity checks, ensuring data integrity before proceeding further.

Find more posts tagged with

Magic ETL

Submitted and awaiting review from product team

Status: Submitted and awaiting review from product team

Comments

SeanPT

In the past we would setup convoluted triggers where once

Datasets α and β proccessed, Dataflow Γ would run and give us dataset δ and then we would run a logic check on δ to define ε as a trigger for dataflow ζ. Reducing that into a single tile in a Dataflow would be, dare I say it, Magic?

ColemenWilson

A team member of mine reminded me that you can do this using the error function in Magic ETL

sstorm183

https://community-forums.domo.com/main/discussion/comment/101144#Comment_101144

Could you provide a little more info on this. I am not familiar with what you are referring to.

ColemenWilson

https://community-forums.domo.com/main/discussion/55570/is-there-a-reliable-way-to-make-magic-etl-intentionally-fail