You can design a workflow to arrange nodes to be run during data analytics. This topic describes how to design a workflow in which each node corresponds to a table at a data warehouse layer.

Procedure

  1. Go to the DataStudio page. On the Data Analytics tab, double-click the Workshop workflow. The canvas for editing the workflow appears on the right.
  2. Drag Zero-Load Node to the canvas. In the Create Node dialog box that appears, set Node Name to start and click Commit.
  3. Drag ODPS SQL to the canvas. In the Create Node dialog box that appears, set Node Name to ods_user_trace_log and click Commit. Use the same method to create another two nodes and name them dw_user_trace_log and rpt_user_trace_log, respectively.
    Note The ods_user_trace_log, dw_user_trace_log, and rpt_user_trace_log nodes represent the operational data store (ODS), common data model (CDM), and application data store (ADS) layers of a data warehouse, respectively. For more information, see Divide a data warehouse into layers.