数据治理中心 DATAARTS STUDIO-创建表模型:请求示例

时间:2023-11-29 09:26:28

请求示例

{
  "id" : "1012314146584301568",
  "model_id" : "873242752312385536",
  "parent_table_id" : null,
  "parent_table_name" : null,
  "parent_table_code" : null,
  "model" : {
    "name" : "test",
    "type" : "THIRD_NF"
  },
  "data_format" : "Parquet",
  "obs_bucket" : null,
  "obs_location" : null,
  "configs" : "{}",
  "table_type" : "MANAGED",
  "owner" : "",
  "tb_name" : "staff_info",
  "dw_id" : "2c9080f07b03db8d017b198a4a20002f",
  "db_name" : "ctz_test",
  "queue_name" : "default",
  "schema" : "",
  "extend_info" : "{\"dirtyOutDatabase\":\"\",\"dirtyOutPrefix\":\"\",\"dirtyOutSuffix\":\"\",\"dirtyOutSwitch\":\"false\"}",
  "tb_guid" : null,
  "tb_id" : "NativeTable-2c9080f07b03db8d017b198a4a20002f-ctz_test-staff_info",
  "logic_tb_name" : "staff_info",
  "logic_tb_guid" : "1ab1a58b-9412-4901-bb80-4ccaaa0580e4",
  "description" : "无",
  "status" : "PUBLISHED",
  "logic_tb_id" : null,
  "biz_catalog_id" : "1012306178602041344",
  "catalog_path" : "工厂/人员管理/人员档案",
  "create_by" : "abc",
  "update_by" : "abc",
  "create_time" : "2022-08-25T10:55:00+08:00",
  "update_time" : "2022-08-25T10:55:45+08:00",
  "tags" : [ {
    "name" : 123
  } ],
  "approval_info" : {
    "id" : "1012314318533988352",
    "tenant_id" : null,
    "name_ch" : null,
    "name_en" : null,
    "biz_id" : "1012314146584301568",
    "biz_type" : null,
    "biz_info" : null,
    "biz_info_obj" : null,
    "biz_version" : 0,
    "biz_status" : "PUBLISHED",
    "approval_status" : "APPROVED",
    "approval_type" : null,
    "submit_time" : "2022-08-25T10:55:41+08:00",
    "create_by" : null,
    "l1" : null,
    "l2" : null,
    "l3" : null,
    "approval_time" : "2022-08-25T10:55:41+08:00",
    "approver" : "abc",
    "email" : null,
    "msg" : "Fast Approval OK.",
    "directory_path" : null
  },
  "new_biz" : null,
  "attributes" : [ {
    "id" : "1012314146626244608",
    "name_en" : "id",
    "name_ch" : "主键",
    "description" : "",
    "obs_location" : null,
    "create_by" : "abc",
    "update_by" : "abc",
    "data_type" : "STRING",
    "domain_type" : "STRING",
    "data_type_extend" : "",
    "is_primary_key" : true,
    "is_partition_key" : false,
    "is_foreign_key" : false,
    "extend_field" : false,
    "not_null" : true,
    "ordinal" : 1,
    "table_model_id" : null,
    "create_time" : "2022-08-25T10:55:00+08:00",
    "update_time" : "2022-08-25T10:55:00+08:00",
    "tags" : [ {
      "name" : 123
    } ],
    "stand_row_id" : null,
    "stand_row_name" : null,
    "quality_infos" : [ {
      "data_quality_id" : 3
    } ],
    "alias" : "",
    "self_defined_fields" : [ ]
  }, {
    "id" : "1012314146626244609",
    "name_en" : "name",
    "name_ch" : "名称",
    "description" : "",
    "obs_location" : null,
    "create_by" : "abc",
    "update_by" : "abc",
    "data_type" : "STRING",
    "domain_type" : "STRING",
    "data_type_extend" : "",
    "is_primary_key" : false,
    "is_partition_key" : false,
    "is_foreign_key" : false,
    "extend_field" : false,
    "not_null" : false,
    "ordinal" : 2,
    "table_model_id" : null,
    "create_time" : "2022-08-25T10:55:00+08:00",
    "update_time" : "2022-08-25T10:55:00+08:00",
    "tags" : [ {
      "name" : 123
    } ],
    "stand_row_id" : null,
    "stand_row_name" : null,
    "quality_infos" : [ {
      "data_quality_id" : 3
    } ],
    "alias" : "",
    "self_defined_fields" : [ ]
  }, {
    "id" : "1012314146592690176",
    "name_en" : "age",
    "name_ch" : "年龄",
    "description" : "",
    "obs_location" : null,
    "create_by" : "abc",
    "update_by" : "abc",
    "data_type" : "STRING",
    "domain_type" : "STRING",
    "data_type_extend" : "",
    "is_primary_key" : false,
    "is_partition_key" : false,
    "is_foreign_key" : false,
    "extend_field" : false,
    "not_null" : false,
    "ordinal" : 3,
    "table_model_id" : null,
    "create_time" : "2022-08-25T10:55:00+08:00",
    "update_time" : "2022-08-25T10:55:00+08:00",
    "tags" : [ {
      "name" : 123
    } ],
    "stand_row_id" : null,
    "stand_row_name" : null,
    "quality_infos" : [ {
      "data_quality_id" : 3
    } ],
    "alias" : "",
    "self_defined_fields" : [ ]
  } ],
  "mappings" : [ {
    "name" : "test_mapping"
  } ],
  "relations" : [ {
    "name" : "test_relation"
  } ],
  "dw_type" : "DLI",
  "dw_name" : null,
  "l1" : "工厂",
  "l2" : "人员管理",
  "l3" : "人员档案",
  "l1_id" : "1012305751919689728",
  "l2_id" : "1012306048792526848",
  "l3_id" : "1012306178602041344",
  "partition_conf" : null,
  "dlf_task_id" : null,
  "use_recently_partition" : false,
  "reversed" : null,
  "dirty_out_switch" : false,
  "dirty_out_database" : "",
  "dirty_out_prefix" : "",
  "dirty_out_suffix" : "",
  "quality_owner" : null,
  "quality_id" : "1012314332484304897",
  "distribute" : null,
  "distribute_column" : null,
  "is_partition" : false,
  "physical_table" : "CREATE_SUCCESS",
  "technical_asset" : "CREATE_FAILED",
  "business_asset" : "UPDATE_SUCCESS",
  "meta_data_link" : "UPDATE_FAILED",
  "data_quality" : "CREATE_SUCCESS",
  "summary_status" : "SUMMARY_FAILED",
  "alias" : null,
  "self_defined_fields" : null
}
support.huaweicloud.com/api-dataartsstudio/CreateTableModel.html