You can manage settings such as partition formats, identifiers of partition fields, table name prefixes, and folders, levels, and categories for tables on the Table Management tab of the DataStudio page.

Limits

Only a workspace administrator can create folders and classify tables into different categories by attribute such as purpose or name. Before you can create a folder, you must obtain the permissions of a workspace administrator. For more information, see Manage roles and permissions.

Go to the Table Management tab

  1. Log on to the DataWorks console. In the left-side navigation pane, click Workspaces. Select the region where your workspace resides.
  2. Find your workspace on the Workspaces page and click Data Development in the Actions column to go to the DataStudio page.
  3. In the left-side navigation pane of the DataStudio page, click the Settings icon to go to the Settings page.
  4. On the Settings page, click the Table Management tab.
    On the Table Management tab, you can perform the following operations: After the desired operations are complete, click Save configuration.

Configure basic attributes for tables

You can configure partition formats, identifiers of partition fields, and table name prefixes on the Table Management tab. Configure basic attributes for tables
Parameter Description
Partition Date Format The date format of a partitioned table. Default value: YYYYMMDD.
Partition Field Name The identifier of a partition field. We recommend that you set this parameter to dt.
Temporary Table Prefix The prefix for the name of a temporary table. Default value: t_.
Upload Table (Import Table) Prefix The prefix for the name of a table that is uploaded to DataStudio. Example: upload_.

Create or manage a folder for tables

Tables that you create in a workspace are displayed in the Workspace Tables pane of the DataStudio page. You can select a folder level when you create a table. Then, the table is stored in the folder at the specified level after the table is committed and deployed. Folders are used to store tables. Create a folderYou can enter a folder name in the Folder field on the Table Management tab and click Create to create a folder. You can also click Change or Delete in the Actions column that corresponds to a folder to modify or delete the folder.

Create or manage a level or category for tables

The level management feature allows you to design physical levels for tables. Table levels are used to define and manage the layers of data warehouses. In most cases, we recommend that you divide a data warehouse into various layers, such as the operational data store (ODS) layer, data warehouse detail (DWD) layer, data warehouse summary (DWS) layer, and application data service (ADS) layer. For more information, see Create a data layer. Table categories allow you to categorize tables in a finer-grained manner from the business dimension.
Note After a workspace is created, the system does not provide default levels for tables. You must create levels for tables as a project owner or workspace administrator based on your business requirements.
Create or manage a  level or  category for tables
  • Table Levels: used to define the levels to which tables belong. You can create, modify, or delete a level based on your business requirements.
    • Create a level: Enter a level name in the Level field, enter a description for the level in the Description field, and then click Create.
    • Modify or delete a level: Find the desired level and click Change or Delete in the Actions column.
  • Table Categories: used to define the categories to which tables belong. You can create, modify, or delete a category based on your business requirements.
    • Create a category: Enter a category name in the Category field, enter a description for the category in the Description field, and then click Create.
    • Modify or delete a category: Find the desired category and click Change or Delete in the Actions column.