This topic describes the features on the DataStudio page.

Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. Find the workspace that you want to manage and click Data Analytics in the Actions column. On the DataStudio page, you can create different types of nodes.

DataWorks provides a different configuration tab for each type of node. For more information about how to create a node, see Node types.

Left-side navigation pane

On the DataStudio page, click the More icon in the lower-left corner to show or hide the names of tabs in the left-side navigation pane. Left-side navigation pane
Feature Description
Data Analytics On the Data Analytics tab, you can create solutions and workflows. For more information, see DataStudio.
Manually Triggered Workflows Nodes that are created on the Manually Triggered Workflows tab cannot be automatically run by DataWorks. These nodes must be manually triggered. For more information, see Manage manually triggered workflows.
Operating history On the Operating history tab, you can view the records of all the nodes that are run within the last three days. For more information, see Runtime logs.
Ad Hoc Query On the Ad Hoc Query tab, you can run ad hoc queries to test your code in the development environment. You can check for errors and check whether your code works as expected. For more information, see Create an ad hoc query.
Tenant Tables Tenant tables are tables that are committed to the production environment. For more information, see View tenant tables.
Workspace Tables On the Workspace Tables tab, you can create, commit, and search for tables. For more information, see Manage tables.
Built-In Functions On the Built-In Functions tab, you can view all the available built-in functions by category. You can also view instructions and examples for each function. For more information, see Functions.
Recycle Bin On the Recycle Bin tab, you can restore or delete nodes. For more information, see Recycle bin.
Snippets On the Snippets tab, you can create and use script templates. For more information, see Script template management.

Toolbar

Toolbar
No. Feature Description
1 Show My Nodes Only Click the icon to view your nodes in the current workspace.
2 Search Code Click the icon to search for the code of a node or a code segment.
3 Create Move the pointer over the icon to create a solution, workflow, folder, node, table, resource, or function.
4 Refresh Click the icon to refresh the Data Analytics pane.
5 Locate Click the icon to highlight the current node in the Data Analytics pane.
6 Import Click the icon to import data from your on-premises machine to an online table. You must specify the encoding format.
Note In a workspace in standard mode, the data is imported to a table in the development environment.
7 Filter Click the Filter icon and set parameters such as Display Mode, Filter, and Node Type. Filter

Business Flow section

A workflow consists of various modules, such as Data Integration, MaxCompute, E-MapReduce (EMR), and General. For more information about how to create a workflow, see Manage workflows. Business Flow
Feature Description
Data Integration Displays data sync nodes. For more information, see Data Integration.
MaxCompute Displays MaxCompute compute engine instances. All the MaxCompute compute engine instances are displayed.
Note After you associate a MaxCompute compute engine instance with the current workspace, the MaxCompute module appears in the Business Flow section.
EMR Displays EMR compute engine instances. All the EMR compute engine instances are displayed.
Note After you associate an EMR compute engine instance with the current workspace, the EMR module appears in the Business Flow section.
General Displays the general nodes that are used to manage the logic of workflows. The nodes include zero load nodes and control nodes.
Double-click a workflow. The configuration tab of the workflow appears on the right side. Business Flow
No. Feature Description
1 Submit Click the icon to commit the workflow. For more information, see Commit a workflow.
2 Run Click the icon to run the workflow.
3 Stop Click the icon to stop the workflow.
4 Go to Operation Center Click the icon to go to the Cycle Instance page in Operation Center.
5 Box Click the icon and drag-select the nodes that you want to add to a node group.
6 Refresh Click the icon to refresh the workflow.
7 Adapt Click the icon to automatically arrange the layout of the workflow.
8 Zoom In Click the icon to zoom in the nodes in the workflow.
9 Zoom Out Click the icon to zoom out the nodes in the workflow.
10 Search Click the icon and enter a keyword to search for nodes.
11 Toggle Full Screen View Click the icon to view the current workflow in full screen.
12 Hide Engine Information Click the icon to show or hide the engine information of each node.
13 Workflow Parameters Click the tab and assign a value to a variable or replace the value of a parameter for all the nodes in the workflow.
14 Change History Click the tab and view the operation records of the workflow.
15 Versions Click the tab and view all the committed and deployed versions of the workflow.

Shortcut menu of a node

Move the pointer over a node and right-click the node. The shortcut menu of the node appears.

Shortcut menu
No. Feature Description
1 Open Node Click Open Node to go to the configuration tab of the node.
2 View Lineage Click View Lineage to view the lineage of the node.
3 Run Current Node Click Run Current Node to run the node.
4 Run Current Node and Its Descendant Nodes Click Run Current Node and Its Descendant Nodes to run the node and its descendant nodes.
5 Run Till Current Node Click Run Till Current Node to run the node and its ancestor nodes.
6 View Log Click View Log to view the logs of the node.
7 Steal Lock If you are not the owner of a node but want to unlock and edit the node, click Steal Lock.
8 Rename Click Rename to change the name of the node.
9 Clone Click Clone to clone the node. The new node is of the same type and has the same owner and resource properties as the original node but has a different name from the original node.
10 Move Click Move to move the node to another workflow.
11 Delete Node Click Delete Node to delete the node and the dependency configurations of its ancestor and descendant nodes.
12 View Versions Click View Versions to view the historical modification records of the node. The records include versions, the users who commit modifications, the time when the users commit modifications, modification types, and statuses.
13 Locate in Operation Center Click Locate in Operation Center to go to Operation Center and view information about the node.
14 New Node Group Click New Node Group to create a node group and add the nodes that are frequently used to the node group. The configurations of the nodes remain unchanged and can be directly reused.

Configuration tab of an ODPS SQL node

Double-click an ODPS SQL node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create an ODPS SQL node, see Create an ODPS SQL node. ODPS SQL
No. Feature Description
1 Save Click the icon to save the code of the node.
2 Save as Ad-Hoc Query Node Click the icon to save the code as an ad hoc query. Then, you can view the ad hoc query on the Ad Hoc Query tab.
3 Submit Click the icon to commit the node.
4 Commit and Unlock Commit the current node and allow other users to modify the code of the node.
5 Steal Lock If you are not the owner of the node but want to edit the node, click the icon.
6 Estimate Cost Click the icon and select a data timestamp to estimate the cost that is required to run the node.
Note
  • If your workspace uses the pay-as-you-go billing method, you are charged each time you run the node. Proceed with caution. If the estimated cost is less than CNY 0.01, the system still displays a cost of CNY 0.01. Check your bill for the actual cost.
  • If no resource group for scheduling is specified for the node, the system prompts you to select a resource group for scheduling after you click this icon.
7 Run Click the icon to run the code of the node. Values need to be assigned to the variables in the code only once. If you modify the code, the variables in the code use the initial values that you assign.
Note If no resource group for scheduling is specified for the node, the system prompts you to select a resource group for scheduling after you click this icon.
8 Run with Parameters Click the icon to run the code of the node based on the configured parameters. You must manually assign values to variables in SQL statements each time. The system automatically obtains the initial values when you click the Run with Parameters icon. After you assign values to custom parameters, the system replaces the initial values with the assigned values.

For example, if the data timestamp is set to April 2, the data timestamp remains unchanged each time you run the node. After you click the Run with Parameters icon, set the data timestamp to April 3, and then run the node. The data timestamp is changed to April 3 the next time you run the node.

Note If no resource group for scheduling is specified for the node, the system prompts you to select a resource group for scheduling after you click this icon.
9 Stop Click the icon to stop the node.
10 Reload Click the icon to refresh the page and return to the last saved page.
11 Perform Smoke Testing in Development Environment Click the icon to test the code of the node in the development environment. Smoke testing in the development environment allows you to simulate the scheduling parameters on the right side. After you select a data timestamp, the system replaces the values in the specified data timestamp with the values that you specified. This feature checks the effect of value replacement for scheduling parameters.
Note Each time you modify the scheduling parameters, you must save and commit the modification before you perform smoke testing in the development environment. Otherwise, the new values of scheduling parameters do not take effect.
12 View Log of Smoke Testing in Development Environment Click the icon to view the operational logs of the node that runs in the development environment.
13 Access Scheduling System in Development Environment Click the icon to go to Operation Center in the development environment.
14 Format Code Click the icon to sort the code of the node. This prevents code in a single line from being excessively long.
15 Deploy Click the button to deploy the committed code to the production environment. For more information, see Deploy nodes.
16 Operation Center Click the button to go to Operation Center in the production environment. For more information, see Overview.
17 Properties Click the tab and configure properties for the node, such as the time properties, parameters, and resource group. For more information, see Scheduling configuration.
18 Lineage Click the tab and view the relationships between the code and other tables. For more information, see Lineage.
19 Versions Click the tab and view all the committed and deployed versions of the node. For more information, see Versions.
20 Code Structure Click the tab and view the code structure of the node. If the code is excessively long, you can use the key information in the structure to find a code segment. For more information, see Code Structure.

Configuration tab of an SQL Snippet node

Double-click an SQL Snippet node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create an SQL Snippet node, see Create an SQL component node. ODPS SQL Snippet node
No. Feature Description
1 Save Click the icon to save the settings of the node.
2 Submit If you use a workspace in basic mode, the system commits the node to the production environment after you click the Submit icon.

If you use a workspace in standard mode, the system commits the node to the development environment after you click the Submit icon.

3 Commit and Unlock Commit the current node and allow other users to modify the code of the node.
4 Steal Lock If you are not the owner of the node but want to edit the node, click the icon.
5 Run Click the icon to run the node in the development environment.
6 Run with Parameters Click the icon to run the code of the node by using the configured parameters.
7 Stop Click the icon to stop the node.
8 Reload Click the icon to refresh the page and return to the last saved page.
9 Perform Smoke Testing in Development Environment Click the icon to test the code of the node.
10 View Log of Smoke Testing in Development Environment Click the icon to view the operational logs of the node.
11 Access Scheduling System in Development Environment Click the icon to go to Operation Center and view information about the node.
12 Parameters Click the tab and configure parameters for the node.
13 Properties Click the tab and configure properties for the node, such as the time properties, parameters, and resource group. For more information, see Scheduling configuration.
14 Lineage Click the tab and view the relationships between the code and other tables. For more information, see Lineage.
15 Versions Click the tab and view all the committed and deployed versions of the node. For more information, see Versions.

Configuration tab of an ODPS Spark node

Double-click an ODPS Spark node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create an ODPS Spark node, see Create a MaxCompute Spark node.

On the configuration tab of the ODPS Spark node, you can perform a variety of operations. For example, you can save and commit the node. For more information, see Configuration tab of an ODPS SQL node.

Configuration tab of a PyODPS node

Double-click a PyODPS node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create a PyODPS node, see Create a PyODPS 2 node and Create a PyODPS 3 node.

On the configuration tab of the PyODPS node, you can perform a variety of operations. For example, you can save and commit the node. For more information, see Configuration tab of an ODPS SQL node.

Configuration tab of an ODPS Script node

Double-click an ODPS Script node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create an ODPS Script node, see Create an ODPS Script node.

On the configuration tab of the ODPS Script node, you can perform a variety of operations. For example, you can save and commit the node. For more information, see Configuration tab of an ODPS SQL node.

Configuration tab of an ODPS MR node

Double-click an ODPS MR node in a workflow. The configuration tab of the node appears on the right side. For more information about how to create an ODPS MR node, see Create an ODPS MR node.

On the configuration tab of an ODPS MR node, you can perform a variety of operations. For example, you can save and commit the node. For more information, see Configuration tab of an ODPS SQL node.