Help Center/ DataArts Studio/ API Reference/ DataArts Architecture APIs/ Summary Tables/ Viewing SDR Table Details

Updated on 2025-11-17 GMT+08:00

View PDF

Viewing SDR Table Details

Function

This API is used to view details about an SDR table by ID.

Calling Method

For details, see Calling APIs.

URI

GET /v2/{project_id}/design/aggregation-logic-tables/{id}

**Table 1** Path Parameters
Parameter	Mandatory	Type	Description
project_id	Yes	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID.
id	Yes	String	Entity ID, which is a string

**Table 2** Query Parameters
Parameter	Mandatory	Type	Description
latest	No	Boolean	Indicates whether to query the latest.

Request Parameters

**Table 3** Request header parameters
Parameter	Mandatory	Type	Description
X-Auth-Token	Yes	String	IAM token, which is obtained by calling the IAM API for obtaining a user token (value of X-Subject-Token in the response header). This field is mandatory for authentication using tokens.
workspace	Yes	String	Workspace ID. For details about how to obtain the workspace ID, see Instance ID and Workspace ID.
X-Project-Id	No	String	Project ID. For details about how to obtain the project ID, see Project ID and Account ID. This parameter is mandatory for API requests that use AK/SK authentication in multi-project scenarios.
Content-Type	No	String	Default value: application/json;charset=UTF-8 This parameter is optional. If the body is available, this parameter is mandatory. If the body is unavailable, you do not need to set this parameter or verify it.

Response Parameters

Status code: 200

**Table 4** Response body parameters
Parameter	Type	Description
data	data object	Returned data.

**Table 5** data
Parameter	Type	Description
value	AggregationLogicTableVO object	Returned data information.

**Table 6** AggregationLogicTableVO
Parameter	Type	Description
id	String	Unique system ID of the summary table, which is a string. This parameter is mandatory when you update an SDR table and is not required when you create an SDR table.
tb_name	String	Specifies the English name of the SDR table, which corresponds to the actual physical table name.
tb_logic_name	String	Chinese name of the summary table, which is used for display.
l1_id	String	Subject area group ID, which is a string. This parameter is read-only and does not need to be set during creation and update.
l2_id	String	Subject area ID. This parameter is read-only and does not need to be set during creation and update.
l3_id	String	ID of the subject to which the summary table belongs, which is a string. This parameter is mandatory.
description	String	Description of the summary table.
owner	String	Asset owner of the summary table.
secret_type	String	Confidentiality type. Options: PUBLIC: public SECRET: secret CONFIDENTIAL: confidential SUPER_SECRET: top secret
apply_bg	String	Applicable to bg.
create_by	String	Creator of the summary table. This parameter is read-only and does not need to be set during creation and update.
queue_name	String	Queue required for executing SQL statements through the DLI data connection. This parameter is mandatory when the data connection type is DLI.
dw_id	String	ID of the data connection where the SDR table is located. The value is a 32-digit hexadecimal number.
db_name	String	Name of the database where the summary table is located.
tb_id	String	Specifies the ID of the table created by the summary table. It is an internal service ID and is read-only. You do not need to set this parameter when creating or updating a table.
schema	String	Specifies the name of the schema where the SDR table is located. This parameter is mandatory for DWS.
dw_name	String	Data connection name. This parameter is read-only and does not need to be set when you create or update a data connection.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
tb_guid	String	GUID of the created data catalog technology asset after the table is released. This parameter is read-only and does not need to be set during creation and update.
tb_logic_guid	String	GUID of the created data catalog service asset after the table is released. This parameter is read-only and does not need to be set during creation and update.
dw_type	String	Data connection type, which corresponds to the type of the data warehouse where the table is located. The value can be DWS, MRS_HIVE, POSTGRESQL, MRS_SPARK, CLICKHOUSE, MYSQL, ORACLE, or DORIS.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
create_time	String	Specifies the creation time. This parameter is read-only and does not need to be set during creation and update.
update_time	String	Specifies the update time. This parameter is read-only and does not need to be set during creation and update.
approval_info	ApprovalVO object	Approval information. This parameter is read-only. Latest review information about a business object, including the business details, reviewer information, and review time.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.
dimension_group	String	Granularity ID.
group_name	String	Granularity name, which is read-only.
group_code	String	Granularity code, which is read-only.
time_period	AggregationLogicTableAttributeVO object	Time period attribute information of the summary table.
table_attributes	Array of AggregationLogicTableAttributeVO objects	Attribute information of the summary table. The type is determined based on attribute_type.
physical_table	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
dev_physical_table	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
technical_asset	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
business_asset	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
meta_data_link	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
data_quality	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
dlf_task	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
publish_to_dlm	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
summary_status	String	Synchronization status. Options: NO_NEED: not synchronized CREATE_SUCCESS: The creation is successful. CREATE_FAILED: Creation failed UPDATE_SUCCESS: The update is successful. UPDATE_FAILED: The update fails. SUMMARY_SUCCESS: overall success SUMMARY_FAILED: overall failure RUNNING: overall running OFFLINE: offline
distribute	String	DISTRIBUTE BY [HASH(column)\|REPLICATION]. Options: HASH: Hashes specified columns and distributes data to specified DNs through mapping. REPLICATION: Each row in the table exists on all DNs, that is, each DN has complete table data.
distribute_column	String	DISTRIBUTE BY HASH column.
compression	String	DWS data compression level. The column compression level is no/low/middle/high, and the row compression level is no/yes. Options: NO: no compression YES: indicates that the file is compressed. LOW: low-level compression MIDDLE: medium-level compression HIGH: high-level compression
obs_location	String	Path of the foreign table.
pre_combine_field	String	Version field.
table_type	String	Table type
dlf_task_id	String	ID of a DLF job.
quality_id	String	Quality ID, which is a string
reversed	Boolean	Indicates whether the operation is reverse. This parameter is read-only.
table_version	Integer	If this parameter is set to 2, the summary table is generated and read-only.
partition_conf	String	Partition expression.
dirty_out_switch	Boolean	Indicates whether to output abnormal data.
dirty_out_database	String	Abnormal data output library.
dirty_out_prefix	String	Prefix of an exception table.
dirty_out_suffix	String	Suffix of an exception table.
alias	String	Alias
configs	String	Other configurations.
self_defined_fields	Array of SelfDefinedFieldVO objects	User-defined item.
api_id	String	API ID
sql	String	SQL statement bound to the SDR table.
dev_version	String	Development environment version, which is a read-only string
prod_version	String	Production environment version, which is a read-only string
dev_version_name	String	Version name of the development environment, which is read-only
prod_version_name	String	Version name of the production environment, which is read-only
env_type	String	Type of the development and production environment. Options: INVALID_TYPE: invalid environment DEV_TYPE: development environment PROD_TYPE: production environment DEV_PROD_TYPE: development and production environment
model_id	String	Model ID, which is a string
model	WorkspaceVO object	Model information

**Table 7** ApprovalVO
Parameter	Type	Description
id	String	Application ID, which is a string
tenant_id	String	Project ID. For details about how to obtain the project ID, see the API path parameter project_id.
name_ch	String	Chinese name of a service.
name_en	String	English name of a service.
biz_id	String	Business ID, which is a string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_info	String	Serialized service details. The type is string.
biz_info_obj	Object	Service details. The type is object.
biz_version	Integer	Service version.
biz_status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
approval_status	String	Service approval status. This parameter is read-only. Options: DEVELOPING: being reviewed APPROVED: approved REJECT: rejected WITHDREW: approval cancellation
approval_type	String	Service review type. Options: PUBLISH: released OFFLINE: offline
submit_time	String	Submitted At
create_by	String	Creator.
l1	String	Chinese name of the subject area group. This parameter is read-only and does not need to be set when you create or update a subject area group.
l2	String	Chinese name of the subject area. This parameter is read-only and does not need to be set during creation and update.
l3	String	Chinese name of the business object. This parameter is read-only and does not need to be set during creation and update.
approval_time	String	Review time.
approver	String	Reviewer.
email	String	Email address of the reviewer.
msg	String	Review information.
directory_path	String	Directory tree.

**Table 8** AggregationLogicTableAttributeVO
Parameter	Type	Description
id	String	ID, which is a string
aggregation_logic_table_id	String	ID of the summary table, which is a string
ordinal	Integer	Sequence number.
name_en	String	Field name.
name_ch	String	Service attribute.
attribute_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
is_primary_key	Boolean	Indicates whether a key is a primary key.
is_partition_key	Boolean	Indicates whether the key is a partition key.
secrecy_levels	Array of SecrecyLevelVO objects	Confidentiality
not_null	Boolean	Indicates whether the value is empty.
description	String	Description.
data_type	String	Field type
domain_type	String	Domain to which a field type belongs. Options: NUMBER: number STRING: character type DATETIME: date type BLOB: large object (BLOB) OTHER: other types
data_type_extend	String	Extended field of the data type.
ref_id	String	ID of the object associated with the attribute.
ref_name_ch	String	Chinese name of the object associated with the attribute.
ref_name_en	String	English name of the object associated with the attribute.
stand_row_id	String	ID of the associated data standard, which is a string
stand_row_name	String	Name of the associated data standard. This parameter is read-only.
quality_infos	Array of QualityInfoVO objects	Quality information, which is read-only.
alias	String	Alias

**Table 9** SecrecyLevelVO
Parameter	Type	Description
id	String	Security level ID, which is a string
uuid	String	Data security primary key.
name	String	Confidentiality name.
slevel	Integer	Confidentiality level.
description	String	Confidentiality description.
create_by	String	Creator.
update_by	String	Person who updates the information.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
new_biz	BizVersionManageVO object	Service version management. This parameter is read-only.

**Table 10** BizVersionManageVO
Parameter	Type	Description
id	String	Field ID, which is a string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
biz_id	String	Business ID, which is a string
biz_info	String	Business object information.
status	String	Release status of an entity. This parameter is read-only and does not need to be set during creation and update. Options: DRAFT: draft PUBLISH_DEVELOPING: to be reviewed PUBLISHED: released OFFLINE_DEVELOPING: to be reviewed OFFLINE: offline REJECT: rejected
biz_version	Integer	Service version, which is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.

**Table 11** QualityInfoVO
Parameter	Type	Description
id	String	ID, which is a string
table_id	String	Table ID, which is a read-only string
attr_id	String	Attribute ID, which is a read-only string
biz_type	String	Business entity type. Options: AGGREGATION_LOGIC_TABLE: summary table ATOMIC_INDEX: atomic metric ATOMIC_METRIC: atomic metric (new) BIZ_CATALOG: process architecture directory BIZ_METRIC: service indicator CODE_TABLE: code table COMMON_CONDITION: general filter COMPOSITE_METRIC: Compound Metric (new) COMPOUND_METRIC: compound metric CONDITION_GROUP: restriction group DEGENERATE_DIMENSION: degenerate dimension DERIVATIVE_INDEX: derivative indicator DERIVED_METRIC: derivative indicator (new) DIMENSION: dimension DIMENSION_ATTRIBUTE: dimension attribute DIMENSION_HIERARCHIES: dimension level DIMENSION_LOGIC_TABLE: dimension table DIMENSION_TABLE_ATTRIBUTE: dimension attribute DIRECTORY: directory FACT_ATTRIBUTE: fact table attribute FACT_DIMENSION: fact table dimension FACT_LOGIC_TABLE: fact table FACT_MEASURE: fact table measurement FUNCTION: function INFO_ARCH: information architecture (used for modifying themes in batches) MODEL: model QUALITY_RULE: quality rule SECRECY_LEVEL: security level STANDARD_ELEMENT: data standard STANDARD_ELEMENT_TEMPLATE: data standard template SUBJECT: theme Dimension attributes of SUMMARY_DIMENSION_ATTRIBUTE: summary tables SUMMARY_INDEX: summary table indicator attribute SUMMARY_TIME: time period attribute of the SDR table TABLE_MODEL: relationship model (logical model/physical model) TABLE_MODEL_ATTRIBUTE: relationship model attribute (logical model/physical model) TABLE_MODEL_LOGIC: logical entity TABLE_TYPE: table type TAG: tag TIME_CONDITION: time restriction
data_quality_id	String	Quality ID, which is a string
show_control	Integer	Indicates whether to display the regular expression.
data_quality_name	String	Quality name.
alert_conf	String	Configure alarms.
expression	String	Regular expression configuration in regular expression-related validation rules.
extend_info	String	Indicates the extension information.
from_standard	Boolean	Indicates whether the data comes from the data standard quality configuration. This parameter is read-only.
result_description	String	Result description.
create_by	String	Creator, which is read-only.
update_by	String	Updater, which is read-only.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.

**Table 12** SelfDefinedFieldVO
Parameter	Type	Description
fd_name_ch	String	Chinese name of a user-defined item.
fd_name_en	String	English name of a customized item.
not_null	Boolean	Whether a parameter is mandatory.
fd_value	String	Attribute value

**Table 13** WorkspaceVO
Parameter	Type	Description
id	String	ID, which is a string
name	String	Name of the workspace.
description	String	Description.
is_physical	Boolean	Indicates whether a table is a physical table.
frequent	Boolean	Indicates whether it is commonly used.
top	Boolean	Hierarchical governance.
level	String	Data governance layers. Options: SDI: source data layer DWI: data integration layer DWR: data reporting layer DM: data mart layer
dw_type	String	Data connection type, which corresponds to the type of the data warehouse where the table is located. The value can be DWS, MRS_HIVE, POSTGRESQL, MRS_SPARK, CLICKHOUSE, MYSQL, ORACLE, or DORIS.
create_time	String	Creation time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
update_time	String	Update time, which is read-only. The format complies with RFC3339 and is accurate to seconds. The UTC time zone is yyyy-mm-ddTHH:MM:SSZ, for example, 1970-01-01T00:00:00Z.
create_by	String	Creator.
update_by	String	Person who updates the information.
type	String	Defines the workspace type enumeration. Options: THIRD_NF: relational modeling DIMENSION: dimensional modeling
biz_catalog_ids	String	{"l1Ids":[],"l2Ids":[],"l3Ids":[]}: ID list of associated service catalogs.
databases	Array of strings	Array of database names.
table_model_prefix	String	Model verification prefix. The value contains a maximum of 100 characters, including digits, letters, and underscores (_), and starts with a letter.

Status code: 400

**Table 14** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 401

**Table 15** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Status code: 403

**Table 16** Response body parameters
Parameter	Type	Description
error_code	String	Error code, for example, DS.6000, indicating that the request fails to be processed.
error_msg	String	Error message
data	Object	Returned data information.

Example Requests

This API is used to view details about an SDR table by ID.

GET https://{endpoint}/v2/{project_id}/design/aggregation-logic-tables/1209135365252866070

Example Responses

Status code: 200

This operation succeeds, and the returned data is AggregationLogicTableVO details.

{
  "data" : {
    "value" : {
      "id" : "1209135365252866070",
      "tb_name" : "dws_dim_ssww",
      "tb_logic_name" : "yaqiang",
      "l1_id" : "1180536695448350720",
      "l2_id" : null,
      "l3_id" : null,
      "description" : "Auto converge table.\nDerivative metrics: 1\n\nDimension Group: yaqiang/dim_ssww",
      "owner" : "dgc_user",
      "create_by" : "test_uesr",
      "queue_name" : "default",
      "dw_id" : "8259af52bd294f98920ebce75a426391",
      "db_name" : "default",
      "tb_id" : null,
      "schema" : "",
      "dw_name" : "dws",
      "status" : "PUBLISHED",
      "tb_guid" : "1bc46477-6cf8-42c5-8e49-cabe9e7e50c8",
      "tb_logic_guid" : "c27a4a66-2bb6-4c65-b943-87594d396432",
      "dw_type" : "DWS",
      "l1" : "owner_test",
      "l2" : null,
      "l3" : null,
      "create_time" : "2024-02-19T13:52:16+08:00",
      "update_time" : "2024-04-19T14:21:49+08:00",
      "approval_info" : {
        "id" : "1230885989459886080",
        "tenant_id" : null,
        "name_ch" : null,
        "name_en" : null,
        "biz_id" : "1209135365252866070",
        "biz_type" : null,
        "biz_info" : null,
        "biz_info_obj" : null,
        "biz_version" : 0,
        "biz_status" : "PUBLISHED",
        "approval_status" : "APPROVED",
        "approval_type" : null,
        "submit_time" : "2024-04-19T14:21:29+08:00",
        "create_by" : null,
        "l1" : null,
        "l2" : null,
        "l3" : null,
        "approval_time" : "2024-04-19T14:21:28+08:00",
        "approver" : "test_uesr",
        "email" : null,
        "msg" : "Fast Approval OK.",
        "directory_path" : null
      },
      "new_biz" : null,
      "dimension_group" : "0",
      "group_name" : null,
      "group_code" : null,
      "time_period" : null,
      "table_attributes" : [ {
        "id" : "1209135365252866069",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 1,
        "name_en" : "dws_atmoic",
        "name_ch" : "DWS atomic metric (DWS.hierarchies_1)",
        "attribute_type" : "DERIVATIVE_INDEX",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : null,
        "data_type" : "STRING",
        "domain_type" : "STRING",
        "data_type_extend" : "",
        "ref_id" : "1188156778513338368",
        "ref_name_ch" : "DWS atomic metric (dimension DWS.hierarchies_1)",
        "ref_name_en" : "dws_atmoic",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1209135366414688256",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 2,
        "name_en" : "dim_LI_dim_key",
        "name_ch" : "Dimension DWS_Dimension DWS",
        "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : null,
        "data_type" : "BIGINT",
        "domain_type" : "NUMBER",
        "data_type_extend" : "",
        "ref_id" : "1113507850438758400#1154065454386561024.1114569975517106176",
        "ref_name_ch" : "Dimension DWS.Dimension DWS",
        "ref_name_en" : "dim_LI.dim_key",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1209135366414688257",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 3,
        "name_en" : "dim_LI_li",
        "name_ch" : "Dimension DWS_li",
        "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : true,
        "secrecy_levels" : [ ],
        "description" : null,
        "data_type" : "BIGINT",
        "domain_type" : "NUMBER",
        "data_type_extend" : "",
        "ref_id" : "1113507850438758400#1154065454386561024.1114569975517106177",
        "ref_name_ch" : "Dimension DWS.li",
        "ref_name_en" : "dim_LI.li",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1230885274481991680",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 4,
        "name_en" : "order_count",
        "name_ch" : "Number of Orders",
        "attribute_type" : "DERIVATIVE_INDEX",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : "STRING",
        "data_type_extend" : "",
        "ref_id" : "1223668870544605184",
        "ref_name_ch" : "Number of Orders",
        "ref_name_en" : "order_count",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1230885756508184576",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 5,
        "name_en" : "xxx7",
        "name_ch" : "xxx2",
        "attribute_type" : "DERIVED_METRIC",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : "STRING",
        "data_type_extend" : "",
        "ref_id" : "1169727308433653760",
        "ref_name_ch" : "xxx2",
        "ref_name_en" : "xxx7",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1230885835012972544",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 6,
        "name_en" : "cdm_mysql_string_auto_col_char",
        "name_ch" : "cdm_mysql_string_auto_col_char",
        "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : "STRING",
        "data_type_extend" : "",
        "ref_id" : "raw#cdm_mysql_string_auto.col_char",
        "ref_name_ch" : "cdm_mysql_string_auto.col_char",
        "ref_name_en" : "cdm_mysql_string_auto.col_char",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      }, {
        "id" : "1230885835012972545",
        "aggregation_logic_table_id" : "1209135365252866070",
        "ordinal" : 7,
        "name_en" : "cdm_mysql_string_auto_col_varchar",
        "name_ch" : "cdm_mysql_string_auto_col_varchar",
        "attribute_type" : "SUMMARY_DIMENSION_ATTRIBUTE",
        "is_primary_key" : false,
        "is_partition_key" : false,
        "not_null" : false,
        "secrecy_levels" : [ ],
        "description" : "",
        "data_type" : "STRING",
        "domain_type" : "STRING",
        "data_type_extend" : "",
        "ref_id" : "raw#cdm_mysql_string_auto.col_varchar",
        "ref_name_ch" : "cdm_mysql_string_auto.col_varchar",
        "ref_name_en" : "cdm_mysql_string_auto.col_varchar",
        "stand_row_id" : null,
        "stand_row_name" : null,
        "quality_infos" : [ ],
        "alias" : null
      } ],
      "physical_table" : "NO_NEED",
      "dev_physical_table" : "NO_NEED",
      "technical_asset" : "CREATE_SUCCESS",
      "business_asset" : "CREATE_SUCCESS",
      "meta_data_link" : "UPDATE_SUCCESS",
      "data_quality" : "UPDATE_SUCCESS",
      "dlf_task" : "UPDATE_SUCCESS",
      "publish_to_dlm" : "CREATE_FAILED",
      "summary_status" : "SUMMARY_FAILED",
      "distribute" : null,
      "distribute_column" : null,
      "compression" : null,
      "obs_location" : null,
      "pre_combine_field" : null,
      "table_type" : "MANAGED",
      "dlf_task_id" : "default_dws_dim_ssww_1209135365252866070",
      "quality_id" : "1230886041247125505",
      "reversed" : null,
      "table_version" : 0,
      "partition_conf" : null,
      "dirty_out_switch" : true,
      "dirty_out_database" : "bi",
      "dirty_out_prefix" : "dd1",
      "dirty_out_suffix" : "dd2",
      "alias" : null,
      "configs" : "{}",
      "self_defined_fields" : [ {
        "fd_name_ch" : "aaa",
        "fd_name_en" : "aaa",
        "not_null" : false,
        "fd_value" : "aaa"
      } ],
      "api_id" : null,
      "dev_version" : null,
      "prod_version" : null,
      "dev_version_name" : null,
      "prod_version_name" : null,
      "env_type" : "PROD_TYPE",
      "sql" : ""
    }
  }
}

Status code: 400

BadRequest

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user request is illegal."
}

Status code: 401

Unauthorized

{
  "error_code" : "DS.60xx",
  "error_msg" : "User authentication failed."
}

Status code: 403

Forbidden

{
  "error_code" : "DS.60xx",
  "error_msg" : "The user does not have permission to call this API."
}

Status Codes

Status Code	Description
200	This operation succeeds, and the returned data is AggregationLogicTableVO details.
400	BadRequest
401	Unauthorized
403	Forbidden

Parent Topic: Summary Tables

Previous topic: Deleting Summary Tables

Next topic: Business Metrics

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel