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.
Prerequisites
- An instance of AnalyticDB for MySQL V3.0 or AnalyticDB for PostgreSQL is created.
Note
- For more information about how to create an AnalyticDB for MySQL V3.0 instance, see Create a cluster.
- For more information about how to create an AnalyticDB for PostgreSQL instance, see Create an AnalyticDB for PostgreSQL instance.
- 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.
Procedure
Supported operations
In the Workspace section, you can perform the following operations on the workspace:
Operation | Description |
---|---|
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. |