Data Engineering Study #23 Data orchestration ç¹é
ã€ãã³ãå 容
éå»ã® Data Engineering Study ã®ã¢ãŒã«ã€ãã¯ãã¡ããããèŠèŽããã ããŸãã
éå¬å 容
æŠèŠ
æ¬ã€ãã³ãã¯ãInfra Study Meetup ãéå¶ãã Forkwell ãšãåæåºç€åãããŒã¿çµ±åSaaSãtroccoãã®éçºã»éå¶ãè¡ã primeNumber ã«ããå
±å¬ã€ãã³ãã§ããããŒã¿åæã«ç²Ÿéããè¬åž«ããæãããããŒã¿åæåºç€ã®ããããŸã§ããšãããããããåŠã¶ããšãè¶£æšãšããŠéå¬ããããŸãã
è€æ°åã«ããã£ãŠãååããŒãã«æ²¿ã£ãå
容ã§ååéã§ã掻èºãããŠãããšã³ãžãã¢ïŒç ç©¶è
ã«è¬æŒããã ããŸãã
質çå¿çã®æéã«ã¯ãããããæ°ïŒ@yuzutas0ïŒã«ããåå ããã ããŸãã
ããã°ã©ã 第23åãData orchestrationç¹éã
ããŒã¿åæã®å¿
èŠæ§ããŸããŸãé«ãŸãäžã§ãâãµã€ãåããããŒã¿ã«ãšããããŠãªããªãããžãã¹ã®åã«å€ããããšãã§ããŠããªãâãšããäŒæ¥ã¯å€ãã®ã§ã¯ãªãã§ããããã
ããã§Data Engineering Study第23åã§ã¯ãããŒã¿çµ±åã®ããã®ãData orchestrationããéããŠããŒã¿æŽ»çšã®çŸåšåœ¢ãèããŸãã
åºèª¿è¬æŒãã¯ãŒã¯ãããŒãªãŒã±ã¹ãã¬ãŒã·ã§ã³å ¥éã
ãé·æ± äºæ æ°ïŒ@nsakki55ïŒ
æ ªåŒäŒç€ŸCyberAgent AIäºæ¥æ¬éš Dynalyst ããŒã¿ãµã€ãšã³ãã£ã¹ããããŒãžã£ãŒ
âçºè¡šå 容
ããŒã¿ãã€ãã©ã€ã³ãæ©æ¢°åŠç¿ãã€ãã©ã€ã³ãªã©ã®ãããŒã¿é åã§ã®ã¯ãŒã¯ãããŒãªãŒã±ã¹ãã¬ãŒã·ã§ã³ãžã®æ³šç®ãè¿å¹Žé«ãŸã£ãŠããŸãããªãä»ãã®ãã¬ã³ããããŠãã®ããäœãè¡ãã°ããã®ããªã©ãã¯ãŒã¯ãããŒãªãŒã±ã¹ãã¬ãŒã·ã§ã³ã®å ·äœã®å 容ã«çç®ããŸãã
æ¬çºè¡šã§ã¯ä»¥äžã®å 容ã«ã€ããŠã話ãããŸãã
- ã¯ãŒã¯ãããŒãªãŒã±ã¹ãã¬ãŒã·ã§ã³ãšã¯äœãïŒ
- Airflow/Digdag/Argo/Prefect/Dagster/StepFunctionsã®6ã€ã®ã¯ãŒã¯ãããŒãªã±ã¹ãã¬ãŒã·ã§ã³ããŒã«ãæ¯èŒ
- ã€ã³ã¿ãŒãããåºåé ä¿¡ãããã¯ãDynalystã§ã®ã¯ãŒã¯ãããŒéçšç¥èŠã®ç޹ä»å¯Ÿè±¡è ãšããŠã¯ããŒã¿ã»æ©æ¢°åŠç¿åºç€ã®éçºã«é¢ãã以äžã®äººãšãªã£ãŠããŸãã
- ããããã¯ãŒã¯ãããŒããŒã«ã®å°å ¥ãæ€èšããŠã人
- æ¢ã«ã¯ãŒã¯ãããŒéçšãè¡ã£ãŠããŠèª²é¡æãæããŠã人
LT1ãããŒã¿ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ããŒã«Dagsterã®ç޹ä»ã
å²©åŽ æ æ°ïŒ@sista05ïŒ
æ ªåŒäŒç€ŸDataMarket 代衚åç· åœ¹
âçºè¡šå 容
ããŒã¿ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ãšã¯ãäŒæ¥å šäœã®ããŒã¿èšå®ã管çãããã³èª¿æŽãèªååããããšãæå³ããŸãã
ãããŸã§ããŒã¿ãšã³ãžãã¢ãªã³ã°ã§ã¯ãäž»ã«ã·ã¹ãã æ§ç¯ãããŒã¿æŽçã«çŠç¹ãåœãŠãããŠããŸããã ããããäžã®äžã§æ¥éã«ããŒã¿å©æŽ»çšãé²ãäžã§ãäŒæ¥ã»éšééã»æ¥çš®ããšã§ããŒã¿æçåºŠãææ³ã®éããç®ç«ã€ããã«ãªã£ãŠããŠãããçè§£ã®ã®ã£ãããåããããã®å ±éã®åå°ãäœãããšãæ°ãã課é¡ãšãªã£ãŠããŸãã
Dagsterã¯ãããŒã¿ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ã®å®çŸã«åœãã£ãŠãèªèº«ãäŒæ¥ã®ããŒã¿ã¢ã»ããã衚çŸã管çããäžã€ã®ãã©ãããã©ãŒã ã«ãªãããšãç®æããŠããŸãã ãã®ç®æšãéæããããã«ãDagsterãæ¡çšããŠããã¢ãããŒããšãã®å°æ¥æ§ã«ã€ããŠè©±ãããããšèããŠããŸãã
LT2ãdbtãDagster Cloudã§ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ããã
äžæ ç©ºç¥ æ°ïŒ@contradiction29ïŒ
æ ªåŒäŒç€ŸAlgoage ããŒã¿ãšã³ãžãã¢
âçºè¡šå 容
ããŒã¿ãšã³ãžãã¢ãªã³ã°ã®å Žé¢ã§ä»ãå§åçãªäººæ°ãèªãdbtãããããdbtããªãŒã±ã¹ãã¬ãŒã·ã§ã³ããéã®ãã¹ããã©ã¯ãã£ã¹ã¯ç¢ºç«ãããŠããããããŸããŸãªããŒã«ã§ã®ãªãŒã±ã¹ãã¬ãŒã·ã§ã³æ¹æ³ãææ¡ãããŠããŸãã
æ¬çºè¡šã§ã¯ãå®éã«å°å ¥ããŠæ°ã¶æéçšããçµéšãããšã«ãdbtããªãŒã±ã¹ãã¬ãŒã·ã§ã³ããéã®äžã€ã®ãã©ã¯ãã£ã¹ãšããŠãDagster Cloudããå©çšããå Žåã®ã¡ãªãããšãã¡ãªãããã話ãããŸããDagsterã¯éçºè äœéšãéèŠããæ°äžä»£ã®ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ããŒã«ãšããŠãAirflowã®ä»£æ¿ææ®µãšãªãåŸãããã³ã·ã£ã«ãç§ããŠããŸãã
æ¬çºè¡šãdbtããªãŒã±ã¹ãã¬ãŒã·ã§ã³ããææ®µã®äžã€ãšããŠDagster Cloudãèæ ®ãããã£ããã«ãªãã°å¹žãã§ã
ã¿ã€ã ã¹ã±ãžã¥ãŒã«ïŒç®å®ïŒ
| æé | å 容 |
|---|---|
| 18:00 | ãªãŒããã³ã°ïŒ5åïŒ |
| 18:05 | åºèª¿è¬æŒïŒ40åïŒ é·æ± äºææ°ãã¯ãŒã¯ãããŒãªãŒã±ã¹ãã¬ãŒã·ã§ã³å ¥éã |
| 18:45 | 質çå¿çïŒ15åïŒ |
| 19:00 | å ±å¬LT1ïŒ5åïŒForkwell |
| 19:05 | LT1ïŒ15åïŒ å²©åŽ æ æ°ãããŒã¿ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ããŒã«Dagsterã®ç޹ä»ã |
| 19:20 | LT2ïŒ15åïŒ äžæ ç©ºç¥ æ°ãdbtãDagster Cloudã§ãªãŒã±ã¹ãã¬ãŒã·ã§ã³ããã |
| 19:35 | 質çå¿çïŒ15åïŒ |
| 19:50 | å ±å¬LT2ïŒ5åïŒprimeNumber |
| 19:55 | ã¢ãã¿ãŒããŒã¯ïŒ15åïŒ |
| 20:10 | ã¯ããŒãžã³ã°ïŒ5åïŒ |
| 20:15 | å®å šçµäº |
â» ã¿ã€ã ã¹ã±ãžã¥ãŒã«ã¯ç®å®ã§ããå®å
šè§£æ£20:15ãŸã§ã®éã§ãããåå è
ã«ãæºè¶³ããã ãã圢ã§åã³ã³ãã³ãæéã調æŽãããå ŽåãããããŸãã
â» ããã°ã©ã ã¯å€æŽãšãªãå¯èœæ§ããããŸããéæãã¡ãã§æŽæ°ããããŸãã
éå¬èæ¯
Forkwell ããã®ã³ã¡ã³ã
æ¬ã€ãã³ãã¯ãInfra Study Meetup ã«æ³šç®ããŠããã ãã primeNumber ããŸããã®ã声ããã§å®çŸããã€ãã³ãã§ããInfra Study Meetup ãšã¯äž»å¬ããå£äœãæ±ãããŒããç°ãªãããšãããå¥ã·ãªãŒãºãšããŠç«ã¡äžããŸãããInfra Study åå è ãšå ±ã«åŸãã€ãã³ãããŠããŠãç¶æ¿ããããŒã¿åæé åã§ãåŠã³ã®å ŽãäœããŸãã
æ¬å®¶ Infra Study ã«ãåå ããã ããæ¹ã¯ãã¡ãããããŒã¿åæã«é¢å¿ã®ããæ¹ãªãã©ãªãã§ãåå å¯èœã§ãããšã³ãžãã¢ãªã³ã°ãšå¯æ¥ã«é¢ããããŒã¿åæé åã«ã€ããŠæ¥œããåŠãã§ããã ããŸããã幞ãã§ãã
primeNumber ããã®ã³ã¡ã³ã
åŒç€Ÿã¯ããŒã¿åæåºç€åãã®ç·åæ¯æŽãµãŒãã¹ãtroccoããéå¶ããŠããã®ã§ããããã®äžã§ãã©ãããåæåºç€ãäœã£ãŠããã°ããã®ãïŒããšããã質åããã䌺ããŸãããã®ãããªæ¹åãã«äœãæçãªæ å ±ããæäŸã§ããå Žã¯ãªãããšèããæã«ãæ¬ã€ãã³ãã®éå¬ãæãã€ããŸããã
ãããªã¿ã€ãã³ã°ã§ããInfra Study Meetupããšããåé¿ã倧ããã€ãã³ããããã®ãèŠã€ãããããŒã¿åæåºç€ãçãäœããŸããããšã声ããããæããéå¬ã«è³ããŸããã
ããããåæåºç€ãäœãããšãããŠããæ¹ããçŸåšéçšäžã®åºç€ã®æ¹åã¢ã€ãã¢ãæ¢ããŠããæ¹ã«ãæçãªå Žã«åºæ¥ãã°ãšæã£ãŠãããŸãã
ãããŸã§ã®å匷äŒã§æ±ã£ãããŒããšã¢ãŒã«ã€ãåç»
- 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培åºå ¥éã
- 2021/04/06ïŒç«ïŒïœç¬¬7åãRedshiftææ°ã¢ããããŒããšæŽ»çšäºäŸã
- 2021/06/02ïŒæ°ŽïŒïœç¬¬8åãBIããŒã«ç¹éïŒOSSã»åçšã®äžæã䜿ãåãã
- 2021/08/03ïŒç«ïŒïœç¬¬9åãäŒæ¥èŠæš¡å¥ããŒã¿ãšã³ãžãã¢çµç¹ã®äœãæ¹ã
- 2021/10/06ïŒæ°ŽïŒïœç¬¬10åãçéBIããŒã«ç¹é Tableau / PowerBI / GoogleããŒã¿ããŒã¿ã«ã
- 2021/12/13ïŒæïŒïœç¬¬11åã6瀟ã®ããŒã¿ãšã³ãžãã¢ãæ¯ãè¿ã2021ã
- 2022/02/09ïŒæ°ŽïŒïœç¬¬12åããšã³ãžãã¢ã®ããã®ãããŒã¿å¯èŠåãå ¥éã
- 2022/04/06ïŒæ°ŽïŒïœç¬¬13åãELTã»ããŒã¿ã¢ããªã³ã°ããŒã«ç¹éåã
- 2022/06/08ïŒæ°ŽïŒïœç¬¬14åãModern Data Stackç¹éã
- 2022/08/03ïŒæ°ŽïŒïœç¬¬15åãReverse ETL ç¹éåã
- 2022/10/19ïŒæ°ŽïŒïœç¬¬16åãããŒã¿ã«ã¿ãã°å ¥éã
- 2022/12/14ïŒæ°ŽïŒïœç¬¬17åã6瀟ã®ããŒã¿ãšã³ãžãã¢ãæ¯ãè¿ã2022ã
- 2023/02/15ïŒæ°ŽïŒïœç¬¬18åãããŒã¿æåã¢ããªã±ãŒã·ã§ã³ãã¶ã€ã³ã
- 2023/04/20ïŒæšïŒïœç¬¬19åãããŒã¿ãšã³ãžãã¢ã®ãã£ãªã¢ãèããã
- 2023/06/30ïŒéïŒïœç¬¬20åã10幎æŠããããŒã¿åæå ¥éã
- 2023/08/30ïŒéïŒïœç¬¬21åãAzureã®ããŒã¿åæãµãŒãã¹ã®çŸåšãšæªæ¥ã
- 2023/12/12ïŒéïŒïœç¬¬22åã5瀟ã®ããŒã¿ãšã³ãžãã¢ãæ¯ãè¿ã2023ã
çæäºé
- Data Engineering Study ã³ãã¥ããã£ã¬ã€ãã©ã€ã³ ãäºåã«ã確èªãã ããã
- ã€ãã³ãåå æã«ãå ¥åããã ããæ å ±ã¯ã次ã®ãã©ã€ãã·ãŒããªã·ãŒã«åºã¥ããprimeNumber ã®ã¿ã§é©åã«æ±ããŸãã https://primenumber.co.jp/privacy/
äž»å¬ã»åå
äž»å¬ïŒã³ãã¥ããã£æ¯æŽåè³
ITãšã³ãžãã¢ã®ãã£ãªã¢ã«æ¬æ°ã§åãåã転è·ãµã€ã ForkwellïŒãã©ãŒã¯ãŠã§ã«ïŒ
ããŒã¿åæåºç€ã®ç·åæ¯æŽãµãŒãã¹ãtroccoãã®éçºã»éå¶ãè¡ã primeNumber
泚æäºé
â» ãã¡ãã®ã€ãã³ãæ å ±ã¯ãå€éšãµã€ãããååŸããæ å ±ãæ²èŒããŠããŸãã
â» æ²èŒã¿ã€ãã³ã°ãæŽæ°é »åºŠã«ãã£ãŠã¯ãæ å ±æäŸå ããŒãžã®å 容ãšå·®ç°ãçºçããŸãã®ã§äºããäºæ¿ãã ããã
â» ææ°æ å ±ã®ç¢ºèªãåå ç³èŸŒæç¶ããã€ãã³ãã«é¢ãããåãåããçã¯æ å ±æäŸå ããŒãžã«ãŠãé¡ãããŸãã

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

SESã»ITäŒæ¥äº€æµäŒã2026幎5æ12æ¥ãæ¡ä»¶ã»èŠå¡ã»ããŒãããŒãæ¢ããSESå¶æ¥æ åœè ããžãã¹äº€æµã€ãã³ãïŒç¥ç°ïŒ
2026/05/12(ç«) éå¬
5/23(å) Tableauåå¿è åãå匷äŒ+æèŠªäŒïŒTableauããŸããŸäŒïŒ #26 åå€ã°ã«ã¡@åå€ã»å€©ç¥
2026/05/23(å) éå¬
SESã»ITäŒæ¥äº€æµäŒã2026幎5æ21æ¥ãæ¡ä»¶ã»èŠå¡ã»ããŒãããŒãæ¢ããSESå¶æ¥æ åœè ããžãã¹äº€æµã€ãã³ãïŒæ± è¢ïŒ
2026/05/21(æš) éå¬
ããšã³ãžãã¢ã®ããã® ããŒã¿åæåºç€å ¥éãèè âš æè€ åæš¹æ°ã«èã ãããŒã¿åºç€å質åäžã«ãããåºç€ãšã¹ãããã¢ããã®éã®ãïœ
2026/05/25(æ) éå¬
ãç¡æãExcelã§èª°ã§ãç°¡åã«ã§ããïŒãéèšãšå¯èŠåã§åŠã¶ããŒã¿åæè¶ å ¥éã-仿¥ãã䜿ããâäŒããè³æäœæè¡â-
2026/05/29(é) éå¬- TOP
- ã€ãã³ã
- Data Engineering Study #23 Data orchestration ç¹é


