{
  "uuid": "9c0f4ee2-1ccb-4b07-a38e-4c298563e0f7",
  "name": "test_kylin_left_join_model_desc",
  "lookups": [
    {
      "table": "EDW.TEST_CAL_DT",
      "join": {
        "type": "left",
        "primary_key": [
          "CAL_DT"
        ],
        "foreign_key": [
          "CAL_DT"
        ]
      }
    },
    {
      "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
      "join": {
        "type": "left",
        "primary_key": [
          "LEAF_CATEG_ID",
          "SITE_ID"
        ],
        "foreign_key": [
          "LEAF_CATEG_ID",
          "LSTG_SITE_ID"
        ]
      }
    },
    {
      "table": "EDW.TEST_SITES",
      "join": {
        "type": "left",
        "primary_key": [
          "SITE_ID"
        ],
        "foreign_key": [
          "LSTG_SITE_ID"
        ]
      }
    },
    {
      "table": "EDW.TEST_SELLER_TYPE_DIM",
      "join": {
        "type": "left",
        "primary_key": [
          "SELLER_TYPE_CD"
        ],
        "foreign_key": [
          "SLR_SEGMENT_CD"
        ]
      }
    }
  ],
  "dimensions": [
    {
      "table": "default.test_kylin_fact",
      "columns": [
        "lstg_format_name",
        "LSTG_SITE_ID",
        "SLR_SEGMENT_CD",
        "TRANS_ID",
        "CAL_DT",
        "LEAF_CATEG_ID",
        "SELLER_ID",
        "ORDER_ID"
      ]
    },
    {
      "table": "default.test_category_groupings",
      "columns": [
        "leaf_categ_id",
        "site_id",
        "USER_DEFINED_FIELD1",
        "USER_DEFINED_FIELD3",
        "UPD_DATE",
        "UPD_USER",
        "meta_categ_name",
        "categ_lvl2_name",
        "categ_lvl3_name"
      ]
    },
    {
      "table": "edw.test_sites",
      "columns": [
        "site_id",
        "site_name",
        "cre_user"
      ]
    },
    {
      "table": "edw.test_seller_type_dim",
      "columns": [
        "seller_type_cd",
        "seller_type_desc"
      ]
    },
    {
      "table": "edw.test_cal_dt",
      "columns": [
        "cal_dt",
        "week_beg_dt"
      ]
    }
  ],
  "metrics": [
    "PRICE",
    "ITEM_COUNT"
  ],
  "last_modified": 1422435345352,
  "fact_table": "DEFAULT.TEST_KYLIN_FACT",
  "filter_condition": null,
  "partition_desc": {
    "partition_date_column": "DEFAULT.TEST_KYLIN_FACT.cal_dt",
    "partition_date_start": 0,
    "partition_type": "APPEND"
  }
}