ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã®ãƒ‡ãƒ¼ã‚¿åˆ†æžåŸºç›¤ã®ç¾çŠ¶ — ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°ã“ã‚“ã«ã¡ã¯ã€ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã®å°å®¤ (id:hogelog) ã§ã™ã€‚ 今回ã¯ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã«ãŠã‘るデータ分æžåŸºç›¤ã®ç¾çŠ¶ã«ã¤ã„ã¦ã”å ±å‘Šã•ã›ã¦ã„ãŸã ãã¾ã™ã€‚ 三行ã¾ã¨ã‚ å¿™ã—ã„人ã®ãŸã‚ã«å…ˆã«çµè«–を書ã㨠bricolage 㨠embulk 㧠Redshift ã«é›†ã‚㦠re:dash ã§åˆ†æž ã§ã™ã€‚ データåŽé›† データåŽé›†ã¯ bricolage ã®ã‚¸ãƒ§ãƒ–ãƒãƒƒãƒˆæ©Ÿæ§‹ã‚’用ã„㦠bricolage ã®å„種ジョブや embulk を連æºã•ã›ã€Redshift ã«ãƒ‡ãƒ¼ã‚¿ã‚’å–り込んã§ã„ã¾ã™ã€‚ å‚考ã¾ã§ã« https://github.com/hogelog/dwh-example ã«ç°¡å˜ãªæ§‹æˆä¾‹ã‚’準備ã—ã¾ã—ãŸã€‚ MySQL → Redshift ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚° http://www.mwed.jp/ ã®ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ã¯ MySQL を利用ã—ã¦ã„ã¾ã™ã€‚ MySQL ã‹ã‚‰ Redshi
Embulk ã‚’ã¤ã‹ã£ã¦æ¤œç´¢ãƒã‚°ã‚’抽出ã™ã‚‹ — ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°
ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã§æ—¥ã€…è¡Œã‚ã‚Œã¦ã„る社内勉強会・èªæ›¸ä¼š — ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°
ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã¯AWSã§å‹•ã„ã¦ã„ã¾ã™ — ã¿ã‚“ãªã®ã‚¦ã‚§ãƒ‡ã‚£ãƒ³ã‚°ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒªãƒ³ã‚°ãƒ–ãƒã‚°
{{#tags}}- {{label}}
{{/tags}}