Data Engineering Study #7ãRedshiftææ°ã¢ããããŒããšæŽ»çšäºäŸã
ã€ãã³ãå 容
æ¬ã€ãã³ãã¯ãInfra Study Meetup ãéå¶ãã Forkwell ãšãåæåºç€åãããŒã¿çµ±åSaaSãtroccoãã®éçºã»éå¶ãè¡ã primeNumber ã«ããå ±å¬ã€ãã³ãã§ããããŒã¿åæã«ç²Ÿéããè¬åž«ããæãããããŒã¿åæåºç€ã®ããããŸã§ããšãããããããåŠã¶ããšãè¶£æšãšããŠéå¬ããããŸãã
éå¬å 容
æŠèŠ
æ¬ã€ãã³ãã§ã¯ãããããæ°ïŒ@yuzutas0ïŒã«ã¢ãã¬ãŒã¿ãŒãäŸé Œããè€æ°åã«ããã£ãŠãååããŒãã«æ²¿ã£ãå 容ã§ååéã§ã掻èºãããŠãããšã³ãžãã¢ïŒç ç©¶è ã«è¬æŒããã ããŸãã
éå¬èæ¯
Forkwell ããã®ã³ã¡ã³ã
æ¬ã€ãã³ãã¯ãInfra Study Meetup ã«æ³šç®ããŠããã ãã primeNumber ããŸããã®ã声ããã§å®çŸããã€ãã³ãã§ããInfra Study Meetup ãšã¯äž»å¬ããå£äœãæ±ãããŒããç°ãªãããšãããå¥ã·ãªãŒãºãšããŠç«ã¡äžããŸãããInfra Study åå è ãšå ±ã«åŸãã€ãã³ãããŠããŠãç¶æ¿ããããŒã¿åæé åã§ãåŠã³ã®å ŽãäœããŸãã
æ¬å®¶ Infra Study ã«ãåå ããã ããæ¹ã¯ãã¡ãããããŒã¿åæã«é¢å¿ã®ããæ¹ãªãã©ãªãã§ãåå å¯èœã§ãããšã³ãžãã¢ãªã³ã°ãšå¯æ¥ã«é¢ããããŒã¿åæé åã«ã€ããŠæ¥œããåŠãã§ããã ããŸããã幞ãã§ãã
Forkwell äºæ¥è²¬ä»»è èµ€å·
primeNumber ããã®ã³ã¡ã³ã
åŒç€Ÿã¯ããŒã¿åæåºç€åãã®ç·åæ¯æŽãµãŒãã¹ãtroccoããéå¶ããŠããã®ã§ããããã®äžã§ãã©ãããåæåºç€ãäœã£ãŠããã°ããã®ãïŒããšããã質åããã䌺ããŸãããã®ãããªæ¹åãã«äœãæçãªæ å ±ããæäŸã§ããå Žã¯ãªãããšèããæã«ãæ¬ã€ãã³ãã®éå¬ãæãã€ããŸããã
ãããªã¿ã€ãã³ã°ã§ããInfra Study Meetupããšããåé¿ã倧ããã€ãã³ããããã®ãèŠã€ãããããŒã¿åæåºç€ãçãäœããŸããããšã声ããããæããéå¬ã«è³ããŸããã
ããããåæåºç€ãäœãããšãããŠããæ¹ããçŸåšéçšäžã®åºç€ã®æ¹åã¢ã€ãã¢ãæ¢ããŠããæ¹ã«ãæçãªå Žã«åºæ¥ãã°ãšæã£ãŠãããŸãã
primeNumber åç· åœ¹å·è¡åœ¹å¡CPO å°æå¯å
ãããªãšã³ãžãã¢ã«ãããã
- ããŒã¿åæã«é¢ããäºäŸãç¥ãããæ¹
- èªç€Ÿå ã«ããŒã¿åæåºç€ãäœãããšæ€èšäžã®æ¹
- èªç€Ÿã®ããŒã¿åæåºç€ãããå¹ççã«ããããšèããŠããæ¹
- ããŒã¿åæé åã«å¹ ãåºããŠã¿ãããœãããŠã§ã¢ãšã³ãžãã¢ã»ã€ã³ãã©ãšã³ãžãã¢
ããã°ã©ã 第7åãRedshiftææ°ã¢ããããŒã&äºäŸã
ãããŸã§Data Engineering Studyã§ã¯ã第1åã§ã¯DWHãšBIããŒã«ã®éžã³æ¹ãã第5åã第6åã§ã¯ããããBigQueryãšSnowflakeã®ç¹éåã宿œããŠãŸãããŸããã
ä»åã¯DWHç¹éåã®ç¬¬3匟ãšããŠãAWSã®DWHã§ãããRedshiftãã顿ã«åãäžããFederated QueryãRA3ã€ã³ã¹ã¿ã³ã¹ãªã©ã®ææ°ã¢ããããŒãæ
å ±ãçã蟌ã¿ãªãããAWSã®ãœãªã¥ãŒã·ã§ã³ã¢ãŒããã¯ãã®æ¹ããåŒã³ããŠæ·±å ããããŠãããŸãã
å匷äŒã®ç¬¬1éšã§ã¯ãäž»ã«åå¿è
ãäžçŽè
ãã¿ãŒã²ããã«ãRedshiftã®çãŸããèæ¯ãæ©èœãªã©ã®æŠèŠããè¬æŒããã ããŸãã
第2éšã§ã¯ææ°ã¢ããããŒããäžå¿ãšãããã¢ãè¡ããŸããè¿å¹Žã®Redshiftã¯ã¢ããããŒããå€ããé²åããRedshiftã®æ©èœããç»é¢ãèŠãªãããã£ããã¢ããããŠãããŸãã
第3éšã§ã¯ã10幎æŠããããŒã¿åæå
¥éãã®èè
ã§ãããã¯ãã¯ãããæ ªåŒäŒç€Ÿã®éæšå³°éæ°ããåŒã³ãããã¯ãã¯ããããã®åæåºç€ã«ãããRedshift掻çšäºäŸãã話ãããã ããŸãã
åºèª¿è¬æŒãAmazon Redshift ã®é²åã®æŽå²ãšããããã
ã倧è çŽå¹³ æ°ïŒ@jostandardïŒ
Amazon Web Services Japan K.K.
Senior Solutions Architect, Analytics
âçºè¡šå 容
Amazon Redshift 㯠AWS ã®ãµãŒãã¹ã®äžã§ãé²åã®ã¹ããŒããéããããŒãžãåã®ããŒã¿ãŠã§ã¢ããŠã¹ãµãŒãã¹ã§ãã> AWS ã¯ã©ãŠãäžã®ããŒã¿ãŠã§ã¢ããŠã¹ããªãã¬ãŒã·ã§ãã«ããŒã¿ããŒã¹ãããã³ããŒã¿ã¬ã€ã¯ã«ããå€§èŠæš¡ã®æ§é åããŒã¿ãšåæ§é åããŒã¿ã«å¯ŸããŠæšæºç㪠SQL ã䜿çšããŠåæã¯ãšãªãå®è¡ã§ããŸãããããŸã§ Redshift ãç»å Žä»¥æ¥ã©ã®ããã«é²åãéããŠãããæ¯ãè¿ããªãããææ°ã®ã¢ããããŒãæ å ±ããäŒãããŸãã
åºèª¿è¬æŒ2ã宿Œ Amazon Redshift ææ°æ©èœã
ãå¹³é å€§èŒ æ°
Amazon Web Services Japan K.K.
Solutions Architect, Analytics
âçºè¡šå 容
Amazon Redshiftã¯ããã1ã2幎ã«éã£ãŠãå€ãã®æ©èœã远å ããããŸããŸã䜿ãããããã®ã«ãªã£ãŠããŸããããã§ã¯ã¯ãšãªã®åæå®è¡æ§èœãé£èºçã«åäžãããconcurrency scalingãåæ§é åããŒã¿ãæ±ããæ°ããããŒã¿åSUPERãæ¥åã·ã¹ãã äžã®ææ°ããŒã¿ãçŽæ¥ã¯ãšãªã§ããFederated QueryãDWHéã§ããŒã¿ãå ±æããData Sharingãšãã£ããAmazon Redshiftã®ææ°æ©èœãããã¢ã亀ããŠã玹ä»ããŸãã
äºäŸè¬æŒããªãã¯ãã¯ãããã¯RedshiftãããŒã¿åºç€ã«éžã³ç¶ããã®ãã
ãéæš å³°é æ°
ã¯ãã¯ãããæ ªåŒäŒç€Ÿ æè¡éš
âçºè¡šå 容
ã¯ãã¯ãããã¯2016幎ã«ããŒã¿åºç€ãæ§ç¯ããŠä»¥æ¥ãåšèŸºæè¡ã¯ãªãã¡ã€ã³ãã€ã€ããäžè²«ããŠRedshiftã䜿ãç¶ããŠããŸããããã®ã»ãã·ã§ã³ã§ã¯ãããããããŒã¿åºç€ãšã¯äœããããŒã¿åºç€ãèšèšãããšãã¯äœãèããã¹ããªã®ãããããŠãã®åºæºã«ç §ãããŠæã ããªãRedshiftãéžã¶ã®ãã«ã€ããŠã話ãããŸãã
ã¿ã€ã ã¹ã±ãžã¥ãŒã«ïŒç®å®ïŒ
| æé | å 容 |
|---|---|
| 19:30ã | åžäŒããæšæ¶ïŒ10åïŒ |
| 19:40ã | åºèª¿è¬æŒ1ïŒ20åïŒ å€§è çŽå¹³æ°ãAmazon Redshift ã®é²åã®æŽå²ãšããããã |
| 20:00ã | 質çå¿çïŒ10åïŒ |
| 20:10ã | äŒæ© / ã¹ãã³ãµãŒCM Forkwell 鿬 æ¹§æ° |
| 20:15ã | åºèª¿è¬æŒ2ïŒ20åïŒ å¹³é å€§èŒæ°ã宿Œ Amazon Redshift ææ°æ©èœã |
| 20:35ã | 質çå¿çïŒ10åïŒ |
| 20:45ã | ã¹ãã³ãµãŒLTïŒ5åïŒ primeNumber å°æ å¯åãããŒã¿ãšã³ãžãã¢ã®ããã®ãã¥ãŒã¹ãŸãšã2021/2-3æå·ã |
| 20:50ã | äŒæ©ïŒ5åïŒ |
| 20:55ã | äºäŸè¬æŒïŒ20åïŒ éæš å³°éæ°ããªãã¯ãã¯ãããã¯RedshiftãããŒã¿åºç€ã«éžã³ç¶ããã®ãã |
| 21:15ã | 質çå¿çïŒ10åïŒ |
| 21:25ã | ã¢ãã¿ãŒããŒã¯ïŒ15åãïŒ |
| 21:45 | å®å šçµäº |
â» ã¿ã€ã ã¹ã±ãžã¥ãŒã«ã¯ç®å®ã§ããå®å
šè§£æ£21:45ãŸã§ã®éã§ãããåå è
ã«ãæºè¶³ããã ãã圢ã§åã³ã³ãã³ãæéã調æŽãããå ŽåãããããŸãã
â» ããã°ã©ã ã¯å€æŽãšãªãå¯èœæ§ããããŸããéæãã¡ãã§æŽæ°ããããŸãã
ãããŸã§ã®å匷äŒã§æ±ãããŒããšã¢ãŒã«ã€ãåç»
- 2020/07/15ïŒæ°ŽïŒïœç¬¬1åãã¢ãã³ãªDWH/BIããŒã«ã®éžã³æ¹ãšãå®éã®éçšäºäŸã
- 2020/08/19ïŒæ°ŽïŒïœç¬¬2åãããŒã¿åéåºç€ãšããŒã¿æŽåã®ãããŸã§ãšããããã
- 2020/09/16ïŒæ°ŽïŒïœç¬¬3åãåæåºç€ãããŸãçµç¹ã«æµžéãããæ¹æ³ã
- 2020/11/04ïŒæ°ŽïŒïœç¬¬4åãããŒã¿åæåºç€ã®é害察å¿äºäŸLTç¥ãã
- 2020/12/02ïŒæ°ŽïŒïœç¬¬5åãåã®Snowflake Deep Dive / åœå äºäŸã»ä»DWHãšã®æ¯èŒã
- 2021/02/03ïŒæ°ŽïŒïœç¬¬6åãæ¹ããŠåŠã¶ãBigQuery培åºå ¥éã
åå æ¹æ³
ä»åã®ãªã³ã©ã€ã³å匷äŒã¯ YouTube Live ã䜿çšããŠã©ã€ãé
ä¿¡ããããŸãã
ãŸããã³ã¡ã³ããææ³ã¯ Twitterãè¬æŒå
容ã«é¢ãã質å㯠Koibumi ãžãé¡ãããããŸãã
äžèšãåçš®URLãããåå ãã ãããŸãïŒ
âã€ãã³ãèŠèŽçš YouTube Live URL
- https://youtu.be/j7t_h23WNN8
â質çå¿ççš Koibumi URL
- https://koibu.me/events/18/
âTweetãªã³ã¯
- https://twitter.com/intent/tweet?hashtags=DataEngineeringStudy
ã©ã€ãé
ä¿¡çµäºåŸãã¢ãŒã«ã€ãåç»ã®å
¬éãäºå®ããŠãããŸãã
åœæ¥ã®é嬿éã«ã©ã€ãåå ã§ããªãæ¹ãããã¡ãã®ããŒãžããåå ç³èŸŒã¿ã®äžãã¢ãŒã«ã€ãåç»ããèŠèŽããã ããŸãã
ãªããTwitterã¿ã€ã ã©ã€ã³ãšé£åãããªã¢ã«ã¿ã€ã ãªã€ãã³ãåå äœéšãéèŠãããããYouTube Liveã®è¿œãããåçã¯ã§ããªãèšå®ãšãªããŸãããšããäºæ¿ãã ãããŸãã é ä¿¡äžã®ããã°ã©ã ããã®èŠèŽããããã¯ã©ã€ãé ä¿¡çµäºæ°æéåŸããåçå¯èœã«ãªãã¢ãŒã«ã€ãåç»ããèŠèŽãã ããã
çæäºé
- ForkwellãprimeNumber ã®å®£äŒããããŠããã ãæéãããããŸããäºããäºæ¿ãã ããã
- ITæè¡è ã®æ¹ã察象ãšããã€ãã³ãã®ãããéãšã³ãžãã¢ã®æ¹ã®ãåå ããªãã³ã«åæ¥ã«å±ããæ¹ã®åœã€ãã³ãå ã§ã®ãªã¯ã«ãŒãã£ã³ã°æŽ»åã«ã€ããŸããŠãé æ ®ããã ããŠãããŸãã
- ã€ãã³ãã®é¢šæ¯ããForkwellã¡ãã£ã¢äžã®èšäºïŒã€ãã³ãã¬ããŒãïŒã«æ²èŒããããšãããããŸããæ²èŒãåžæãããªãæ¹ã¯ãåœæ¥Zoomãã£ãããŸãã¯ã€ãã³ãããŒãžåãåãããã©ãŒã ãããæ²èŒåžæãããªãæšããäŒããã ããã
- ã€ãã³ãåå æã«ãå ¥åããã ããæ å ±ã¯ã次ã®ãã©ã€ãã·ãŒããªã·ãŒã«åºã¥ããprimeNumber ã®ã¿ã§é©åã«æ±ããŸãã https://primenumber.co.jp/privacy/
ãŸãããåå è ã®æ¹ã ãæå€§é楜ããã§é ãããããéå¶ãµã€ãã§åå ã«ãµãããããªããšå€æãããŠé ããæ¹ã«ã€ããŠã¯ãã€ãã³ãäžã§ããããšãéåžããé¡ãããããšãããããŸãã
- ä¿éºã宿ããããã¯ãŒã¯ããžãã¹ã®å§èªãç®çãšèŠãããæ¹
- ãã®ä»éå¶ãµã€ãã§åå ãäžé©åã ãšå€æããæ¹ èª ã«æãå ¥ããŸãããããããããäºæ¿ãã ãããŸãã
äž»å¬ã»åå
äž»å¬ïŒã³ãã¥ããã£æ¯æŽåè³
ãæé·ãç¶ãããšã³ãžãã¢ãæ¯æŽããããµãŒãã¹ãéå¶ãã Forkwell
åæåºç€åãããŒã¿çµ±åSaaSãtroccoãã®éçºã»éå¶ãè¡ã primeNumber
åŸæŽ
å€©ç¥æŸé屿§ã«ã©ã€ãé
信代è¡ãšããŠååããã ããŠãããŸãã
å€©ç¥æŸéå±ã¯ã©ã€ãé
ä¿¡ãåºããããšã§ãæ©äŒæ Œå·®ããªãããããšãããã·ã§ã³ãšããã©ã€ãé
ä¿¡ãŠãããã§ãã
ã³ãã¥ããã£ã€ãã³ããå¢ãç¶ããäžãã³ã³ãã³ããç±æãã人ã«å±ããããã«æŽ»åããŠããŸãã
泚æäºé
â» ãã¡ãã®ã€ãã³ãæ å ±ã¯ãå€éšãµã€ãããååŸããæ å ±ãæ²èŒããŠããŸãã
â» æ²èŒã¿ã€ãã³ã°ãæŽæ°é »åºŠã«ãã£ãŠã¯ãæ å ±æäŸå ããŒãžã®å 容ãšå·®ç°ãçºçããŸãã®ã§äºããäºæ¿ãã ããã
â» ææ°æ å ±ã®ç¢ºèªãåå ç³èŸŒæç¶ããã€ãã³ãã«é¢ãããåãåããçã¯æ å ±æäŸå ããŒãžã«ãŠãé¡ãããŸãã

ãåãåãã
é¢é£ããã€ãã³ã

ãæ±äº¬ããBtoBããŒã±ãã£ã³ã°ã®å®ç³ãã®å眪ãïœãªãæœçãåããŠãææãåºãªãã®ãïŒïœ
2026/07/10(é) éå¬
æ¥æ¬äžã®è±ç«å€§äŒã£ãŠã©ãïŒããŒã¿ã§æ±ºããŠã¿ãããèŠãã ãåå OKã»è±ç«å¥œãæè¿ãð
2026/07/26(æ¥) éå¬
ãç¡æã仮説æ€å®ããMLãŸã§ïŒå šäœåãã€ãã¿åæåå¿è ã®âã€ãŸãããã€ã³ãâãè§£æ¶ãããŒã¿ãµã€ãšã³ã¹è¶ å ¥éã
2026/07/26(æ¥) éå¬
LLM Opsã®å®è·µ SaaSã«çµã¿èŸŒãã AIæ©èœã®å質ã»ã³ã¹ãã»æ¹åãµã€ã¯ã«
2026/07/28(ç«) éå¬
ã7/8(æ°Ž)13:00ïœãAIæä»£ã ããããèŠçŽããããææã«ã€ãªããSEOã®åºæ¬ã»ãããŒãSEOã»ãããŒã
2026/07/08(æ°Ž) éå¬- TOP
- ã€ãã³ã
- Data Engineering Study #7ãRedshiftææ°ã¢ããããŒããšæŽ»çšäºäŸã


