Using SQL dataflows

SQL dataflows is a tool for those of you who know the SQL scripting language. It enables you to chain multiple sequential SQL commands into a transformation pipeline. Domo datasets are the only supported inputs, and the output is one or more datasets. Let's go through the steps of how to create a SQL dataflow.

Creating a SQL dataflow

Let's walk through a scenario where we must create a SQL dataflow to produce a new aggregated dataset that supports burnup charting:

1. Click on the DATA item in the Domo main menu bar.
2. Click SQL in the MAGIC TRANSFORM area.
3. Enter Opportunity Aggregate in the DataFlow Name & Description box.
4. In the Input DataSets area, click SELECT DATASET.
5. Click Opportunity Cleansed in the Select a Dataset popup.
6. Click the CHOOSE DATASET button.

At this point, the page should look as follows:

Figure 4.13 – SQL dataflow with an input dataset

Let's add the Date...