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
  • 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

  1. Go to the DMS console V5.0.
  2. In the top navigation bar, click DTS. In the left-side navigation pane, choose Data Development > Data Warehouse Development.
  3. Click Create Workspace.
  4. 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.
  5. Click OK.
    The created workspace is displayed in the Workspace section.

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:
  • Current Role: This option is selected by default. If this option is selected, DMS displays the workspaces of which you are a member.
  • Current Tenant: If this option is selected, DMS displays all the workspaces within the current tenant.
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
  • You can view the basic information and data warehouse engine of the workspace.

    Click Edit in the upper-right corner to modify the information.

  • Workspace Members: You can view workspace members and their permissions. For more information about permissions, see Manage permissions on a workspace.

    On the Workspace Members tab, you can add or remove workspace members.

  • Themes: You can view themes that are used to identify and classify tables in task flows for data warehouse development.

    On the Themes tab, you can create, modify, or delete a workspace theme.

  • Layers: You can view layers that are used to identify and classify tables in data warehouse task flows.

    On the Layers tab, you can create, modify, or delete a workspace layer.

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.