模板介绍

模板说明

根据第三方部门Id获取部门信息到本地数仓中

流程图

依赖组件

1.需要下载根据第三方部门Id获取部门信息组件
2.需要创建相应的表结构或者让输出组件自动建表

依赖表结构

CREATE TABLE `明道云根据第三方部门id获取部门信息`  (
  `corpDepartmentId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  `projectId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `departmentId` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `parentDepartmentIdPaths` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `parentCorpDepartmentIdPaths` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `childDepartmentIds` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  `childCorpDepartmentIds` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL,
  PRIMARY KEY (`corpDepartmentId`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

使用评价