The Data Warehouse Development feature of Data Management (DMS) allows you to manage projects by workspace, business scenario, and task flow. Management by layers is also supported for you to manage a project in a specific business scenario with ease. The Data Warehouse Development feature can meet a wide range of requirements for data warehouse development and management. A workspace is a basic unit for the development, management, and O&M of a data warehouse. This topic describes how to create a workspace and perform related operations.
- An instance of AnalyticDB for MySQL V3.0 or AnalyticDB for PostgreSQL is created.
- The instance is registered with DMS. For more information, see Register an ApsaraDB instance.
- A test database and an online database are created in the instance. For more information,
see Manage databases.
Note To ensure the stability of online databases, the Data Warehouse Development feature allows you to use a test database and an online database in the workspace. The test environment is isolated from the online environment. You can develop and debug task flows in the test database and publish the task flows to the online database for scheduling.
- The user is granted the owner permissions on the test and online databases. For more information about how to apply for the owner permissions, see Apply for permissions.
- Go to the DMS console V5.0.
- In the top navigation bar, click DTS. In the left-side navigation pane, choose .
- Click Create Workspace.
- In the Create Workspace dialog box, set the parameters described in the following table as required.
Section Parameter Description Basic Information Workspace The name of the workspace. Specify a descriptive name for easy identification.Note You can name the workspace based on the need for Online Analytical Processing (OLAP), warehouse data, or business scenario. Mode
- Simple mode: not available. The test environment is not isolated from the online environment. The test database is the same as the online database.
- Standard mode: selected by default. The test environment is isolated from the online environment. You can develop and debug task flows in the test database and publish the task flows to the online database for scheduling.
Description The description of the workspace. Enter an informative description for easy identification. Data warehouse engine Data warehouse engine The engine of the test and online databases. Valid values:
- AnalyticDB for MySQL 3.0
- AnalyticDB for PostgreSQL
Test Database The database that you want to use as the test database. Enter a keyword to search for the database. Online Database The database that you want to use as the online database. Enter a keyword to search for the database. Advanced Settings Security Check Free During Trial Run Support opening and closing operations. If you enable this feature, no security rule-based checks are performed when you test task flows or change table schemas in the test database. O&M Without Approval Support opening and closing operations. If you enable this feature, you can publish a task flow or change table schemas without approval.
- Click OK. The created workspace is displayed in the Workspace section.
In the Workspace section, you can perform the following operations on the workspace:
|Query workspaces by different ranges||In the upper-right corner of the Workspace section, select one of the following options from the drop-down list:
|Go to a workspace||Most operations are performed in workspaces.
A workspace consists of data warehouse solutions and business scenarios. Task flows can be created under a business scenario.
|Manage a workspace||
|Perform O&M operations on a workspace||You can view the dashboard of a workspace, and view and manage data warehouse task flows and tasks.|