The Table Management tab in DataStudio gives workspace administrators centralized control over how tables are named, partitioned, and organized. Consistent conventions let any team member identify a table's type and processing stage from its name alone—without querying the data or asking the table owner.
Configure any of the following from this tab:
-
Partition date formats and partition field names, applied workspace-wide.
-
Name prefixes for temporary tables and import tables, which control how DataWorks parses them.
-
Folders that group tables by use case or data domain.
-
Layers and categories that reflect your data warehouse architecture.
Prerequisites
Before you begin, ensure that you have the Workspace Manager or Workspace Owner role in the target workspace. RAM users without this role cannot modify table settings. To assign the role, see the Add a RAM user to a workspace as a member and assign roles to the member section in the Manage permissions on workspace-level services topic.
Open the Table Management tab
-
Log on to the DataWorks console. In the top navigation bar, select the target region.
-
In the left-side navigation pane, choose Data Development and O\&M > Data Development. Select your workspace from the drop-down list, then click Go to Data Development.
-
On the DataStudio page, open the Table Management tab as shown below.
Configure table formats
Partition formats and table name prefixes apply workspace-wide. DataWorks uses these settings to identify table types during automatic parsing and to validate naming conventions when tables are created.
| Parameter | Description | Default |
|---|---|---|
| Partition date format | Date format for partitioned table columns. | YYYYMMDD |
| Partition field name | Column name used as the partition field. For example, if this is set to dt, a partitioned table uses dt as the partition column and stores values in the format defined by Partition date format. |
Recommended: dt |
| Temporary table prefix | Name prefix for temporary tables. Tables with this prefix are excluded from automatic parsing. | t_ |
| Upload table (Import table) prefix | Name prefix for tables uploaded or imported into DataStudio. | upload_ (example) |
Manage folders
Folders let you group tables by use case, data domain, or team. Organizing tables into folders makes them easier to locate in the Workspace Tables pane.
Create or edit a folder
Create, modify, or delete folders on the Table Management tab. The following figure shows the folder creation form.
Folders support up to two levels of nesting:
-
To create a top-level folder, set Parent Folder to Root Folder (To Create Level 1 Folder).
-
To create a subfolder, select an existing folder as the parent.
Assign a table to a folder
Assign a table to a folder when you create the table. The following table types support folder assignment:
| Table type | How to create |
|---|---|
| MaxCompute | Create and manage MaxCompute tables |
| AnalyticDB for PostgreSQL | Create an AnalyticDB for PostgreSQL table |
| EMR | Create an EMR table |
| Hologres internal table | Create a Hologres internal table |
| Hologres external table | Create a Hologres external table |
After a folder is created, you can search for tables in it from the Workspace Tables pane. For details, see Manage tables.
Manage layers and categories
Layers and categories provide a two-dimensional classification system for tables. Use them together to reflect your data warehouse architecture and business organization—without changing any underlying logic or physical storage.
Layers vs. categories
| Layer | Category | |
|---|---|---|
| Purpose | Maps to a data warehouse processing stage | Groups tables by business domain or function |
| Granularity | Coarse (architectural stage) | Fine (business classification) |
| Typical values | ODS, DIM, DWD, DWS, ADS | Basic business, advanced business, and similar |
| Custom | Yes | Yes |
Use layers to indicate where a table sits in the data flow—for example, whether it holds raw ingested data (ODS) or aggregated metrics for reporting (ADS).
Use categories to further classify tables within a layer by business topic, product line, or other dimension relevant to your team.
Default layers
DataWorks provides the following default layers based on standard data warehouse layering:
| Layer | Full name |
|---|---|
| ODS | Operational data store (ODS) |
| DIM | Dimension (DIM) |
| DWD | Data warehouse detail (DWD) |
| DWS | Data warehouse summary (DWS) |
| ADS | Application data service (ADS) |
You can also create custom layers to match your team's architecture.
Create or edit a layer or category
Create, modify, or delete layers and categories on the Table Management tab.
Assign a table to a layer or category
Assign layers and categories when you create a table. The following table types support this assignment:
| Table type | How to create |
|---|---|
| MaxCompute | Create and manage MaxCompute tables |
| AnalyticDB for PostgreSQL | Create an AnalyticDB for PostgreSQL table |
| EMR | Create an EMR table |
| Hologres internal table | Create a Hologres internal table |
| Hologres external table | Create a Hologres external table |