The model list in DataWorks lets you manage all your created models in one place. On this page, you can view models that meet specific criteria and perform batch operations on them. This topic describes how to view the model list and perform batch modifications on models.
Limits
Model lifecycles can be modified only in batches.
View and filter models
Go to the Models page.
Log on to the DataWorks console. In the top navigation bar, select the desired region. In the left-side navigation pane, choose . On the page that appears, select the desired workspace from the drop-down list and click Go to Data Modeling.
In the top menu bar of the Data Modeling page, click Dimensional Modeling.
On the Dimensional Modeling page, click the
icon to go to the Models page.
Filter or search for models. At the top of the list, you can filter models by criteria such as Model Name and Data Layer. Fuzzy search is supported for model names.
Manage a single model
On the Model List page, you can create, clone, view, and delete a single model.
Operation
Description
Create
Create a data model.
Clone
Copy an existing model. You can also right-click a target model in the directory tree on the left and select Clone to perform the same operation.
View
Go to the model details page to view or edit the model.
Delete
Delete the target model. Before you delete a model that has an association, you must remove the association.
ImportantA deleted model cannot be recovered.
Batch modify models
You can modify multiple models in a batch operation.
On the Models page, select one or more models to modify.
Click Batch Modify at the bottom of the list.
In the dialog box that appears, modify the model information. Currently, you can perform batch modifications only on the Lifecycle and Owner of the models.
Manage a model on its details page
After you create a dimension table, fact table, aggregate table, or application table, you can double-click the model name in the left-side directory tree to view the details of the model. On the details page, you can edit, publish, and develop the model.
Edit the model: On the details page, you can modify the basic information and fields of the current table. After you finish editing, click Save to apply the changes.
NoteAfter you modify the table information, you must publish and materialize the table to the engine. You can then use the updated table for subsequent data development.
Refresh model information: Click Refresh to retrieve the latest table information.
Configure model associations: Click Association to create or modify the associations of the current model.
Submit the model: When you submit a model, a new version is generated. The content of the new version overwrites the existing content.
Publish the model: Click Publish to publish and materialize the table to the engine. Data Quality rules are automatically generated. For more information, see Materialize a logical model.
View model publish logs: Click View Logs to view the details of the model's publish log.
Generate Data Quality rules for the model: After the model is published to the production environment, click Data Quality Rule to go to the page of the generated Data Quality rules. You can then use these rules to monitor the data quality of the model in the production environment.
Generate a code framework for the model: After the model is published, click Develop Model to generate a code framework. This helps improve the efficiency of your data development. For more information, see Generate an ETL code framework (Develop Model).
Export code statements for the model: Click Export to convert the model information into DDL or ETL statements for the corresponding engine. You can then copy the statements or export them as a code file.
Version comparison
Each time you submit a model, a new version is generated. In the right-side navigation pane of the model editing page, you can view all version information of the model. You can also perform the following operations:
Version Comparison
You can compare the content differences between selected versions. If you select only one version, it is compared with the currently saved model content. You can select a maximum of two versions for comparison.
Roll Back
You can switch to a desired model version. After you switch, the content on the model editing page is overwritten by the content of the target version.
NoteThe rollback operation updates only the UI configuration to the selected version.