Snowflakeã¯ãã®ã»ã©ãå匷äŒãéå¬ããå瀟ãæå±ããŠãããããŒã¿ã¯ã©ãŠããã®æŠå¿µãã¯ã©ãŠããã€ãã£ããªããŒã¿ãã©ãããã©ãŒã ãSnowflakeãã®æŠå¿µãç¬èªã®ã¢ãŒããã¯ãã£ãåŸæ¥ã®ããŒã¿ãŠã§ã¢ããŠã¹ïŒDWHïŒãšã®éããããŒã¿ã¯ã©ãŠããä»ããããŒã¿æŽ»çšã®ã¡ãªãããªã©ã説æããã
åé ãæ¥æ¬æ³äººä»£è¡š ã«ã³ããªãŒãããŒãžã£ãŒã®æ±æ¢è±ä¿æ°ã¯ãã7æ31æ¥æç¹ã§ãæŽæ°å¥çŽã1.7åã«å¢ããŠãããæ°ããã¯ãŒã¯ããŒãã«ãSnowflakeã䜿ãããšããé¡§å®¢äŒæ¥ã®åããçŸããŠããããŸãã12ã«æã®å£²äžã100äžãã«ä»¥äžã®é¡§å®¢ã116瀟ã«äžã£ãŠãããæ¥æ¬ã®ããžãã¹ã奜調ã§ã顧客æ°ã¯100瀟以äžã«éããŠãããæé·çã¯ã°ããŒãã«ãäžåã£ãŠããããšããŠãå瀟ã®ããžãã¹ã奜調ã§ããããšãæããã«ããã
æ¢åã®DWHãæ±ãã課é¡ãšã¯ïŒ
ç¶ããŠããããã¯ãããŒã±ãã£ã³ã°ãããŒãžã£ãŒã®KTæ°ããSnowflakeã®æè¡è§£èª¬ãè¡ã£ããåæ°ã¯ããäŒæ¥ã§ã¯ãããŒã¿ãæ¥åããšã«æé©åãããŠããµã€ãåãããŠãããããããããŒã¿ã®æŽ»çšãé£ããããŠãããããã§ãããããã¯ãã£ãšããŒã¿ãæè»ã«äœ¿ããæ¹æ³ãããã°ããã®åé¡ã解決ã§ããã®ã§ã¯ãªãããšèãããã¯ã©ãŠãã®å©çšãå¢ããŠããããšã§ãæè»æ§ã¯å·»ããŠããããæ¬¡ã¯ã¯ã©ãŠãã«ãŸã€ããããŒã¿ãµã€ããã§ããŠããããšãããŒã¿æŽ»çšã«ãŸã€ãã課é¡ãææããã
ããŒã¿åæåºç€ã®æŽå²ã¯ããªã³ãã¬ãã¹ã®DWHïŒããŒã¿ãŠã§ã¢ããŠã¹ïŒããå§ãŸã£ããããŠãŒã¶ãŒã®ã¢ã¯ã»ã¹æ°ãéæ§é åããŒã¿ã®å¢å ã«ããã察å¿ããããªããªã£ãŠãããããã§ããªãœãŒã¹ãæè»ã«æ¡åŒµã§ããã¯ã©ãŠãããŒã¹ã®DWHãåºãŠããããããªãœãŒã¹ã¯æè»ã«äœ¿ããããã«ãªã£ããã管çã«æããããããšã«ã¯å€ãããªãã£ãããšKTæ°ã
ããã«ãããŒã¿ããŒã¹ã«æ ŒçŽã§ããªãããŒã¿ã管çããããã«ãããŒã¿ã¬ã€ã¯ãHadoopãç»å ŽããããŸããŸãªçš®é¡ã®ããŒã¿ãæ ŒçŽã§ããããã«ãªã£ãããã ããããã§ãå°éç¥èãèŠæ±ããããããããŒã¿ã®æŽ»çšã¯ããã»ã©é²ãŸãªãã£ãããšããããããããã¯ãã£ãšããŒã¿æŽ»çšãé²ãããããæ°ããªææŠãããããšã«ããããšKTæ°ã¯èªã£ãã
ããŒã¿ã¯ã©ãŠãã®3ã€ã®ç¹åŸŽ
ããã§ãSnowflakeãäœãäžãããã¯ãããžãŒããããŒã¿ã¯ã©ãŠãããšãªããKTæ°ã¯ãããŒã¿ã¯ã©ãŠãã¯ããŒã¿ããŒã¹ã§ã¯ãªããäŒæ¥ãããŒã¿ãããã€ããŒãããããã®ããžãã¹ã«æé©ãªããŒã¿ã«ã€ãªããããã¯ãŒã¯ããšè¿°ã¹ãããŒã¿ã¯ã©ãŠãã®3ã€ã®ã¡ãªãããæããã
1ã€ç®ã®ã¡ãªããã¯ãã¢ã¯ã»ã¹æ§ãã ãããŒã¿ã¯ã©ãŠãã¯ãçµç¹å ã®ã¢ã¯ã»ã¹ã«å ããŠããšã³ã·ã¹ãã ã®ããŒã¿ããµãŒãããŒãã£ã®ããŒã¿ã®ã¢ã¯ã»ã¹ãŸã§å¯èœã«ããããçµç¹å ã®ããŒã¿ã ãã§ãããžãã¹ã®æææ±ºå®ã¯å¯èœã ãããããšKTæ°ã
2ã€ç®ã®ã¡ãªããã¯ãã¬ããã³ã¹ãã ãKTæ°ã¯ããããŒã¿ããã¹ãŠå®ãå¿ èŠã¯ãªãããææããŠããããŒã¿ãææ¡ããå¿ èŠã¯ãããããŒã¿ãçè§£ããŠä¿è·ãããµã€ã¯ã«ãå¿ èŠããšè¿°ã¹ãããããŒã¿ã¯ã©ãŠãã¯ãããããµã€ã¯ã«ãå®çŸããæ©èœãåããŠããã
3ã€ç®ã®ã¡ãªããã¯ãã¢ã¯ã·ã§ã³ãã ãããŒã¿ã¯ã©ãŠãã¯ã補åéçºããŒã ãããŒã¿ãµã€ãšã³ãã£ã¹ããããžãã¹ãŠãŒã¶ãŒãã¢ããªã¹ããªã©ã瀟å ã®ããŸããŸãªç«å Žã®äººãå ±éã®ããŒã¿ã掻çšããŠãã³ã©ãã¬ãŒã·ã§ã³ããããšãå¯èœã«ããã
ããŒã¿å ±æã«ãŸã€ããã ããæé€ããSNOWGRID
KTæ°ã¯ããããŒã¿ã¯ã©ãŠãã¯ãã©ãããã©ãŒã ãšã³ã³ãã³ãããæ§æãããããããããæäŸããã®ã¯ããã©ãããã©ãŒã ã®Snowflakeãã³ã³ãã³ãã¯ãããŒã¿ãææããŠããããŸããŸãªäººã«æäŸããŠãããããããšè¿°ã¹ãã
ããŒã¿ã¯ã©ãŠãã®ãã©ãããã©ãŒã ã«å¿ èŠãªèŠçŽ ãšããŠãKTæ°ã¯ãã©ããªã¯ãŒã¯ããŒããè¿ éã«åŠçããããæ±ãããšããã«åãã ãã§ããããæ¬åœã«å€§åãªããšã«ã€ãªãããã®3ç¹ãæããSnowflakeã¯ããããåããŠãããšããã
KTæ°ã¯ãSnowflakeã®æè¡çãªç¹åŸŽãšããŠãã䌞瞮æ§ã®ãããšã³ãžã³ããã€ã³ããªãžã§ã³ããªã€ã³ãã©ã¹ãã©ã¯ãã£ããSNOWGRIDããæããããããã®ãã¡ããç¹ã«ç¥ã£ãŠãããããã®ãSNOWGRIDããšãKTæ°ã¯è©±ãããSNOWGRIDã¯ããŒã¿ãšã¹ãã¬ãŒãžãåããŠæã€ããšã§ãETLã䜿ããã«ããŒã¿å ±æãå®çŸãããã¯ãããžãŒã ãããŒã¿ã®ã³ããŒãè¡ãããªãã®ã§é å»¶ããªããããŒã¿ã®ç§»åã»ã³ããŒã»çµ±åã®ã³ã¹ããäžèŠã ãè€æ°ã®DWHãåããããããå¥ãªDWHã®åœ±é¿ãåããªããšãããã¹ãã¬ãŒãžã倿°ã®ã¢ã¯ã»ã¹ãå¯èœãªããããªãœãŒã¹ã®ç«¶åãçºçããªãããã ã
å ããŠãKTæ°ã¯ãSNOWGRIDã䜿ãã°ããã¥ãŒãã³ã°ãã»ãã¥ãªãã£ã«ãããæéãçãããšãã§ããããŸããAWSãMicrosoft AzureãGoogle Cloud Platformã®åãªãŒãžã§ã³ããµããŒãããŠããã®ã§ãã©ã®ã¯ã©ãŠãã§ãåãç°å¢ãå©çšã§ããä»ã®ã¯ã©ãŠãã®ãŠãŒã¶ãŒãšããŒã¿å ±æãå¯èœããšãSNOWGRIDã«ãã£ãŠåŸãããã¡ãªããã説æããã
æåŸã«ãKTæ°ã¯ãããŒã¿ã¯ã©ãŠããä»ããããŒã¿å ±æã®ã¡ãªãããšããŠãããŒã¿ã転éããããšãªããèªç€Ÿã®ããŒã¿ãå®å šãªåœ¢ã§çžæã«åç §ãããããšãã§ããç¹ã玹ä»ããããã®ãããSnowflakeããŒã¿ããŒã±ãããã¬ã€ã¹ã§ãããŒã¿ã売ã£ãŠããžãã¹ãããããšãå¯èœã«ãªããæ¢ã«16以äžã®ã«ããŽãªãŒã«ãããŠã150以äžã®ãããã€ããŒãããŒã±ãããã¬ã€ã¹ã«åå ããŠãããæ¥æ¬ããããŠã§ã¶ãŒãã¥ãŒã¹ãåå ããŠããããã ããããŠãKTæ°ã¯ãæ¥æ¬äŒæ¥ãããŒã¿ã¯ã©ãŠãã®æ³¢ã«ä¹ãé ããªãã§ã»ãããããŒã¿ãå ±æããªãããããžãã¹ã瀟äŒè²¢ç®ãå éããŠã»ããããšåŒã³æããŠããã



