概述
资产搜索可以搜索出当前用户有权限+可见的资产，可以根据表名、字段名或者表描述信息进行模糊搜索，根据数据类目，标签，数据空间，数据源过滤，
接口URL
请求参数
3.1公共请求参数(HEADERS)
| 参数 | 必选 | 描述 | 类型 | 最大长度 |
|---|---|---|---|---|
| tenant-id | 是 | 租户ID，需要根据租户id查询对应的集群id |
String | 32 |
| auth-type | 是 | 固定值，用于设置身份认证方式UID：使用 UID 进行身份认证TOKEN：使用 TOKEN 进行身份认证 |
String | 32 |
| auth-value | 是 | 与 auth-type 类型的选择一致，填入相应值 | String | 32 |
| query-user-account | 否 | 用户名，使用该用户身份查询数据 |
String | 32 |
3.2请求参数
| 参数 | 必选 | 描述 | 类型 |
|---|---|---|---|
| search | 否 | 表的关键字，或表的描述信息关键字，或字段关键字 |
String |
| categoryIds | 否 | 类目的id集合，用户在哪个分类下，分类可能是有多层级的，因此传分类集合['父类名id','子类目id'] |
Array |
| tagIds | 否 | 标签的id集合，表示想查找带有此标签id的资产。 |
Array |
| catalogNames | 否 | 数据空间或数据源名称集合，表示想查找数据空间或数据源下的资产 |
Array |
| tableType | 否 | 表的类型，tableType=VIEW表示搜索逻辑视图，tableType=TABLE表示搜索的是基础视图，没有携带表示搜索所有的视图。 |
String |
| pageNumber | 否 | 分页参数中的第几页，如果不传默认表示第一页 |
Integer |
| pageSize | 否 | 分页参数中的每页大小, 默认是30 |
Integer |
响应参数
| 参数 | 必选 | 描述 | 示例值 | 类型 | 最大长度 |
|---|---|---|---|---|---|
| errorCode | 是 | 错误码 | DWS01002 | String | 32 |
| errorMessage | 否 | 错误信息 | 用户不存在 | String | 512 |
| traceId | 是 | traceId | 343f9ff2dcd7642861 | String | 128 |
| data | 是 | 查询返回的数据内容 | 见 4.1data 表 |
4.1 data表
| 参数 | 必选 | 描述 | 示例值 | 类型 |
|---|---|---|---|---|
| hasNextPage | 是 | 是否有下一页true: 有下一页false: 没有下一页 | true | Boolean |
| pageNumber | 是 | 表示当前第几页 | 1 | Integer |
| pageSize | 是 | 表示每页大小 | 30 | Integer |
| total | 是 | 表示搜索结果的总数量 | 20 | Integer |
| dataList | 否 | 搜索返回结果 | 详解4.2dataList | Array |
4.2 dataList搜索返回结果
[{
"catalogName":"mysql",
"categoryPath":["销售","华中区"], // 在哪个分类下
"description": "表的描述信息",
"datasourceType":"MYSQL", // 当前表在哪个数据源下，如果是逻辑视图则没有
"owner": "Aloudata", // 表的负责人
"tableName": "call_center",
"tableType":"VIEW" // 视图类型，VIEW:逻辑视图 TABLE:基础视图
"guid": "\"mysql\".\"tpcds\".\"call_center\"", // 资产的路径字符串形式
"path": ["mysql", "tpcds", "call_center"], // 资产路径数组形式
"attentionCount": 1 , //关注数量
"isAttention": true/false, //是否关注
"columns":[{
"columnDesc": "",
"columnName": "sold_date_sk",
"columnType": "BIGINT(19,0)"
}]
}]
请求示例
5.1查询标签为上游资产，资产在财务/分公司财务分类下，且资产是在mysql_demo下的资产。
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?catalog_names=mysql_demo&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=&tag_ids=TAG_M2HMO16
返回信息：
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "mysql_demo",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "ws_sold_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_sold_time_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_item_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_page_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_site_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_mode_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_warehouse_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_promo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_order_number",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_quantity",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_profit",
"columnType": "DECIMAL"
}
],
"datasourceType": "MYSQL",
"description": "",
"attentionCount": 0,
"guid": "\"mysql_demo\".\"tpcds\".\"web_sales\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "web_sales",
"tableType": "TABLE",
"tableUpdateTime": "1735107388281",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产",
}
]
},
{
"catalogName": "mysql_demo",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "端口",
"columnType": "LONGTEXT"
},
{
"columnDesc": "",
"columnName": "IP",
"columnType": "LONGTEXT"
},
{
"columnDesc": "",
"columnName": "id",
"columnType": "LONGTEXT"
}
],
"datasourceType": "MYSQL",
"description": "",
"attentionCount": 0,
"guid": "\"mysql_demo\".\"tpcds\".\"test_export\"",
"isAttention": false,
"locations": "",
"owner": "Aloudata",
"tableName": "test_export",
"tableType": "TABLE",
"tableUpdateTime": "1736411535999",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产",
}
]
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 2
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.158.17367689904501151"
}
5.2 搜索标签为上游资产，资产在财务/分公司财务分类下，资产是在mysql_demo下， 且关键字为web的资产。
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?catalog_names=mysql_demo&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=web&tag_ids=TAG_M2HMO16
返回信息：
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "mysql_demo",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "ws_sold_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_sold_time_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_item_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_page_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_site_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_mode_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_warehouse_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_promo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_order_number",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_quantity",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_profit",
"columnType": "DECIMAL"
}
],
"datasourceType": "MYSQL",
"description": "",
"attentionCount": 0,
"guid": "\"mysql_demo\".\"tpcds\".\"web_sales\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "web_sales",
"tableType": "TABLE",
"tableUpdateTime": "1735107388281",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产"
}
]
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 1
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.156.17367694977029743"
}
5.3 搜索标签为上游资产，资产在财务/分公司财务分类下，资产是在mysql_demo下， 关键字为web的资产，且视图类型为基础视图
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?search?catalog_names=mysql_demo&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=&table_type=TABLE&tag_ids=TAG_M2HMO16
返回信息：
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "mysql_demo",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "ws_sold_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_sold_time_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_date_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_item_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_bill_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_customer_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_cdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_hdemo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_addr_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_page_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_web_site_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_ship_mode_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_warehouse_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_promo_sk",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_order_number",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_quantity",
"columnType": "INT"
},
{
"columnDesc": "",
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL"
},
{
"columnDesc": "",
"columnName": "ws_net_profit",
"columnType": "DECIMAL"
}
],
"datasourceType": "MYSQL",
"description": "",
"attentionCount": 0,
"guid": "\"mysql_demo\".\"tpcds\".\"web_sales\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "web_sales",
"tableType": "TABLE",
"tableUpdateTime": "1735107388281",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产"
}
]
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 1
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.156.17367694977029743"
}
5.4 搜索标签为上游资产，资产在财务/分公司财务分类下，且视图类型为逻辑视图。
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?search?search?catalog_names=&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=&table_type=VIEW&tag_ids=TAG_M2HMO16
返回信息：
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "zs_test",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "country",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "state",
"columnType": "VARCHAR(2)"
},
{
"columnDesc": "",
"columnName": "city",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnName": "d_week_seq",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "sun_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "mon_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "tue_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "wed_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "thu_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "fri_sales",
"columnType": "DECIMAL(38,2)"
},
{
"columnDesc": "",
"columnName": "sat_sales",
"columnType": "DECIMAL(38,2)"
}
],
"datasourceType": "",
"description": "",
"attentionCount": 0,
"guid": "\"zs_test\".\"dws\".\"dws_sales_sum_by_weeks\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "dws_sales_sum_by_weeks",
"tableType": "VIEW",
"tableUpdateTime": "1736234644453",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产",
}
]
},
{
"catalogName": "zhoupeng_test",
"categoryPath": ["财务","分公司财务"],
"columns": [
{
"columnDesc": "",
"columnName": "ds",
"columnType": "VARCHAR"
},
{
"columnDesc": "",
"columnName": "union_code",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "union_name",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "orders",
"columnType": "DECIMAL(38,19)"
}
],
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"zhoupeng_test\".\"test\".\"datafabric_test\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "datafabric_test",
"tableType": "VIEW",
"tableUpdateTime": "1734075087730",
"tags": [
{
"tagId": "TAG_M2HMO16",
"tagName": "上游资产",
}
]
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 2
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.294972.17367723406332707"
}
5.5 搜索关键字为web，且视图类型为逻辑视图
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?search?search?catalog_names=&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=&table_type=VIEW&tag_ids=TAG_M2HMO16
返回信息：
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "zs_test",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnName": "web_site_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "web_site_id",
"columnType": "VARCHAR(16)"
},
{
"columnDesc": "",
"columnName": "web_rec_start_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnName": "web_rec_end_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnName": "web_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnName": "web_open_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "web_close_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "web_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnName": "web_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnName": "web_mkt_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "web_mkt_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnName": "web_mkt_desc",
"columnType": "VARCHAR(100)"
},
{
"columnDesc": "",
"columnName": "web_market_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnName": "web_company_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnName": "web_company_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnName": "web_street_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnName": "web_street_name",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnName": "web_street_type",
"columnType": "VARCHAR(15)"
},
{
"columnDesc": "",
"columnName": "web_suite_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnName": "web_city",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnName": "web_county",
"columnType": "VARCHAR(30)"
},
{
"columnDesc": "",
"columnName": "web_state",
"columnType": "VARCHAR(2)"
},
{
"columnDesc": "",
"columnName": "web_zip",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnName": "web_country",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "web_gmt_offset",
"columnType": "DECIMAL(5,2)"
},
{
"columnDesc": "",
"columnName": "web_tax_percentage",
"columnType": "DECIMAL(5,2)"
}
],
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"zs_test\".\"ods\".\"test01031\"",
"isAttention": false,
"owner": "baosight",
"tableName": "test01031",
"tableType": "VIEW",
"tableUpdateTime": "1735873039514",
"tags": []
},
{
"catalogName": "zs_test",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_site_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_site_id",
"columnType": "VARCHAR(16)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_rec_start_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_rec_end_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_open_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_close_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_desc",
"columnType": "VARCHAR(100)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_market_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_company_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_company_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_name",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_type",
"columnType": "VARCHAR(15)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_suite_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_city",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_county",
"columnType": "VARCHAR(30)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_state",
"columnType": "VARCHAR(2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_zip",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_country",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_gmt_offset",
"columnType": "DECIMAL(5,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_tax_percentage",
"columnType": "DECIMAL(5,2)"
}
],
"datasourceType": "",
"description": "",
"attentionCount": 0,
"guid": "\"zs_test\".\"ods\".\"test0103\"",
"isAttention": false,
"owner": "baosight",
"tableName": "test0103",
"tableType": "VIEW",
"tableUpdateTime": "1735872938520",
"tags": []
},
{
"catalogName": "zs_test",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_site_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_site_id",
"columnType": "VARCHAR(16)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_rec_start_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_rec_end_date",
"columnType": "DATE(0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_open_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_close_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_class",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_mkt_desc",
"columnType": "VARCHAR(100)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_market_manager",
"columnType": "VARCHAR(40)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_company_id",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_company_name",
"columnType": "VARCHAR(50)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_name",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_street_type",
"columnType": "VARCHAR(15)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_suite_number",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_city",
"columnType": "VARCHAR(60)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_county",
"columnType": "VARCHAR(30)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_state",
"columnType": "VARCHAR(2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_zip",
"columnType": "VARCHAR(10)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_country",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_gmt_offset",
"columnType": "DECIMAL(5,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "web_tax_percentage",
"columnType": "DECIMAL(5,2)"
}
],
"comment": "",
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"zs_test\".\"ods\".\"chartest\"",
"isAttention": false,
"locations": "",
"owner": "baosight",
"tableName": "chartest",
"tableType": "VIEW",
"tableUpdateTime": "1735872718584",
"tags": []
},
{
"catalogName": "demo",
"categoryPath": ["销售"],
"columns": [
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_date_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_time_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_date_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_item_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_customer_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_cdemo_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_hdemo_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_addr_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_customer_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_cdemo_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_hdemo_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_addr_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_page_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_site_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_mode_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_warehouse_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_promo_sk",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_order_number",
"columnType": "BIGINT(19,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_quantity",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_profit",
"columnType": "DECIMAL(7,2)"
}
],
"comment": "",
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"demo\".\"retail_e_commerce\".\"big_web_sales\"",
"id": null,
"isAttention": false,
"locations": "",
"owner": "Aloudata",
"tableName": "big_web_sales",
"tableType": "VIEW",
"tableUpdateTime": "1730183283657",
"tagIds": [],
"tags": []
},
{
"catalogName": "jueyun",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_time_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_item_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_customer_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_cdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_hdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_addr_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_customer_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_cdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_hdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_addr_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_page_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_site_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_mode_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_warehouse_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_promo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_order_number",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_quantity",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_profit",
"columnType": "DECIMAL(7,2)"
}
],
"comment": "",
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"jueyun\".\"fact\".\"fact_web_sales\"",
"isAttention": false,
"owner": "Aloudata",
"tableName": "fact_web_sales",
"tableType": "VIEW",
"tableUpdateTime": "1728541368568",
"tagIds": [],
"tags": []
},
{
"catalogName": "demo",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sold_time_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_date_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_item_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_customer_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_cdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_hdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_bill_addr_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_customer_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_cdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_hdemo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_addr_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_page_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_web_site_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ship_mode_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_warehouse_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_promo_sk",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_order_number",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_quantity",
"columnType": "INTEGER(10,0)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_discount_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_sales_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_wholesale_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_list_price",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_coupon_amt",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_ext_ship_cost",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_paid_inc_ship_tax",
"columnType": "DECIMAL(7,2)"
},
{
"columnDesc": "",
"columnIndex": 0,
"columnName": "ws_net_profit",
"columnType": "DECIMAL(7,2)"
}
],
"datasourceType": "",
"description": "",
"attentionCount": "0",
"guid": "\"demo\".\"zou\".\"view01\"",
"isFavorite": false,
"locations": "",
"owner": "Aloudata",
"tableName": "view01",
"tableType": "VIEW",
"tableUpdateTime": "1721113222148",
"tagIds": [],
"tags": []
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 6
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.152.17367735962640249"
}
5.5搜索关键字为测试
请求url: Http://127.0.0.1:8080/air/api/v1/asset/search?search?search?catalog_names=&category_ids=CATEGORY_L5E5MXO%2CCATEGORY_M6E8M1Y&page_number=1&page_size=30&search=&table_type=VIEW&tag_ids=TAG_M2HMO16
{
"data": {
"hasNextPage": null,
"list": [
{
"catalogName": "chery",
"categoryPath": [],
"columns": [
{
"columnDesc": "",
"columnName": "ds",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "union_code",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "union_name",
"columnType": "VARCHAR(20)"
},
{
"columnDesc": "",
"columnName": "orders",
"columnType": "DECIMAL(38,19)"
}
],
"datasourceType": "",
"description": "测试描述信",
"attentionCount": "0",
"guid": "\"chery\".\"tmp\".\"sqlsever_wuheng\"",
"isAttention": false,
"owner": "chery",
"tableName": "sqlsever_wuheng",
"tableType": "VIEW",
"tableUpdateTime": "1734051389968",
"tags": []
}
],
"pageNumber": 1,
"pageSize": 30,
"total": 1
},
"errorCode": "",
"errorMsg": "",
"success": true,
"traceId": "894f3a9852ac46e8af7ac4e17f69227a.155.17367740380541743"
}