Using DataFlow, what is the difference between adding Transforms and adding Output DataSets?

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!

Best Answers

Answers

  • Hi!

    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.