I am new to MySQL DataFLow in Domo. Can someone explain the difference between Transforms and Output DataSets, and when to use each one?
Thanks for the reply! Would you happen to know of any pages or documents specifically around MySQL dataflow transforms?
Yep, try http://knowledge.domo.com?cid=sqldataflows.
When you have a process that will take multiple steps, each transform takes care of those steps, then you have an output dataset at the end which results in a new dataset in your data center. The transforms are only steps to get you to that final point.
In theory, you could write a query with a bunch of subqueries within it instead of transforms. That's harder to manage and administer, though, so it's not recommended.