Obtaining Model Statistics

Updated on 2022-09-15 GMT+08:00

View PDF

Function

This API is used to obtain model statistics.

URI

GET /v2/{project_id}/design/table-models/statistic

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID

**Table 2** Query Parameters
Parameter	Mandatory	Type	Description
model_id	No	Long	Model ID used to query the workspace

Request Parameters

None

Response Parameters

Status code: 200

**Table 3** Response body parameters
Parameter	Type	Description
total	StatisticStandardCoverageVO object	Number of logical entities
published	StatisticStandardCoverageVO object	Number of published logical entities
sync_total	SyncStatusStatisticVO object	Overall synchronization status
physical_table	SyncStatusStatisticVO object	Table creation status
technical_asset	SyncStatusStatisticVO object	Technical asset synchronization status
business_asset	SyncStatusStatisticVO object	Logical asset synchronization status
meta_data_link	SyncStatusStatisticVO object	Asset association status
data_quality	SyncStatusStatisticVO object	Quality job status

**Table 4** StatisticStandardCoverageVO
Parameter	Type	Description
all_col_num	Long	Total number of fields
col_num	Long	Number of associated standard fields
coverage	Double	Standard coverage rate
details	Array of AllTableVO objects	Overview table

**Table 5** AllTableVO
Parameter	Type	Description
id	Long	l1 ID
name	String	L1 name
tb_logic_guid	String	GUID of the logical entity corresponding to the published table
quality_id	String	Quality ID
reversed	Boolean	Whether the table is reversed Default: false
partition_conf	String	Partition expression
dirty_out_switch	Boolean	Whether to export dirty data Default: false
dirty_out_database	String	Database to which dirty data will be exported
dirty_out_prefix	String	Prefix of an abnormal table
dirty_out_suffix	String	Suffix of an abnormal table
tb_guid	String	GUID of the physical table corresponding to the published table
code	String	Code
create_by	String	Creator
tenant_id	String	Tenant ID
description	String	Description Maximum: 200
status	String	Business statuses Enumeration values: DRAFT PUBLISH_DEVELOPING PUBLISHED OFFLINE_DEVELOPING OFFLINE REJECT
biz_type	String	Business types Enumeration values: ATOMIC_INDEX DERIVATIVE_INDEX DIMENSION DIMENSION_ATTRIBUTE DIMENSION_HIERARCHIES CONDITION_GROUP TIME_CONDITION COMMON_CONDITION FACT_LOGIC_TABLE TABLE_MODEL DIMENSION_LOGIC_TABLE STANDARD_ELEMENT AGGREGATION_LOGIC_TABLE TAG CODE_TABLE TABLE_MODEL_ATTRIBUTE FACT_DIMENSION FACT_ATTRIBUTE FACT_MEASURE SUMMARY_DIMENSION_ATTRIBUTE SUMMARY_TIME DIMENSION_TABLE_ATTRIBUTE QUALITY_RULE BIZ_METRIC COMPOUND_METRIC INFO_ARCH DEGENERATE_DIMENSION TABLE_MODEL_LOGIC
create_time	String	Creation time
update_time	String	Update time
db_name	String	Database name
dw_type	String	Data connection type
queue_name	String	Queue required for a DLI data connection to execute SQL statements. This parameter is mandatory for DLI data connections.
schema	String	Schema, which is required for DWS
l1	String	Subject area group
l2	String	Subject area
l3	String	Business object
l1_id	Long	Subject area group ID
l2_id	String	Subject area ID
l3_id	Long	Business object ID
new_biz	BizVersionManageVO object	Business version management
physical_table	String	Table creation status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
technical_asset	String	Technical asset synchronization status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
business_asset	String	Logical asset synchronization status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
meta_data_link	String	Asset association status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
data_quality	String	Quality job status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
dlf_task	String	Data development job status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
materialization	String	Storage status of the lookup table value Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
publish_to_dlm	String	DLM API generation status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
summary_status	String	Overall synchronization status Enumeration values: NO_NEED CREATE_SUCCESS CREATE_FAILED UPDATE_SUCCESS UPDATE_FAILED SUMMARY_SUCCESS SUMMARY_FAILED RUNNING OFFLINE
standard_count	Long	Number of standards
alias	String	Alias
api_id	String	Summary table API ID
workspace_id	String	Workspace ID
workspace_name	String	Workspace name

**Table 6** BizVersionManageVO
Parameter	Type	Description
id	Long	ID information
biz_type	String	Business types Enumeration values: ATOMIC_INDEX DERIVATIVE_INDEX DIMENSION DIMENSION_ATTRIBUTE DIMENSION_HIERARCHIES CONDITION_GROUP TIME_CONDITION COMMON_CONDITION FACT_LOGIC_TABLE TABLE_MODEL DIMENSION_LOGIC_TABLE STANDARD_ELEMENT AGGREGATION_LOGIC_TABLE TAG CODE_TABLE TABLE_MODEL_ATTRIBUTE FACT_DIMENSION FACT_ATTRIBUTE FACT_MEASURE SUMMARY_DIMENSION_ATTRIBUTE SUMMARY_TIME DIMENSION_TABLE_ATTRIBUTE QUALITY_RULE BIZ_METRIC COMPOUND_METRIC INFO_ARCH DEGENERATE_DIMENSION TABLE_MODEL_LOGIC
biz_id	Long	Business ID
biz_info	String	Business object information
status	String	Business statuses Enumeration values: DRAFT PUBLISH_DEVELOPING PUBLISHED OFFLINE_DEVELOPING OFFLINE REJECT
biz_version	Integer	Business version
create_time	String	Creation time
update_time	String	Update time

**Table 7** SyncStatusStatisticVO
Parameter	Type	Description
success	Long	Successful
failed	Long	Failed
running	Long	Synchronizing
other	Long	Unsynchronized

Status code: 400

**Table 8** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.000 which indicates that the request was successfully processed.
error_msg	String	Error message
data	Object	Returned data

Status code: 401

**Table 9** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.000 which indicates that the request was successfully processed.
error_msg	String	Error message
data	Object	Returned data

Status code: 403

**Table 10** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.000 which indicates that the request was successfully processed.
error_msg	String	Error message
data	Object	Returned data

Example Requests

None

Example Responses

Status code: 200

The operation succeeds. TableModelStatisticVO is returned.

{
  "total" : {
    "all_col_num" : "2",
    "col_num" : "20",
    "coverage" : 0.15,
    "details" : null
  },
  "published" : {
    "all_col_num" : "2",
    "col_num" : "20",
    "coverage" : 0.15,
    "details" : null
  },
  "sync_total" : {
    "success" : "1",
    "failed" : "1",
    "running" : "0",
    "other" : "0"
  },
  "physical_table" : {
    "success" : "2",
    "failed" : "0",
    "running" : "0",
    "other" : "0"
  },
  "technical_asset" : {
    "success" : "1",
    "failed" : "1",
    "running" : "0",
    "other" : "0"
  },
  "business_asset" : {
    "success" : "2",
    "failed" : "0",
    "running" : "0",
    "other" : "0"
  },
  "meta_data_link" : {
    "success" : "1",
    "failed" : "1",
    "running" : "0",
    "other" : "0"
  },
  "data_quality" : {
    "success" : "2",
    "failed" : "0",
    "running" : "0",
    "other" : "0"
  }
}