Create a summary logical table
Dataphin lets you create an empty summary logical table without derived metrics. You can use this table to register code-developed metrics. This topic describes how to create a summary logical table without derived metrics.
Prerequisites
Before you begin, you must create a dimension logical table for the business object. For more information, see Dimension logical table.
Procedure
In the top navigation bar on the Dataphin homepage, choose Develop > Data Development.
In the top navigation bar, select a project. If you are in Dev-Prod mode, you must also select an environment.
In the left-side navigation pane, choose Standardized Modeling > Summary Logical Table.
On the Summary Logical Table page, click the
icon to open the Create summary logical table dialog box.In the Create summary logical table dialog box, configure the parameters.
Parameter
Description
Time granularity
The time granularity can be Day (T+1), Hour (H+1), or Minute (M+1). The default is Day (T+1).
NoteThe Minute (M+1) option is not supported for Doris and SelectDB compute engines.
Granularity
You can select the business object of any published logical table in the current module.
NoteYou can create only one summary logical table for each granularity.
Table name
The system generates a table name by appending a time suffix (_dd, _hh, or _mm) to the object code of the selected business object, separated by an underscore (_). You can edit this name.
The name can contain letters, digits, and underscores (_). The maximum length of the table name varies by compute engine:
MaxCompute, Hive, StarRocks, SelectDB, and Doris: up to 110 characters.
AnalyticDB for PostgreSQL: up to 50 characters.
Description
Enter a description for the logical table.
Click OK.
Next steps
After creating the summary logical table, you can add derived, composite, or registered metrics.