本文为您介绍使用数据资源平台前需要完成的准备工作。

购买数据资源平台

  1. 单击进入数据资源平台购买,选择购买信息后,单击立即购买
  2. 弹出确认订单页面,勾选数据资源平台服务协议,单击去支付
  3. 等待开通,开通成功后单击控制台,进入数据资源平台。

登录数据资源平台

单击进入数据资源平台控制台

初始化语句

准备建表语句和插入数据语句以,在MaxCompute数据库中创建表stg_base_yhkh_di 为例介绍,这里所有表的名称和内容均是举例,用户可根据需要自定义

stg_base_yhkh_di表DDL语句:
create table if not exists `stg_base_yhkh_di` (
`id` bigint comment '主键',
`zzhm` string comment '证件号码',
`khmc` string comment '客户名称',
`nl` bigint comment '年龄',
`xb` bigint comment '性别 0:男 1:女',
`yddh1` string comment '移动电话1',
`csrq` string comment '出生日期',
`jysp` bigint comment '教育水平 0:研究生 1:本科 2:高中 3:职业高中 4:职业学院',
`career` bigint comment '职业 0:保险 1:教师 2:外企白领 3:自由职业 4:it工程师',
`hyzk` bigint comment '婚姻状况 0:已婚 1:未婚',
`gz` bigint comment '工资',
`decdbyjyje` bigint comment '大额存单本月交易金额',
`decdbyjybs` bigint comment '大额存单本月交易笔数',
`zjzdjyrq` string comment '最近主动交易日期',
`jtnsr` bigint comment '家庭年收入',
`dqckcy` bigint comment '定期存款持有'
)
 comment '银行客户信息'
;
插入数据语句:
insert into stg_base_yhkh_di values
(1,'CKR-1000','谢敏',33,0,'(86)31*34620595','2002-03-06',0,3,1,80000,95429,31,'2019-05-13',1425574,83489),
(2,'CKR-2000','罗静',68,1,'+86*3647553845','2009-11-15',0,3,0,40000,54194,34,'2001-10-15',4732362,99694),
(3,'CKR-3000','汤洋',46,1,'339*4547704','1993-09-04',0,3,1,40000,61863,58,'1987-10-06',7593193,11215),
(4,'CKR-4000','何平',44,0,'282*0449032','1999-07-22',1,3,0,35000,61082,60,'1989-10-07',9177195,60752),
(5,'CKR-5000','文娜',36,0,'252*5166267','1992-07-15',1,3,0,25000,71953,35,'2001-04-04',2925278,4165),
(6,'CKR-1005','江静',15,0,'266*1327402','1981-03-04',1,3,0,15000,43857,42,'2014-01-08',5253141,65308),
(7,'CKR-1006','汤丽',6,0,'380*9177920','1986-10-20',1,3,1,10000,8503,86,'1970-09-12',5296756,85285),
(8,'CKR-1007','江军',62,1,'217*1353562','1982-04-27',0,3,0,17000,65718,86,'1989-05-23',1762593,96453),
(9,'CKR-1008','雷秀英',34,0,'21*47630365','1989-06-23',4,3,0,50000,97157,12,'1977-08-16',763445,99478),
(10,'CKR-1009','孟超',95,0,'351*3310990','2008-07-12',0,2,1,15000,68605,54,'2011-10-13',6635322,87174),
(11,'CKR-1010','常超',71,0,'354*6048078','2008-06-10',0,2,1,8500,49055,98,'1978-01-21',3847031,51571),
(12,'CKR-1011','乔强',34,1,'370*0349190','1977-11-03',1,2,1,15000,72188,65,'2019-08-09',9715625,11546),
(13,'CKR-1012','金军',4,1,'+862*364711221','1977-11-11',1,2,0,17000,65132,39,'1992-11-26',9875371,93019),
(14,'CKR-1013','龚明',78,0,'333*1797005','2005-12-10',1,2,0,12000,15774,83,'1973-12-30',5007852,78029),
(15,'CKR-1014','何刚',57,0,'203*7333193','1977-01-27',1,2,1,17000,12815,55,'2007-10-22',409723,62655),
(16,'CKR-1015','贺明',18,1,'363*9234358','2001-12-25',4,4,1,10000,90515,3,'1989-01-07',751082,18248),
(17,'CKR-1016','潘超',76,0,'285*9508428','2003-12-24',4,4,1,17000,68525,44,'1995-07-22',7495966,81766),
(18,'CKR-1017','潘明',74,1,'221*0074676','1973-06-06',1,4,1,10000,71531,78,'2011-07-26',366257,7696),
(19,'CKR-1018','顾秀英',92,0,'35*38683766','2017-11-11',1,4,0,30000,62387,1,'1988-05-21',2213117,85397),
(20,'CKR-1019','马娜',13,0,'+862*708223252','2014-07-02',1,4,0,35000,66701,68,'1990-11-03',8238187,65044),
(21,'CKR-1020','曾磊',78,0,'2120*567551','1983-05-18',1,1,0,35000,53658,26,'2001-04-06',7262309,36107),
(22,'CKR-1021','阎涛',77,0,'2325*779412','2014-05-21',1,1,1,15000,38751,18,'2006-01-18',4477225,12690),
(23,'CKR-1022','魏勇',96,1,'3368*988055','1978-04-18',4,1,1,17000,31883,2,'1983-03-11',8062079,48940),
(24,'CKR-1023','赵静',55,1,'3519*158809','1998-05-10',0,0,1,12000,52528,97,'1999-10-03',4701315,97298),
(25,'CKR-1024','魏敏',12,0,'3153*636658','1999-02-13',2,0,1,15000,33481,27,'1985-10-14',7808248,8086),
(26,'CKR-1025','乔娟',38,1,'+861*799174454','1978-03-29',1,0,0,16000,71075,83,'1993-09-10',5946732,7717),
(27,'CKR-1026','邓娟',79,0,'343*7912543','2007-08-20',4,0,0,14000,44632,84,'1976-08-17',9530773,22782),
(28,'CKR-1027','贺伟',38,0,'330*9112291','2006-05-24',0,0,0,8500,94004,49,'1983-02-01',6219669,29030),
(29,'CKR-1028','谭强',80,0,'+86*0283740235','1973-12-13',4,0,0,15000,7536,24,'2003-11-18',8550386,9772),
(30,'CKR-1029','余涛',93,1,'240*1917546','2017-10-26',4,0,1,14000,77595,40,'1977-11-19',5950564,73535),
(31,'CKR-1030','谢明',21,0,'216*2351966','1992-12-31',2,0,0,17000,65481,86,'1978-11-14',5902767,80462),
(32,'CKR-1031','陆丽',50,0,'(86)210*5489862','2018-03-04',1,0,1,17000,16100,45,'1999-07-13',7209351,18872),
(33,'CKR-1032','谭秀英',14,1,'3365*105481','1986-01-09',0,0,0,7000,87617,40,'2013-07-14',7266776,26436),
(34,'CKR-1033','胡明',17,0,'2507*360286','2002-02-13',1,2,1,11000,11490,67,'1993-01-25',1498183,51372),
(35,'CKR-1034','史秀英',60,0,'343*9771121','1973-05-16',1,2,1,45000,87909,24,'2018-06-05',2030521,26098),
(36,'CKR-1035','苏军',72,0,'3404*439055','1988-10-30',1,2,1,6700,29314,5,'1995-10-09',7693879,68804),
(37,'CKR-1036','叶明',71,0,'2043*074633','2018-04-02',2,2,0,8000,81260,43,'2000-11-27',7005542,29571),
(38,'CKR-1037','潘明',14,0,'3448*635278','1987-12-23',1,2,1,10000,8007,8,'2018-02-23',9003028,20745),
(39,'CKR-1038','许磊',4,0,'2140*616984','1990-08-22',2,2,0,10000,78111,74,'1994-01-01',9313883,19159),
(40,'CKR-1039','余强',30,0,'(86)30*99305187','2002-12-20',2,1,1,8500,43071,34,'1992-01-19',3081415,94513),
(41,'CKR-1040','崔娟',11,0,'34029*33814','1986-06-19',2,1,0,5000,87999,5,'1987-02-13',178974,61325),
(42,'CKR-1041','贺娟',97,0,'25353*99318','2001-02-18',4,1,1,6700,78972,78,'1972-02-13',5901890,70525),
(43,'CKR-1042','许霞',85,0,'36913*69766','2002-05-06',1,0,1,5000,91055,24,'2018-01-05',6859793,78753),
(44,'CKR-1043','沈平',10,0,'(86)2*870287190','1981-09-02',0,0,0,6800,63460,13,'1980-10-23',2177974,76217),
(45,'CKR-1044','万强',20,1,'3696*761882','1979-04-07',2,0,1,6600,39348,94,'1985-12-10',1728750,36261),
(46,'CKR-1045','袁伟',99,0,'2966*782625','1989-10-22',2,0,0,6500,92593,2,'1990-03-07',1821075,11599),
(47,'CKR-1046','傅勇',23,1,'2692*733892','2004-02-17',4,0,0,7200,68864,99,'2016-08-26',1387723,28969),
(48,'CKR-1047','龚敏',6,1,'26155*76181','1989-02-04',0,0,1,5000,79006,60,'1988-01-04',7876225,82518),
(49,'CKR-1048','彭超',17,0,'2820*329738','1999-05-11',1,0,1,5000,14056,61,'1983-08-25',5280068,75582),
(50,'CKR-1049','乔军',44,0,'2004*581812','1983-01-15',2,1,0,5000,6073,86,'1970-03-27',6822252,55308),
(51,'CKR-1050','贺娟',4,0,'2445*838800','1990-10-21',4,1,0,5000,89753,89,'2004-07-30',8107579,27253),
(52,'CKR-1051','蒋娟',83,0,'331*7981781','1981-07-26',2,1,0,12000,89547,39,'1996-03-27',9546849,98847),
(53,'CKR-1052','阎娟',43,0,'249*6035583','1994-10-30',4,0,1,9000,56956,44,'1975-01-18',115463,75243),
(54,'CKR-1053','范伟',92,1,'207*5252149','2016-11-16',3,0,1,8000,99009,10,'2014-07-05',6628234,97674),
(55,'CKR-1054','苏丽',34,0,'342*1900542','2014-07-15',2,0,0,7000,81145,33,'2004-07-14',4140885,14247),
(56,'CKR-1055','赵娟',91,0,'252*9751191','2001-04-04',1,0,0,8500,60527,5,'1988-04-21',3255066,88485),
(57,'CKR-1056','赵丽',84,0,'338*2657660','1980-11-27',1,0,0,8500,42275,51,'1988-10-16',8660761,75908),
(58,'CKR-1057','邓磊',11,0,'249*3084592','1973-11-06',4,0,0,9000,57619,62,'1998-09-11',8035936,6989),
(59,'CKR-1058','张芳',36,0,'265*9014399','1973-02-09',1,0,1,7200,33170,35,'1980-08-20',3885281,42114),
(60,'CKR-1059','孙平',35,0,'301*4201907','1989-05-29',1,3,0,6800,29221,17,'2001-06-08',7175461,39317),
(61,'CKR-1060','金霞',4,1,'3298*752689','2018-04-06',0,3,0,6900,56864,48,'1984-09-19',5103692,34747),
(62,'CKR-1061','谢芳',37,1,'223*5686051','1981-05-12',4,3,1,7100,32834,34,'2006-05-05',8119980,44347),
(63,'CKR-1062','石勇',28,0,'311*1192235','2013-02-06',4,3,0,7000,45832,81,'2016-06-03',7215690,60679),
(64,'CKR-1063','蒋伟',83,0,'327*7409172','1975-08-14',1,3,1,7000,28624,67,'2005-05-19',401890,4493),
(65,'CKR-1064','尹娜',14,0,'269*6147594','2014-12-16',2,2,1,5000,50594,88,'2010-09-03',4781451,52552),
(66,'CKR-1065','阎伟',4,1,'2977*084127','1983-01-12',1,2,1,9000,34747,46,'1972-12-15',3021194,99764),
(67,'CKR-1066','杨磊',3,1,'2588*125057','2005-11-01',4,2,0,6500,93199,33,'1989-07-26',772627,25525),
(68,'CKR-1067','雷平',100,1,'215*1765761','2016-04-02',1,2,1,7500,33137,78,'1989-09-21',3897294,95987),
(69,'CKR-1068','许杰',13,0,'3480*948302','2004-06-12',2,3,1,4400,14611,90,'1992-03-07',8212692,30070),
(70,'CKR-1069','熊娜',80,1,'3423*155863','2003-03-07',3,3,1,4800,76704,63,'1977-02-16',5031631,8627),
(71,'CKR-1070','邓勇',96,0,'3676*644599','1983-12-15',0,3,0,3700,74704,82,'2002-11-05',3221507,43394),
(72,'CKR-1071','赖芳',4,0,'2456*419827','1996-10-11',4,3,0,6500,96055,18,'2008-03-21',7341282,90341),
(73,'CKR-1072','王超',27,1,'386*4282514','1980-08-30',2,3,1,5200,87710,34,'1985-10-11',6442607,52075),
(74,'CKR-1073','秦强',95,1,'321*1869518','2018-04-25',1,2,0,4650,88563,96,'2009-01-05',2643763,84598),
(75,'CKR-1074','贺涛',10,0,'330*3447619','2006-10-14',1,2,1,4550,13903,18,'1984-01-26',345408,81526),
(76,'CKR-1075','雷平',61,0,'247*3147347','1996-08-30',2,2,1,4400,32375,0,'1992-06-04',7901871,29745),
(77,'CKR-1076','秦娟',61,0,'224*5879686','2013-07-03',2,2,1,4700,16121,49,'1979-04-15',8668010,15787),
(78,'CKR-1077','郭磊',12,1,'274*7270138','2014-02-23',1,3,1,4500,32254,2,'1988-10-12',2226230,18156),
(79,'CKR-1078','苏娟',76,0,'208*0972094','1973-04-28',1,3,0,8000,53199,2,'1982-07-07',635335,73580),
(80,'CKR-1079','朱娟',22,1,'3402*589330','2018-10-06',4,3,1,10000,85964,38,'1999-06-05',8596230,14763),
(81,'CKR-1080','孙静',93,1,'2619*165677','1994-09-18',0,3,0,10000,15577,82,'1975-03-25',5012535,14102);