10æ4æ¥ãçµç¹å
ã®ããŒã¿ãããã¥ãŒãµãŒãšã³ã³ã·ã¥ãŒããŒã®éã§ããŒã¿ãã«ã¿ãã°åãæ€åºãåæãå
±æã管çããããã®æ°ããããŒã¿ç®¡çãµãŒãã¹ã§ãã Amazon DataZone ã®äžè¬æäŸã®éå§ãçºè¡šããŸããã AWS re:Invent 2022 ã§ã¯ Amazon DataZone ã«ã€ããŠã® äºåçºè¡š ãè¡ãã2023 幎 3 æã«ã¯ ãããªãã¯ãã¬ãã¥ãŒããªãªãŒã¹ ããŸããã ååã® re:Invent ã®åºèª¿è¬æŒã§ãAWS ã® Databases, Analytics, and Machine Learning æ
åœãã€ã¹ãã¬ãžãã³ãã§ãã Swami Sivasubramanian ã¯æ¬¡ã®ããã«è¿°ã¹ãŸãããã幞ããªããšã«ãç§ã¯ DataZone ã®åæãŠãŒã¶ãŒãšããŠãAWS ã®é±æ¬¡ã®ããžãã¹ã¬ãã¥ãŒããŒãã£ã³ã°ãéå¬ããŠããŸããããã®ããŒãã£ã³ã°ã§ã¯ãããžãã¹æŠç¥ã®åèãšããããã«ã販売ãã€ãã©ã€ã³ãšåçäºæž¬ããã®ããŒã¿ãéããŠããŸããã åºèª¿è¬æŒäžãAmazon DataZone ã®è£œå責任è
ã§ãã Shikha Verma ãäž»å°ãã ã㢠ã§ã¯ãçµç¹ããã®è£œåãå©çšããŠãã广çãªåºåãã£ã³ããŒã³ãäœæããããŒã¿ãæå€§éã«æŽ»çšããæ¹æ³ã瀺ãããã«ãã¢ã³ã¹ãã¬ãŒã·ã§ã³ãè¡ãããŸããã ããã¹ãŠã®äŒæ¥ã¯ãããŸããŸãªããŒã¿ã¹ãã¢ã«ååšããããŒã¿ãææããã³å©çšããè€æ°ã®ããŒã ã§æ§æãããŠããŸããããŒã¿æ
åœè
ã¯ãã®ããŒã¿ããŸãšããªããã°ãªããŸãããããã®ããŒã¿ã«ã¢ã¯ã»ã¹ããããããŒã¿ãææ¡ãããããããã®ç°¡åãªæ¹æ³ãæã£ãŠããŸãããDataZone ã¯ãããŒã¿ãããã¥ãŒãµãŒããã³ã³ã·ã¥ãŒããŒãŸã§ãçµç¹å
ã®èª°ããçµ±å¶ãããæ¹æ³ã§ããŒã¿ã«ã¢ã¯ã»ã¹ããããããŒã¿ãå
±æãããã§ããçµ±åç°å¢ãæäŸããŸãã ããŒã¿ãããã¥ãŒãµãŒã¯ Amazon DataZone ãå©çšããŠã AWS Glue ããŒã¿ã«ã¿ãã°ããã³ Amazon Redshift ããŒãã«ããã®æ§é åããŒã¿ã¢ã»ãããããžãã¹ããŒã¿ã«ã¿ãã°ã«è¿œå ããŸããããŒã¿ã³ã³ã·ã¥ãŒããŒã¯ãããŒã¿ã«ã¿ãã°å
ã®ããŒã¿ã¢ã»ãããæ€çŽ¢ããã³ãµãã¹ã¯ã©ã€ãããä»ã®ããžãã¹ãŠãŒã¹ã±ãŒã¹ã®ååè
ãšå
±æããŸããã³ã³ã·ã¥ãŒããŒã¯ãAmazon DataZone ããŒã¿ã«ããçŽæ¥ã¢ã¯ã»ã¹ã§ããããŒã« (Amazon Redshift ã Amazon Athena ã¯ãšãªãšãã£ã¿ãªã©) ã䜿çšããŠããµãã¹ã¯ã©ã€ãããããŒã¿ã¢ã»ãããåæã§ããŸããçµ±åããããããªãã·ã¥-ãµãã¹ã¯ã©ã€ãã¯ãŒã¯ãããŒã¯ããããžã§ã¯ãå
šäœã§ã®ã¢ã¯ã»ã¹ç£æ»æ©èœãæäŸããŸãã Amazon DataZone ã®ãçŽ¹ä» Amazon DataZone ã«ã€ããŠãŸã ãªãã¿ããªãã客æ§ã®ããã«ããã®äž»èŠãªæŠå¿µãšæ©èœãã玹ä»ããŸãã Amazon DataZone ãã¡ã€ã³ã¯ãç¬èªã®ããŒã¿ (ç¬èªã®ããŒã¿ã¢ã»ããããããŒã¿ãŸãã¯ããžãã¹çšèªã®ç¬èªã®å®çŸ©ãå«ã) ã管çã§ããç¬èªã®ç®¡çåºæºãèšããŠããå Žåããããçµç¹å
ã®äºæ¥éšé (LOB) ãããžãã¹é åã®æç¢ºãªå¢çã衚ããŸãããã¡ã€ã³ã«ã¯ãããŒã¿ããŒã¿ã«ãããžãã¹ããŒã¿ã«ã¿ãã°ããããžã§ã¯ããç°å¢ãçµã¿èŸŒã¿ã¯ãŒã¯ãããŒãªã©ã®ãã¹ãŠã®ã³ã¢ã³ã³ããŒãã³ããå«ãŸããŸãã ããŒã¿ããŒã¿ã« (AWS ãããžã¡ã³ãã³ã³ãœãŒã«ã®å€éš) â ããã¯ãããŸããŸãªãŠãŒã¶ãŒãã»ã«ããµãŒãã¹ã®åœ¢åŒã§ããŒã¿ã®ã«ã¿ãã°åãæ€åºã管çãå
±æãåæãè¡ãããšãã§ãããŠã§ãã¢ããªã±ãŒã·ã§ã³ã§ããããŒã¿ããŒã¿ã«ã¯ã AWS IAM ã¢ã€ãã³ãã£ãã£ã»ã³ã¿ãŒ ãä»ããŠã AWS Identity and Access Manager (IAM) èªèšŒæ
å ±ããŸã㯠ID ãããã€ããŒããæäŸãããæ¢åã®èªèšŒæ
å ±ã䜿çšããŠãŠãŒã¶ãŒãèªèšŒããŸãã ããžãã¹ããŒã¿ã«ã¿ãã° â ã«ã¿ãã°ã§ã¯ãå顿³ãŸãã¯ããžãã¹çšèªéãå®çŸ©ã§ããŸãããã®ã³ã³ããŒãã³ãã䜿çšãããšãããžãã¹ã³ã³ããã¹ããå«ããŠçµç¹å
šäœã®ããŒã¿ãã«ã¿ãã°åããçµç¹å
ã®å
šå¡ãããŒã¿ãè¿
éã«æ€çŽ¢ããã³çè§£ã§ããããã«ããããšãã§ããŸãã ããŒã¿ãããžã§ã¯ããšç°å¢ â ãããžã§ã¯ãã䜿çšããŠããŠãŒã¶ãŒãããŒã¿ã¢ã»ãããåæããŒã«ã®ããžãã¹ãŠãŒã¹ã±ãŒã¹ããŒã¹ã®ã°ã«ãŒããäœæããããšã§ãAWS åæãžã®ã¢ã¯ã»ã¹ãç°¡çŽ åã§ããŸããAmazon DataZone ã®ãããžã§ã¯ãã¯ããããžã§ã¯ãã¡ã³ããŒãå
±åäœæ¥ãããŒã¿äº€æãããŒã¿ã¢ã»ããã®å
±æãè¡ãããšãã§ããã¹ããŒã¹ãæäŸããŸãããããžã§ã¯ãå
ã§ã¯ãåæããŒã«ãã¹ãã¬ãŒãžãªã©ã®å¿
èŠãªã€ã³ãã©ã¹ãã©ã¯ãã£ããããžã§ã¯ãã¡ã³ããŒã«æäŸããç°å¢ãäœæããŠããããžã§ã¯ãã¡ã³ããŒãæ°ããããŒã¿ãç°¡åã«çæããããã¢ã¯ã»ã¹æš©ã®ããããŒã¿ãå©çšãããã§ããããã«ããããšãã§ããŸãã ã¬ããã³ã¹ãšã¢ã¯ã»ã¹ã³ã³ãããŒã« â çµç¹å
šäœã®ãŠãŒã¶ãŒãã«ã¿ãã°å
ã®ããŒã¿ãžã®ã¢ã¯ã»ã¹ããªã¯ãšã¹ãããããŒã¿ã®ææè
ããããã®ãµãã¹ã¯ãªãã·ã§ã³ãªã¯ãšã¹ãã確èªããŠæ¿èªããããšãå¯èœã«ãããçµã¿èŸŒã¿ã¯ãŒã¯ãããŒã䜿çšã§ããŸãããµãã¹ã¯ãªãã·ã§ã³ãªã¯ãšã¹ããæ¿èªããããšãAmazon DataZone ã¯ã AWS Lake Formation ã Amazon Redshift ãªã©ã®åºç€ãšãªãããŒã¿ã¹ãã¢ã§èš±å¯ã管çããããšã§ãèªåçã«ã¢ã¯ã»ã¹ãä»äžã§ããŸãã 詳现ã«ã€ããŠã¯ãã Amazon DataZone ã®çšèªãšæŠå¿µ ããã芧ãã ããã Amazon DataZone ã®éå§æ¹æ³ ãŸãã補åããŒã±ãã£ã³ã°ããŒã ã補åã®å°å
¥ãä¿é²ãããã£ã³ããŒã³ãå®è¡ããããšããã·ããªãªãèããŠã¿ãŸãããããããè¡ãã«ã¯ãå¶æ¥ããŒã ãææãã補å販売ããŒã¿ãåæããå¿
èŠããããŸãããã®ãã¥ãŒããªã¢ã«ã§ã¯ãããŒã¿ãããã¥ãŒãµãŒãšããŠæ©èœããå¶æ¥ããŒã ã Amazon DataZone ã§è²©å£²ããŒã¿ãå
¬éããŸãããã®åŸãããŒã¿ã³ã³ã·ã¥ãŒããŒãšããŠæ©èœããããŒã±ãã£ã³ã°ããŒã ã販売ããŒã¿ããµãã¹ã¯ã©ã€ããããã£ã³ããŒã³æŠç¥ãæ§ç¯ããããã«ãã®ããŒã¿ãåæããŸãã DataZone ã®ä»çµã¿ãçè§£ããããã«ãAmazon DataZone ã® éå§æ¹æ³ã¬ã€ã ãèŠçŽãããã®ãèŠãŠã¿ãŸãããã 1.ãã¡ã€ã³ãäœæãã DataZone ã®å©çšãåããŠéå§ããéã«ã¯ããŸããã¡ã€ã³ãšãããžãã¹ããŒã¿ã«ã¿ãã°ããããžã§ã¯ããç°å¢ãªã©ã®ãã¹ãŠã®ã³ã¢ã³ã³ããŒãã³ããããŒã¿ããŒã¿ã«ã«äœæããŠããããã®ã³ã³ããŒãã³ãããã®ãã¡ã€ã³å
ã«ååšããããã«ããŸãã Amazon DataZone ã³ã³ãœãŒã« ã«ç§»åãã [ãã¡ã€ã³ãäœæ] ãéžæããŸãã [ãã¡ã€ã³å] ãšèª¬æãå
¥åããä»ã®å€ã¯ãã¹ãŠããã©ã«ãã®ãŸãŸã«ããŸãã äŸãã°ã [ãµãŒãã¹ã¢ã¯ã»ã¹] ã»ã¯ã·ã§ã³ã§ãããã©ã«ãã§ [æ°ããããŒã«ãäœæããŠäœ¿çš] ãéžæãããšãAmazon DataZone ã¯ãDataZone ããã¡ã€ã³å
ã®ãŠãŒã¶ãŒã«ä»£ãã£ãŠ API åŒã³åºããå®è¡ããããšãèªå¯ããããã«å¿
èŠãªèš±å¯ãæã€æ°ããããŒã«ãèªåçã«äœæããŸããDataZone ããã¹ãŠã®èšå®ã¹ããããå®è¡ã§ãã Quick Setup ãªãã·ã§ã³ã®ãã§ãã¯ããªã³ã«ããŸãã æåŸã«ã [ãã¡ã€ã³ãäœæ] ãéžæããŸããAmazon DataZone ã¯å¿
èŠãª IAM ããŒã«ãäœæãããã®ãã¡ã€ã³ã AWS Glue ããŒã¿ã«ã¿ãã°ãAmazon RedshiftãAmazon Athena ãªã©ã®ã¢ã«ãŠã³ãå
ã®ãªãœãŒã¹ã䜿çšã§ããããã«ããŸãããã¡ã€ã³ã®äœæãå®äºãããŸã§ã«æ°åãããå ŽåããããŸãããã¡ã€ã³ã®ã¹ããŒã¿ã¹ã [䜿çšå¯èœ] ã«ãªããŸã§åŸ
ã¡ãŸãã 2.ããŒã¿ããŒã¿ã«ã§ãããžã§ã¯ããšç°å¢ãäœæãã ãã¡ã€ã³ãæ£åžžã«äœæãããããã®ãã¡ã€ã³ãéžæãããã¡ã€ã³ã®æŠèŠããŒãžã§ã«ãŒããã¡ã€ã³ã®ããŒã¿ããŒã¿ã« URL ã確èªããŠæžãçããŸãããã® URL ã䜿çšããŠãAmazon DataZone ããŒã¿ããŒã¿ã«ã«ã¢ã¯ã»ã¹ã§ããŸãã [ããŒã¿ããŒã¿ã«ãéã] ãéžæããŸãã å¶æ¥ããŒã ãšããŠæ°ããããŒã¿ãããžã§ã¯ããäœæããŠè²©å£²ããŒã¿ãå
¬éããã«ã¯ã [ãããžã§ã¯ããäœæ] ãéžæããŸãã ãã€ã¢ãã°ããã¯ã¹ã§ã [åå] ãšããŠãSales producer projectããšå
¥åãããã®ãããžã§ã¯ãã® [説æ] ãå
¥åããŠã [äœæ] ãéžæããŸãã ãããžã§ã¯ããäœæãããããã®ãããžã§ã¯ãã§ããŒã¿ããã³åæããŒã« (Amazon Athena ã Amazon Redshift ãªã©) ã䜿çšããããã®ç°å¢ãäœæããå¿
èŠããããŸããæŠèŠããŒãžã§ããŸã㯠[ç°å¢] ã¿ããã¯ãªãã¯ããåŸã [ç°å¢ãäœæ] ãéžæããŸãã [åå] ãšããŠãpublish-environmentããšå
¥åãããã®ç°å¢ã® [説æ] ãå
¥åããŠã [ç°å¢ãããã¡ã€ã«] ãéžæããŸããç°å¢ãããã¡ã€ã«ã¯ããããžã§ã¯ãã«è¿œå ããã AWS ã¢ã«ãŠã³ãããªãŒãžã§ã³ãVPC ã®è©³çްããªãœãŒã¹ãããŒã«ãªã©ãç°å¢ãäœæããããã«å¿
èŠãšãªãæè¡çãªè©³çްãå«ãŸããäºåå®çŸ©æžã¿ã®ãã³ãã¬ãŒãã§ãã ããã€ãã®ããã©ã«ãã®ç°å¢ãããã¡ã€ã«ãéžæã§ããŸãã DataLakeProfile ãéžæãããšãAmazon S3 ããã³ AWS Glue ããŒã¹ã®ããŒã¿ã¬ã€ã¯ããããŒã¿ãå
¬éã§ããããã«ãªããŸãããŸããAmazon Athena ãå©çšããŠã¢ã¯ã»ã¹ã§ãã AWS Glue ããŒãã«ã«å¯Ÿããã¯ãšãªãç°¡çŽ åãããŸãã æ¬¡ã«ããªãã·ã§ã³ã®ãã©ã¡ãŒã¿ããã¹ãŠç¡èŠããŠã [ç°å¢ãäœæ] ãéžæããŸããç°å¢ã IAM ããŒã«ãAmazon S3 ãµãã£ãã¯ã¹ãAWS Glue ããŒã¿ããŒã¹ãAthena ã¯ãŒã¯ã°ã«ãŒããªã©ã®ç¹å®ã®ãªãœãŒã¹ã AWS ã¢ã«ãŠã³ãã«äœæããã®ã«çŽ 1 åããããŸããããã«ããããããžã§ã¯ãã®ã¡ã³ããŒãããŒã¿ã¬ã€ã¯ã§ããŒã¿ãçæããã³å©çšããããšããã容æã«ãªããŸãã 3.ããŒã¿ããŒã¿ã«ã§ããŒã¿ãå
¬éãã AWS Glue ããŒãã«ã§ããŒã¿ãå
¬éããç°å¢ãäœæã§ããŸãããAmazon Athena ã§ãã®ããŒãã«ãäœæããã«ã¯ã [ç°å¢] ããŒãžã®å³åŽã«ãã [ããŒã¿ã®ã¯ãšãª] (Athena ã®ãªã³ã¯ãèšå®ãããŠããŸã) ãéžæããŸãã ããã«ãããAthena ã¯ãšãªãšãã£ã¿ãæ°ããã¿ãã§éããŸããããŒã¿ããŒã¹ã®ããããããŠã³ãã publishenvironment_pub_db ãéžæããæ¬¡ã®ã¯ãšãªãã¯ãšãªãšãã£ã¿ã«è²Œãä»ããŸããããã«ãããç°å¢ã® AWS Glue ããŒã¿ããŒã¹ã« catalog_sales ãšããããŒãã«ãäœæãããŸãã CREATE TABLE catalog_sales AS SELECT 146776932 AS order_number, 23 AS quantity, 23.4 AS wholesale_cost, 45.0 as list_price, 43.0 as sales_price, 2.0 as discount, 12 as ship_mode_sk,13 as warehouse_sk, 23 as item_sk, 34 as catalog_page_sk, 232 as ship_customer_sk, 4556 as bill_customer_sk UNION ALL SELECT 46776931, 24, 24.4, 46, 44, 1, 14, 15, 24, 35, 222, 4551 UNION ALL SELECT 46777394, 42, 43.4, 60, 50, 10, 30, 20, 27, 43, 241, 4565 UNION ALL SELECT 46777831, 33, 40.4, 51, 46, 15, 16, 26, 33, 40, 234, 4563 UNION ALL SELECT 46779160, 29, 26.4, 50, 61, 8, 31, 15, 36, 40, 242, 4562 UNION ALL SELECT 46778595, 43, 28.4, 49, 47, 7, 28, 22, 27, 43, 224, 4555 UNION ALL SELECT 46779482, 34, 33.4, 64, 44, 10, 17, 27, 43, 52, 222, 4556 UNION ALL SELECT 46779650, 39, 37.4, 51, 62, 13, 31, 25, 31, 52, 224, 4551 UNION ALL SELECT 46780524, 33, 40.4, 60, 53, 18, 32, 31, 31, 39, 232, 4563 UNION ALL SELECT 46780634, 39, 35.4, 46, 44, 16, 33, 19, 31, 52, 242, 4557 UNION ALL SELECT 46781887, 24, 30.4, 54, 62, 13, 18, 29, 24, 52, 223, 4561 ããããããŠã³ã¡ãã¥ãŒã« 2 ã€ã®ããŒã¿ããŒã¹ã衚瀺ãããŸãã publishenvironment_pub_db ã¯ãæ°ããããŒã¿ãçæããããã DataZone ã«ã¿ãã°ã«å
¬éããããšãéžæããããã®ã¹ããŒã¹ãæäŸããŸãããã 1 ã€ã® publishenvironment_sub_db ã¯ããããžã§ã¯ãã¡ã³ããŒããããžã§ã¯ãå
ã®ã«ã¿ãã°ã®ããŒã¿ããµãã¹ã¯ã©ã€ããŸãã¯ã¢ã¯ã»ã¹ããå Žåã«äœ¿çšããŸãã catalog_sales ããŒãã«ãæ£åžžã«äœæãããããšã確èªããŠãã ãããããã§ãAmazon DataZone ã«ã¿ãã°ã«å
¬éã§ããããŒã¿ã¢ã»ããã宿ããŸããã ããŒã¿ãããã¥ãŒãµãŒã¯ãããŒã¿ããŒã¿ã«ã«æ»ã£ãŠããã®ããŒãã«ã DataZone ã«ã¿ãã°ã«å
¬éã§ããŸããäžéšã®ã¡ãã¥ãŒã§ [ããŒã¿] ã¿ããéžæããå·ŠåŽã®ããã²ãŒã·ã§ã³ãã€ã³ã§ [ããŒã¿ãœãŒã¹] ãéžæããŸãã ç°å¢å
ã«ã¯ãèªåçã«äœæãããããã©ã«ãã®ããŒã¿ãœãŒã¹ããããŸãããã®ããŒã¿ãœãŒã¹ãéããšã catalog_sales ããŒãã«ãäœæããã°ããã®ç°å¢ã®å
¬éããŒã¿ããŒã¹ã衚瀺ãããŸãã ãã®ããŒã¿ãœãŒã¹ã¯ãå
¬éããŒã¿ããŒã¹å
ã§èŠã€ãã£ããã¹ãŠã®ããŒãã«ã DataZone ã«åã蟌ã¿ãŸããããã©ã«ãã§ã¯ãèªåã¡ã¿ããŒã¿çæãæå¹ã«ãªã£ãŠããŸããããã¯ãããŒã¿ãœãŒã¹ã DataZone ã«åã蟌ãã¢ã»ãããããã®ã¢ã»ããã®ããŒãã«ãšåã®ããžãã¹åãèªåçã«çæããããšãæå³ããŸãããã®ããŒã¿ãœãŒã¹ã§ [å®è¡] ãéžæããŸãã ããŒã¿ãœãŒã¹ã®å®è¡ãå®äºãããšã [ããŒã¿ãœãŒã¹ã®å®è¡] ã« catalog sales ããŒãã«ã衚瀺ãããŸãã ãã®ã¢ã»ãããéããšãããŒãã«ã®ã¹ããŒãããä»ã®ããã€ãã®æè¡çãªè©³çް (AWS ã¢ã«ãŠã³ãããªãŒãžã§ã³ãããŒã¿ã®ç©ççãªå Žæãªã©) ãå«ãæè¡ã¡ã¿ããŒã¿ããå
¬éãžã§ããèªåçã«æœåºããŠããã®ã確èªã§ããŸãã ãããã®ã¡ã¿ããŒã¿ãæ£ãããšæãããå Žåã¯ãåæšå¥šé
ç®ã®è³ã®ã¢ã€ã³ã³ãã¯ãªãã¯ãããããŸãã¯ãã¹ãŠã®æšå¥šé
ç®ã«ã€ã㊠[ãã¹ãŠæ¿èª] ãã¿ã³ãã¯ãªãã¯ããã ãã§ããããã®æšå¥šé
ç®ãæ¿è«Ÿã§ããŸããå
¬éããæºåãã§ãããã [ã¢ã»ãããå
¬é] ãéžæãããã€ã¢ãã°ããã¯ã¹ã§å確èªããŸãã 4.ããŒã¿ã³ã³ã·ã¥ãŒããŒãšããŠããŒã¿ããµãã¹ã¯ã©ã€ããã æ¬¡ã«ã圹å²ãããŒã±ãã£ã³ã°ããŒã ã«åãæ¿ããŠããã®ããŒãã«ã®ãµãã¹ã¯ãªãã·ã§ã³ãŸãã¯ã¢ã¯ã»ã¹ããªã¯ãšã¹ãããæ¹æ³ãèŠãŠã¿ãŸããããããŒã¿ã³ã³ã·ã¥ãŒããŒãšããŠãåãšåãã¹ããããç¹°ãè¿ããŠãMarketing consumer projectããšããæ°ãããããžã§ã¯ããšãsubscriber-environmentããšããæ°ããç°å¢ãäœæããŸãã æ°ããäœæãããããžã§ã¯ãã§ãæ€çŽ¢ããŒã«ãcatalog salesããšå
¥åãããšãå
¬éãããããŒãã«ãæ€çŽ¢çµæã«è¡šç€ºãããŸãã [ã«ã¿ãã°è²©å£²ããŒã¿] ãéžæããŸãã ã«ã¿ãã°ã§ã [ãµãã¹ã¯ã©ã€ã] ãéžæããŸãã [ã«ã¿ãã°è²©å£²ããŒã¿ããµãã¹ã¯ã©ã€ã] ãŠã£ã³ããŠã§ãããŒã±ãã£ã³ã°ã³ã³ã·ã¥ãŒããŒãããžã§ã¯ããéžæãããµãã¹ã¯ãªãã·ã§ã³ãªã¯ãšã¹ãã®çç±ãå
¥åããŠã [ãµãã¹ã¯ã©ã€ã] ãéžæããŸãã ããŒã¿ãããã¥ãŒãµãŒãšããŠãµãã¹ã¯ãªãã·ã§ã³ãªã¯ãšã¹ããåãåããšãã»ãŒã«ã¹ãããã¥ãŒãµãŒãããžã§ã¯ãã®ã¿ã¹ã¯ãéããŠéç¥ãããŸããããã§ã¯ãµãã¹ã¯ã©ã€ããŒãšãããªãã·ã£ãŒã®äž¡æ¹ã®åœ¹å²ãæ
ã£ãŠãããããéç¥ã衚瀺ãããŸãã ãã®éç¥ãã¯ãªãã¯ãããšãã¢ã¯ã»ã¹ããªã¯ãšã¹ããããããžã§ã¯ãããªã¯ãšã¹ããå®è¡ãããŠãŒã¶ãŒãããã³ã¢ã¯ã»ã¹ãå¿
èŠãªçç±ãå«ããµãã¹ã¯ãªãã·ã§ã³ãªã¯ãšã¹ããéããŸãã [æ¿èª] ãéžæããæ¿èªã®çç±ãå
¥åããŸãã ãµãã¹ã¯ãªãã·ã§ã³ãæ¿èªãããã®ã§ãããŒã±ãã£ã³ã°ã³ã³ã·ã¥ãŒããŒãããžã§ã¯ãã§ã«ã¿ãã°è²©å£²ããŒã¿ã衚瀺ã§ããããã«ãªããŸãããããã確èªããã«ã¯ããããã¡ãã¥ãŒã® [ããŒã¿] ã¿ããéžæããå·ŠåŽã®ããã²ãŒã·ã§ã³ãã€ã³ã§ [ããŒã¿ãœãŒã¹] ãéžæããŸãã ãµãã¹ã¯ã©ã€ãããŒã¿ãåæããã«ã¯ããããã¡ãã¥ãŒã® [ç°å¢] ã¿ããéžæããããŒã±ãã£ã³ã°ã³ã³ã·ã¥ãŒããŒãããžã§ã¯ãã§äœæãã Subscribe-environment ãéžæããŸããå³åŽã®ãã€ã³ã«æ°ãã [ããŒã¿ã®ã¯ãšãª] ãªã³ã¯ã衚瀺ãããŸãã ã«ã¿ãã°è²©å£²ããŒãã«ããµãã¹ã¯ãªãã·ã§ã³ããŒã¿ããŒã¹ã®äžã«è¡šç€ºãããŠããããšãããããŸãã ãã®ããŒãã«ã«ã¢ã¯ã»ã¹ã§ããããšã確èªããã«ã¯ãããŒãã«ããã¬ãã¥ãŒããŠãã¯ãšãªãæ£åžžã«å®è¡ãããããšã確èªããŸãã ããã«ãããAthena ã¯ãšãªãšãã£ã¿ãæ°ããã¿ãã§éããŸããããŒã¿ããŒã¹ã®ããããããŠã³ãã subscribeenvironment_sub_db ãéžæããã¯ãšãªãšãã£ã¿ã«ã¯ãšãªãå
¥åããŸãã ããã§ãã³ã³ã·ã¥ãŒã㌠(ããŒã±ãã£ã³ã°ããŒã ) ãšããŠãµãã¹ã¯ã©ã€ããããããã¥ãŒãµãŒ (å¶æ¥ããŒã ) ã«ãã£ãŠããžãã¹ããŒã¿ã«ã¿ãã°ã«å
¬éããã販売ããŒã¿ããŒãã«ã«å¯ŸããŠã¯ãšãªãå®è¡ã§ããããã«ãªããŸããã AWS Glue ããŒãã«ã Amazon Redshift ããŒãã«ããã³ãã¥ãŒã®å
¬éãªã©ã®è©³çްãªãã¢ã«ã€ããŠã¯ãYouTube ã®ãã¬ã€ãªã¹ããã芧ãã ããã GA ã§ã®æ°æ©èœ ãã¬ãã¥ãŒäžãã客æ§ããå€ãã®é¢å¿ãšãã°ããããã£ãŒãããã¯ããå¯ãããã ããŸãããå°ãæéãå²ããŠãããã®æ©èœã確èªããããã€ãã®æ¹åç¹ãã玹ä»ããŸãã ãšã³ã¿ãŒãã©ã€ãºå¯Ÿå¿ããžãã¹ã«ã¿ãã° â ããžãã¹ã³ã³ããã¹ãã远å ããçµç¹å
ã®å
šå¡ãããŒã¿ãæ€åºã§ããããã«ããããã«ãèªåã¡ã¿ããŒã¿çæã䜿çšããŠã«ã¿ãã°ãã«ã¹ã¿ãã€ãºã§ããŸããèªåã¡ã¿ããŒã¿çæã§ã¯ãæ©æ¢°åŠç¿ã䜿çšããŠãããŒã¿ã¢ã»ãããšããããã®ã¢ã»ããå
ã®åã®ããžãã¹åãèªåçã«çæããŸãããŸããã¡ã¿ããŒã¿ã®ãã¥ã¬ãŒã·ã§ã³æ©èœãæ¹åããŸãããGA ã§ã¯ãè€æ°ã®ããžãã¹çšèªéã®çšèªãã¢ã»ããã«ã¢ã¿ããããããçšèªéã®çšèªãã¢ã»ããå
ã®åå¥ã®åã«ã¢ã¿ãããããã§ããŸãã ããŒã¿ãŠãŒã¶ãŒåãã®ã»ã«ããµãŒãã¹ â ããŒã¿ã®èªåŸæ§ãæäŸããŠããŠãŒã¶ãŒãããŒã¿ãå
¬éããã³å©çšã§ããããã«ããããã«ãAPI ã䜿çšããŠããããã¿ã€ãã®ã¢ã»ãããã«ã¹ã¿ãã€ãºããã«ã¿ãã°ã«åã蟌ãããšãã§ããŸããããŒã¿ãããªãã·ã£ãŒã¯ãåã蟌ã¿ãžã§ããéããŠã¡ã¿ããŒã¿ã®æ€åºãèªååããããšãã Amazon Simple Storage Service (Amazon S3) ãããã¡ã€ã«ãæåã§å
¬éããããšãã§ããŸããããŒã¿ã³ã³ã·ã¥ãŒããŒã¯ããã¡ã»ããæ€çŽ¢ã䜿çšããŠãããŒã¿ãè¿
éã«æ€çŽ¢ããã³çè§£ã§ããŸãããŠãŒã¶ãŒã¯ãã·ã¹ãã ã®æŽæ°ãå®è¡ãã¹ãã¢ã¯ã·ã§ã³ã«ã€ããŠéç¥ãåããããšãã§ããŸãããããã®ã€ãã³ãã¯ãã¢ã¯ã·ã§ã³ãã«ã¹ã¿ãã€ãºããããã« Amazon EventBridge ãå©çšããŠã客æ§ã®ã€ãã³ããã¹ã«åºåãããŸãã åæãžã®ã¢ã¯ã»ã¹ã®ç°¡çŽ å â GA ã§ã¯ããããžã§ã¯ãã¯ããžãã¹ãŠãŒã¹ã±ãŒã¹ããŒã¹ã®è«çã³ã³ãããšããŠæ©èœããŸãããããžã§ã¯ããäœæããç¹å®ã®ããžãã¹ãŠãŒã¹ã±ãŒã¹ã«åºã¥ããŠãŠãŒã¶ãŒãããŒã¿ãåæããŒã«ãã°ã«ãŒãåããŠå
±åäœæ¥ã§ããŸãããããžã§ã¯ãå
ã§ã¯ãåæããŒã«ãã¹ãã¬ãŒãžãªã©ã®å¿
èŠãªã€ã³ãã©ã¹ãã©ã¯ãã£ããããžã§ã¯ãã¡ã³ããŒã«æäŸããç°å¢ãäœæããŠããããžã§ã¯ãã¡ã³ããŒãæ°ããããŒã¿ãç°¡åã«çæããããã¢ã¯ã»ã¹æš©ã®ããããŒã¿ãå©çšãããã§ããããã«ããããšãã§ããŸããããã«ããããŠãŒã¶ãŒã¯ãããŒãºã«å¿ããŠè€æ°ã®æ©èœãåæããŒã«ãåããããžã§ã¯ãã«è¿œå ã§ããŸãã çµ±å¶ãããããŒã¿å
±æ â ããŒã¿ãããã¥ãŒãµãŒã¯ãã³ã³ã·ã¥ãŒããŒãã¢ã¯ã»ã¹ããªã¯ãšã¹ãããããŒã¿ææè
ãæ¿èªããããšãå¯èœã«ãããµãã¹ã¯ãªãã·ã§ã³æ¿èªã¯ãŒã¯ãããŒã䜿çšããŠãããŒã¿ãžã®ã¢ã¯ã»ã¹ãææããã³ç®¡çããŸããå
¬éæã«ã¢ã»ããã«ã¢ã¿ããããããµãã¹ã¯ãªãã·ã§ã³æ¡ä»¶ãèšå®ããããAWS ãããŒãžãã®ããŒã¿ã¬ã€ã¯ãš Amazon Redshift ã®ãµãã¹ã¯ãªãã·ã§ã³ä»äžã®ãã«ãã£ã«ã¡ã³ããèªååãããã§ããããã«ãªããŸãã (ä»ã®ãœãŒã¹ã®ããã« EventBridge ã€ãã³ããå©çšããŠã«ã¹ã¿ãã€ãºããããšãã§ããŸã)ã ä»ãããå©çšããã ããŸã Amazon DataZone ã¯çŸåšãç±³åœæ±éš (ãªãã€ãª)ãç±³åœæ±éš (ããŒãžãã¢åéš)ãç±³åœè¥¿éš (ãªã¬ãŽã³)ãã¢ãžã¢ãã·ãã£ã㯠(ã·ã³ã¬ããŒã«)ãã¢ãžã¢ãã·ãã£ã㯠(ã·ãããŒ)ãã¢ãžã¢ãã·ãã£ã㯠(æ±äº¬)ãã«ãã (äžéš)ãæ¬§å· (ãã©ã³ã¯ãã«ã)ãæ¬§å· (ã¢ã€ã«ã©ã³ã)ãæ¬§å· (ã¹ããã¯ãã«ã )ãåç±³ (ãµã³ããŠã) ã® 11 ã® AWS ãªãŒãžã§ã³ã§äžè¬æäŸãããŠããŸãã Amazon DataZone ã®ç¡æãã©ã€ã¢ã«ããå©çšããã ããŸããããã«ã¯ãå©çšéå§åŸã®æåã® 3 æŠæéã«ããã£ãŠã50 åã®ãŠãŒã¶ãŒã«ããè¿œå æéãªãã§ã®å©çšãå«ãŸããŠããŸããç¡æãã©ã€ã¢ã«ã¯ãAWS ã¢ã«ãŠã³ãã«åã㊠Amazon DataZone ãã¡ã€ã³ãäœæãããšãã«éå§ãããŸããè©Šçšæéäžã«æéãŠãŒã¶ãŒæ°ãè¶
éããå Žåã¯ã æšæºæé ã«åºã¥ããŠèª²éãããŸãã 詳现ã«ã€ããŠã¯ã 補åããŒãž ããã³ ãŠãŒã¶ãŒã¬ã€ã ãã芧ãã ããããã£ãŒãããã¯ã¯ã AWS re:Post for Amazon DataZone å®ãŠã«ããŸãã¯éåžžã® AWS ãµããŒãã®é£çµ¡å
ãéããŠãå¯ãããã ããŸãã â Channy åæã¯ ãã¡ã ã§ãã