Introducing the sculpting tools for persistent datasets
In Domo, the sculpting tools are called Magic because they make it simple to transform data. The tools allow you to create dataflows that output new persistent datasets – ones that are stored on physical media. Let's look at the data transformation tools that are available for creating persistent datasets:
- Extract, Transform, and Load (ETL) dataflows establish a sequence of operations through a visual programming interface that takes input datasets and performs transformations when executed that create and/or update output datasets.
- SQL dataflows use SQL commands and sequence them together into a dataflow that, when executed, reads the input datasets, transforms the data according to the SQL commands, and outputs datasets.
The following table contains guidance for when to use which tool:
Figure 4.1 – Magic transform persistent tools guidance