If your data system involves multiple workspaces and you want to use the same data warehouse plan for these workspaces, you can use the modeling workspace feature. This feature allows you to plan data warehouses, perform dimensional modeling, and define metrics for the workspaces in a unified manner. This topic describes the use scenarios of the modeling workspace feature. This topic also describes how to associate a data development workspace with and disassociate a data development workspace from a model design workspace.
Background information
DataWorks Data Modeling provides the following types of workspaces when you use the modeling workspace feature: model design workspace and data development workspace.
Model design workspace: The current workspace that you access serves as the model design workspace. Model designers design and manage models in this workspace. These models will be published to the data development workspaces that are associated with this workspace. The models can be aggregate tables, dimension tables, or fact tables.
Data development workspace: Data development engineers perform extract, transform, load (ETL) operations based on model design results in data development workspaces.
Before you use the modeling workspace feature, take note of the following points:
In the preceding figure, a model designer designs a model (Model 1) in the Project_1 workspace and publishes the model to the Project_2 and Project_3 workspaces. If the model needs to be modified, the model designer can modify the model only in the Project_1 workspace. The model designer cannot view and modify the model in the Project_2 and Project_3 workspaces.
The Project_1 workspace is used as the model design workspace, and the model designer can choose whether to publish the model to the Project_1 workspace. If the model designer chooses to publish the model to the Project_1 workspace, the Project_1 workspace is also used as a data development workspace. The Project_2 and Project_3 workspaces are used as data development workspaces and cannot be used as model design workspaces.
Precautions
When you associate data development workspaces with a model design workspace, take note of the following point:
You can select only the workspaces on which you are granted the administrator permissions. You cannot select the workspaces that are already used as data development workspaces.
When you disassociate data development workspaces from a model design workspace, take note of the following point:
You can select only the workspaces on which you are granted the administrator permissions.
Procedure
This section describes how to associate a data development workspace with and disassociate a data development workspace from a model design workspace.
Go to the Data Layer 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 navigation bar of the Data Modeling page, click Data Warehouse Planning. The Data Layer page appears.
In the left-side navigation pane, click Workspace for Data Modeling.
In the Data Model Workspace Configuration section of the Workspace for Data Modeling page, view the data development workspaces that are associated with the model design workspace. Then, click Modify Configuration to add or remove a data development workspace.
NoteAfter you click Modify Configuration, you can add or remove only the workspaces on which you are granted the administrator permissions.
Select the workspace to which you want to publish a model from the Workspace for Data Development drop-down list, click OK, and then click Submit to use the workspace as a data development workspace.
Click Delete in the Actions column of a workspace that is used as a data development workspace and click Submit to remove the workspace from the list of data development workspaces.
After the modification is complete, view the change records in the Change Records section of the Workspace for Data Modeling page.
What to do next
When you publish a model, you must select a data development workspace based on your business requirements. For more information, see Materialize a table to a compute engine.