智能数据洞察 DATAARTS INSIGHT-获取数据集详情:响应示例

时间:2024-08-05 11:34:06

响应示例

状态码:200

获取数据集详情成功。

{ 
  "create_date" : 1705458279173, 
  "create_user" : "cfcxxxx4501811aedcxxxxbbfe8", 
  "create_user_name" : "xxxxxxx", 
  "update_date" : 1705458279173, 
  "update_user" : "cfcc77xxxx364501811aedcxxxxbbfe8", 
  "update_user_name" : "xxxxxxx", 
  "project_id" : "34ba64e53axxxb68cd7xxxxa8cc17bd", 
  "workspace_id" : "d39157xxxx5f43c2bdxxxx74792b2d5e", 
  "id" : "b745d57b-xxxx-4f2a-xxxx-3c0ff5fcf92f", 
  "caption" : "api测试数据集10", 
  "version" : "2.0", 
  "ds_id" : "2eaa208dxxxxxxx9496914134fae2d4", 
  "ds_type" : "DWS", 
  "domain_id" : "10ae45e7xxxxxxbe954a211426d003", 
  "physical_schema" : { 
    "tables" : [ { 
      "id" : "a25173cb-xxxx-42ec-xxxxx-67483f6cdaab", 
      "database_name" : "modernbi_demo", 
      "schema_name" : "autotest", 
      "table_name" : "order_info", 
      "table_type" : "table", 
      "sql_text" : "", 
      "is_fact_table" : false 
    }, { 
      "id" : "b745d57b-xxxx-4f2a-xxxx-3c0ff5fcf92f", 
      "database_name" : "modernbi_demo", 
      "schema_name" : "autotest", 
      "table_name" : "sql_order_info", 
      "table_type" : "sql", 
      "sql_text" : "select * from autotest.order_info", 
      "is_fact_table" : true 
    } ] 
  }, 
  "logical_schema" : { 
    "field_schema" : { 
      "measures" : [ { 
        "id" : "2d83ad17-32bb-xxxx-9c55-xxxxxxx", 
        "caption" : "cs_bill_customer_sk", 
        "is_expansion" : 0, 
        "expansion_type" : 0, 
        "column_formula" : "cs_xxxxx_customer_sk", 
        "origin_column_name" : "cs_xxxx_customer_sk", 
        "origin_column_type" : "int8", 
        "data_type" : "NUMBER", 
        "origin_data_type" : "NUMBER", 
        "cube_id" : "2d83ad17-xxxxxxxxx-9c55-2a47415bdaf6" 
      } ], 
      "dimensions" : [ { 
        "id" : "a25173cb-e229-xxxxxxx-67483f6cdaab.id", 
        "caption" : "id1", 
        "dimension_type" : "StandardDimension", 
        "hierarchies" : [ { 
          "caption" : "id1", 
          "levels" : [ { 
            "id" : "a25173cb-xxxxxxxxc-a4b4-67483f6cdaab.id", 
            "caption" : "id1", 
            "data_type" : "STRING", 
            "origin_data_type" : "STRING", 
            "origin_column_name" : "id", 
            "origin_column_type" : "varchar(255)", 
            "column_formula" : "id", 
            "level_type" : null, 
            "is_expansion" : 0, 
            "expansion_type" : 0 
          } ] 
        } ], 
        "cube_id" : "a25173cb-xxxxxxxc-a4b4-67483f6cdaab" 
      } ] 
    }, 
    "variables" : null, 
    "relations" : [ { 
      "source" : "b745d57b-axxxxx8ee4-3c0ff5fcf92f", 
      "target" : "a25173cb-xxxxxx-a4b4-67483f6cdaab", 
      "join_type" : "left join", 
      "relation" : "many-to-one", 
      "joins" : [ { 
        "source_key" : "product_id", 
        "source_type" : "dimension", 
        "target_key" : "product_id", 
        "target_type" : "dimension", 
        "condition" : "equal-to" 
      } ] 
    } ] 
  } 
}
support.huaweicloud.com/api-dataartsinsight/ShowDatasetDetail.html