ããŒã¿ ã³ã³ã·ã¥ãŒãã®ãŠãŒã¹ã±ãŒã¹ã«ç¢ºå®ã«å¯Ÿå¿ããã«ã¯ãããŒã¿ã¡ãã·ã¥å ã®ããŒã¿ ãããã¯ããæ éã«èšèšãæ§ç¯ãããŠããããšãéèŠã§ããããŒã¿ ãããã¯ãã®èšèšã¯ãããŒã¿ ã³ã³ã·ã¥ãŒãããã®ãããã¯ãã䜿çšããæ¹æ³ãšãããŒã¿ ã³ã³ã·ã¥ãŒãã«ãã®ãããã¯ããå ¬éããæ¹æ³ãå®çŸ©ããããšããå§ãŸããŸããããŒã¿ã¡ãã·ã¥å ã®ããŒã¿ ãããã¯ãã¯ãããŒã¿ã¹ãã¢ïŒãã¡ã€ã³ ããŒã¿ ãŠã§ã¢ããŠã¹ãããŒã¿ã¬ã€ã¯ãªã©ïŒäžã«æ§ç¯ãããŸããããŒã¿ã¡ãã·ã¥ã§ããŒã¿ ãããã¯ããäœæããå Žåããã®ããã»ã¹ã§èæ ®ãã¹ãããã€ãã®éèŠãªèŠçŽ ããããŸãã ãã®ããã¥ã¡ã³ãã§ã¯ããããã®èæ ®äºé ã«ã€ããŠèª¬æããŸãã
ãã®ããã¥ã¡ã³ãã¯ã Google Cloudã§ããŒã¿ã¡ãã·ã¥ãå®è£ ããæ¹æ³ã説æããã·ãªãŒãºã®äžéšã§ããããã§ã¯ãããŒã¿ã¡ãã·ã¥å ã®ã¢ãŒããã¯ãã£ãšæ©èœãããã³ Google Cloudã§ææ°ã®åæ£ããŒã¿ã¡ãã·ã¥ãæ§ç¯ãããèªã¿ãããã§èª¬æãããŠããã³ã³ã»ãããçè§£ããŠããããšãåæãšããŠããŸãã
ãã®ã·ãªãŒãºã¯ã次ã®ããŒãããæ§æãããŠããŸãã
- ããŒã¿ã¡ãã·ã¥å ã®ã¢ãŒããã¯ãã£ãšæ©èœ
- ããŒã¿ã¡ãã·ã¥çšã®ã»ã«ããµãŒãã¹ ããŒã¿ ãã©ãããã©ãŒã ãèšèšãã
- ããŒã¿ã¡ãã·ã¥ã§ããŒã¿ ãããã¯ããæ§ç¯ããïŒãã®ããã¥ã¡ã³ãïŒ
- ããŒã¿ ã¡ãã·ã¥ã§ããŒã¿ ãããã¯ããæ€åºããŠäœ¿çšãã
ãã¡ã€ã³ ããŒã¿ ãŠã§ã¢ããŠã¹ããããŒã¿ ãããã¯ããäœæããå Žåã¯ãããŒã¿ ãããã¥ãŒãµãŒããããã®ãããã¯ãã®åæïŒæ¶è²»ïŒã€ã³ã¿ãŒãã§ãŒã¹ãæ éã«èšèšããããšãããããããŸãããããã®æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã¯ãããŒã¿å質ãšéçšãã©ã¡ãŒã¿ã«é¢ããäžé£ã®ä¿èšŒã«å ãããããã¯ã ãµããŒã ã¢ãã«ãšãããã¯ã ããã¥ã¡ã³ãã§ããæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã倿Žããå Žåã¯ãéåžžãããŒã¿ ãããã¥ãŒãµãŒãšããããè€æ°ã®ããŒã¿ ã³ã³ã·ã¥ãŒãã®äž¡æ¹ãæ¶è²»ããã»ã¹ãšã¢ããªã±ãŒã·ã§ã³ã倿Žããå¿ èŠããããããæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã®å€æŽã®ã³ã¹ããé«ããªããŸããããŒã¿ ã³ã³ã·ã¥ãŒãã¯ãããŒã¿ ãããã¥ãŒãµãŒãšã¯å¥ã®çµç¹éšéã«ååšããŠããå¯èœæ§ãé«ãããã倿Žã®èª¿æŽãå°é£ã«ãªãããšããããŸãã
以éã®ã»ã¯ã·ã§ã³ã§ã¯ããã¡ã€ã³ ãŠã§ã¢ããŠã¹ã®äœæãæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã®å®çŸ©ããããã®ã€ã³ã¿ãŒãã§ãŒã¹ãããŒã¿ ã³ã³ã·ã¥ãŒãã«å ¬éããéã«èæ ®ãã¹ãäºé ã«é¢ããèæ¯æ å ±ã説æããŸãã
ãã¡ã€ã³ ããŒã¿ ãŠã§ã¢ããŠã¹ãäœæãã
ã¹ã¿ã³ãã¢ãã³ ããŒã¿ ãŠã§ã¢ããŠã¹ã®æ§ç¯ãšãããŒã¿ ãããã¥ãŒãµãŒ ããŒã ãããŒã¿ ãããã¯ãã®äœæã«äœ¿çšãããã¡ã€ã³ ããŒã¿ ãŠã§ã¢ããŠã¹ã®æ§ç¯ã«ã¯ãæ ¹æ¬çãªéãã¯ãããŸããããã® 2 ã€ã®å¯äžã®éãã¯ãåŸè ãæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãä»ããŠããŒã¿ã®ãµãã»ãããå ¬éããããšã§ãã
å€ãã®ããŒã¿ ãŠã§ã¢ããŠã¹ã§ã¯ãéçšããŒã¿ãœãŒã¹ããåã蟌ãŸããå ããŒã¿ã«ããšã³ãªããã¡ã³ããšããŒã¿å質æ€èšŒïŒãã¥ã¬ãŒã·ã§ã³ïŒã®ããã»ã¹ãå®è¡ãããŸããDataplex Universal Catalog ã管çããããŒã¿ã¬ã€ã¯ã§ã¯éåžžããã¥ã¬ãŒããããããŒã¿ã¯ãæå®ããããã¥ã¬ãŒãããããŸãŒã³ã«ä¿åãããŸãããã¥ã¬ãŒã·ã§ã³ãå®äºãããšãããŒã¿ã®ãµãã»ããã¯ãããã€ãã®çš®é¡ã®ã€ã³ã¿ãŒãã§ãŒã¹ãä»ããŠãå€éšãããã¡ã€ã³ãžã®æ¶è²»ã«å¯Ÿå¿å¯èœã§ããå¿ èŠããããŸãããã®ãããªæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãå®çŸ©ããã«ã¯ãããŒã¿ã¡ãã·ã¥ ã¢ãããŒããåããŠåãå ¥ãããã¡ã€ã³ããŒã ã«äžé£ã®ããŒã«ãæäŸããå¿ èŠããããŸãããããã®ããŒã«ã䜿çšãããšãããŒã¿ ãããã¥ãŒãµãŒã¯ã»ã«ããµãŒãã¹ã§æ°ããããŒã¿ ãããã¯ããäœæã§ããŸããããããã®æ¹æ³ã«ã€ããŠã¯ãã»ã«ããµãŒãã¹ ããŒã¿ ãã©ãããã©ãŒã ãèšèšãããã芧ãã ããã
ãŸããããŒã¿ ãããã¯ãã¯ãäžå çã«å®çŸ©ãããããŒã¿ ã¬ããã³ã¹èŠä»¶ãæºããå¿ èŠããããŸãããããã®èŠä»¶ã¯ãããŒã¿å質ãããŒã¿ã®å¯çšæ§ãã©ã€ããµã€ã¯ã«ç®¡çã«åœ±é¿ããŸãããããã®èŠä»¶ã«ãã£ãŠããŒã¿ ãããã¯ãã«å¯ŸããããŒã¿ ã³ã³ã·ã¥ãŒãã®ä¿¡é Œãç¯ãããããŒã¿ ãããã¯ãã®å©çšãä¿é²ãããŸãããã®ããããããã®èŠä»¶ãå®è£ ããã¡ãªããã¯ããµããŒãããåŽåã«èŠåã䟡å€ããããŸãã
æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãå®çŸ©ãã
ããŒã¿ ãããã¥ãŒãµãŒãã1 ã€ãŸã㯠2 ã€ã®ã€ã³ã¿ãŒãã§ãŒã¹ãå®çŸ©ããã®ã§ã¯ãªããè€æ°ã®ã¿ã€ãã®ã€ã³ã¿ãŒãã§ãŒã¹ã䜿çšããããšãããããããŸããããŒã¿åæã®åã€ã³ã¿ãŒãã§ãŒã¹ ã¿ã€ãã«ã¯é·æãšçæãããããã¹ãŠã«åªããåäžã®ã€ã³ã¿ãŒãã§ãŒã¹ã¯ãããŸãããããŒã¿ ãããã¥ãŒãµãŒã¯ãåã€ã³ã¿ãŒãã§ãŒã¹ ã¿ã€ãã®é©åæ§ãè©äŸ¡ããéã«ã次ã®ç¹ãèæ ®ããå¿ èŠããããŸãã
- å¿ èŠãªããŒã¿åŠçãå®è¡ã§ããèœåã
- çŸåšããã³å°æ¥ã®ããŒã¿ ã³ã³ã·ã¥ãŒã ãŠãŒã¹ã±ãŒã¹ããµããŒãããã¹ã±ãŒã©ããªãã£ã
- ããŒã¿ ã³ã³ã·ã¥ãŒãã«å¿ èŠãªããã©ãŒãã³ã¹ã
- éçºãšã¡ã³ããã³ã¹ã®ã³ã¹ãã
- ã€ã³ã¿ãŒãã§ãŒã¹ã®å®è¡ã«ãããã³ã¹ãã
- çµç¹ã§äœ¿çšããŠããèšèªãšããŒã«ã«ãããµããŒãã
- ã¹ãã¬ãŒãžãšã³ã³ãã¥ãŒãã£ã³ã°ã®åé¢ã®ãµããŒãã
ããšãã°ããã¿ãã€ãèŠæš¡ã®ããŒã¿ã»ããã«å¯ŸããŠåæã¯ãšãªãå®è¡ã§ããããšãããžãã¹èŠä»¶ã§ããå Žåãå®çšçãªã€ã³ã¿ãŒãã§ãŒã¹ã¯ BigQuery ãã¥ãŒã®ã¿ã§ãããã ããæºãªã¢ã«ã¿ã€ã ã®ã¹ããªãŒãã³ã° ããŒã¿ãæäŸãããšããèŠä»¶ã®å Žåã¯ãPub/Sub ããŒã¹ã®ã€ã³ã¿ãŒãã§ãŒã¹ã®ã»ããé©ããŠããŸãã
ãããã®ã€ã³ã¿ãŒãã§ãŒã¹ã®å€ãã§ã¯ãæ¢åã®ããŒã¿ãã³ããŒãŸãã¯è€è£œããå¿ èŠã¯ãããŸãããã»ãšãã©ã¯ã€ã³ã¿ãŒãã§ãŒã¹ã¯ãGoogle Cloud åæããŒã«ã®éèŠãªæ©èœã§ããã¹ãã¬ãŒãžãšã³ã³ãã¥ãŒãã£ã³ã°ãåé¢ããããšãã§ããŸãããããã®ã€ã³ã¿ãŒãã§ãŒã¹ãä»ããŠå ¬éãããããŒã¿ã®ã³ã³ã·ã¥ãŒãã¯ãå©çšå¯èœãªã³ã³ãã¥ãŒãã£ã³ã° ãªãœãŒã¹ã䜿çšããŠããŒã¿ãåŠçããŸããããŒã¿ ãããã¥ãŒãµãŒã远å ã®ã€ã³ãã©ã¹ãã©ã¯ãã£ã®ããããžã§ãã³ã°ãè¡ãå¿ èŠã¯ãããŸããã
ããŸããŸãªæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ããããŸããããŒã¿ã¡ãã·ã¥ã§äœ¿çšãããæãäžè¬çãªã€ã³ã¿ãŒãã§ãŒã¹ã以äžã«ç€ºããŸãããããã®ã€ã³ã¿ãŒãã§ãŒã¹ã«ã€ããŠã¯ã以éã®ã»ã¯ã·ã§ã³ã§èª¬æããŸãã
- æ¿èªæžã¿ã®ãã¥ãŒãšé¢æ°
- çŽæ¥èªã¿åã API
- ã¹ããªãŒã ãšããŠã®ããŒã¿
- ããŒã¿ã¢ã¯ã»ã¹ API
- Looker Blocks
- æ©æ¢°åŠç¿ïŒMLïŒã¢ãã«
ãªãããã®ããã¥ã¡ã³ãã«èšèŒãããŠããã€ã³ã¿ãŒãã§ãŒã¹ã®ãªã¹ãã¯ããã¹ãŠãç¶²çŸ ããŠããããã§ã¯ãªãããšã«ã泚æãã ãããæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã«ã€ããŠã¯ãBigQuery SharingïŒæ§ Analytics HubïŒãªã©ãä»ã«ãèæ ®ãã¹ããªãã·ã§ã³ããããŸãããã ãããããã®ä»ã®ã€ã³ã¿ãŒãã§ãŒã¹ã«ã€ããŠã¯ãã®ããã¥ã¡ã³ãã§ã¯æ±ããŸããã
æ¿èªæžã¿ã®ãã¥ãŒãšé¢æ°
å¯èœãªéããæ¿èªæžã¿ãã¥ãŒããã³æ¿èªæžã¿é¢æ°ïŒããŒãã«å€é¢æ°ãå«ãïŒä»ããŠããŒã¿ ãããã¯ããå ¬éããå¿ èŠããããŸããæ¿èªæžã¿ããŒã¿ã»ããã䜿çšãããšãè€æ°ã®ãã¥ãŒãèªåçã«æ¿èªã§ããŸããæ¿èªæžã¿ãã¥ãŒã䜿çšãããšãã³ã³ã·ã¥ãŒãã«ãããã¥ãŒã®äœ¿çšã«åœ±é¿ããããšãªããããŒã¹ããŒãã«ãžã®çŽæ¥ã¢ã¯ã»ã¹ãåé¿ããåºã«ãªãããŒãã«ãšã¯ãšãªãæé©åã§ããŸãããã®ã€ã³ã¿ãŒãã§ãŒã¹ã®ã³ã³ã·ã¥ãŒãã¯ãSQL ã䜿çšããŠããŒã¿ãã¯ãšãªããŸããæ¬¡ã®å³ã¯ãæ¿èªæžã¿ããŒã¿ã»ãããæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãšããŠäœ¿çšããæ¹æ³ã瀺ããŠããŸãã
æ¿èªæžã¿ããŒã¿ã»ãããšãã¥ãŒã䜿çšãããšãã€ã³ã¿ãŒãã§ãŒã¹ã®ããŒãžã§ãã³ã°ãç°¡åãªããŸããæ¬¡ã®å³ã«ç€ºãããã«ãããŒã¿ ãããã¥ãŒãµãŒã䜿çšã§ããäž»ãªããŒãžã§ãã³ã° ã¢ãããŒã㯠2 ã€ãããŸãã
ã¢ãããŒãã®æŠèŠã¯æ¬¡ã®ãšããã§ãã
- ããŒã¿ã»ããã®ããŒãžã§ãã³ã°: ãã®ã¢ãããŒãã§ã¯ãããŒã¿ã»ããåãããŒãžã§ãã³ã°ããŸãã
ããŒã¿ã»ããå
ã®ãã¥ãŒãšé¢æ°ã¯ããŒãžã§ãã³ã°ãããŸãããããŒãžã§ã³ã«é¢ä¿ãªãããã¥ãŒãšé¢æ°ã«ã¯åãååã䜿çšããŸããããšãã°ã販売ããŒã¿ã»ããã®æåã®ããŒãžã§ã³ã¯ã
catalog
ãšorders
ã® 2 ã€ã®ãã¥ãŒãæã€sales_v1
ãšããååã®ããŒã¿ã»ããã§å®çŸ©ãããŠããŸãã2 çªç®ã®ããŒãžã§ã³ã§ã¯ã販売ããŒã¿ã»ããã®ååãsales_v2
ã«å€æŽãããŸããããã®ããŒã¿ã»ããå ã®ä»¥åã®ãã¥ãŒã¯ä»¥åã®ååãç¶æããŸãããæ°ããã¹ããŒããå«ãŸããŠããŸãã2 çªç®ã®ããŒãžã§ã³ã®ããŒã¿ã»ããã§ã¯ãæ°ãããã¥ãŒã远å ããããã以åã®ãã¥ãŒãåé€ããããããããšããããŸãã - ãã¥ãŒã®ããŒãžã§ãã³ã°: ãã®ã¢ãããŒãã§ã¯ãããŒã¿ã»ããèªäœã§ã¯ãªããããŒã¿ã»ããå
ã®ãã¥ãŒãããŒãžã§ãã³ã°ãããŸããããšãã°ã販売ããŒã¿ã»ããã§ã¯ãããŒãžã§ã³ã«é¢ä¿ãªã
sales
ãšããååãä¿æãããŸãããã ããããŒã¿ã»ããå ã®ãã¥ãŒã®ååã¯ããã¥ãŒã®æ°ããããŒãžã§ã³ïŒcatalog_v1
ãcatalog_v2
ãorders_v1
ãorders_v2
ãorders_v3
ãªã©ïŒãåæ ããããã«å€æŽãããŸãã
çµç¹ã«æé©ãªããŒãžã§ãã³ã°ã®ã¢ãããŒãã¯ãçµç¹ã®ããªã·ãŒãšãåºã«ãªãããŒã¿ã®æŽæ°ã«ãã£ãŠå€ããªã£ããã¥ãŒã®æ°ã«ãã£ãŠç°ãªããŸããããŒã¿ã»ããã®ããŒãžã§ãã³ã°ã¯ããããã¯ãã®ã¡ãžã£ãŒ ã¢ããããŒããå¿ èŠã§ãã»ãšãã©ã®ãã¥ãŒã倿Žããå¿ èŠãããå Žåã«æé©ã§ãããã¥ãŒã®ããŒãžã§ã³ç®¡çã«ãããç°ãªãããŒã¿ã»ããã§ã¯åãååã®ãã¥ãŒãå°ãªããªããŸãããããŒã¿ã»ããéã®çµåãæ£ããåäœããŠãããã©ããã確èªããæ¹æ³ãªã©ãææ§ã«ãªãå¯èœæ§ããããŸãããã€ããªãã ã¢ãããŒãã¯é©åãªåŠ¥åç¹ã«ãªãå¯èœæ§ããããŸãããã€ããªãã ã¢ãããŒãã§ã¯ãåäžã®ããŒã¿ã»ããå ã§äºææ§ã®ããã¹ããŒã倿Žãèš±å¯ãããäºææ§ã®ãªã倿Žã§ã¯ãæ°ããããŒã¿ã»ãããå¿ èŠã«ãªããŸãã
BigLake ããŒãã«ã«é¢ããèæ ®äºé
æ¿èªæžã¿ãã¥ãŒã¯ãBigQuery ããŒãã«ã ãã§ãªããBigLake ããŒãã«ã§ãäœæã§ããŸããBigLake ããŒãã«ã䜿çšãããšãã³ã³ã·ã¥ãŒã㯠BigQuery SQL ã€ã³ã¿ãŒãã§ãŒã¹ã䜿çšã㊠Cloud Storage ã«ä¿åãããããŒã¿ãã¯ãšãªã§ããŸããBigLake ããŒãã«ã§ã¯ãã现ããªã¢ã¯ã»ã¹å¶åŸ¡ããµããŒããããŠãããããŒã¿ ã³ã³ã·ã¥ãŒããåºç€ãšãªã Cloud Storage ãã±ããã«å¯Ÿããèªã¿åãæš©éãæã£ãŠããå¿ èŠã¯ãããŸããã
ããŒã¿ ãããã¥ãŒãµãŒã¯ãBigLake ããŒãã«ã«ã€ããŠæ¬¡ã®ç¹ãèæ ®ããå¿ èŠããããŸãã
- ãã¡ã€ã«åœ¢åŒãšããŒã¿ ã¬ã€ã¢ãŠãã®èšèšã¯ãã¯ãšãªã®ããã©ãŒãã³ã¹ã«åœ±é¿ããŸããããšãã°ãParquet ã ORC ãªã©ã®åããŒã¹ã®åœ¢åŒã¯ãéåžžãJSON 圢åŒã CSV 圢åŒãããåæã¯ãšãªã®ããã©ãŒãã³ã¹ãã¯ããã«åªããŠããŸãã
- Hive ããŒãã£ã·ã§ã³åå²ã¬ã€ã¢ãŠãã䜿çšãããšãããŒãã£ã·ã§ã³ããã«ãŒãã³ã°ããŠãããŒãã£ã·ã§ãã³ã°åã䜿çšããã¯ãšãªãé«éåã§ããŸãã
- èšè𿮵éã§ã¯ããã¡ã€ã«æ°ãšããã¡ã€ã«ãµã€ãºã«é©ããã¯ãšãª ããã©ãŒãã³ã¹ãèæ ®ããå¿ èŠããããŸãã
BigLake ããŒãã«ã䜿çšããã¯ãšãªãã€ã³ã¿ãŒãã§ãŒã¹ã®ãµãŒãã¹ã¬ãã«å¥çŽïŒSLAïŒèŠä»¶ãæºãããŠãããã調æŽã§ããªãå Žåã¯ã次ã®ã¢ã¯ã·ã§ã³ãããããããŸãã
- ããŒã¿ ã³ã³ã·ã¥ãŒãã«å¯ŸããŠå ¬éããå¿ èŠãããããŒã¿ã¯ãBigQuery ã¹ãã¬ãŒãžã«å€æããŸãã
- BigQuery ããŒãã«ã䜿çšããããã«æ¿èªæžã¿ãã¥ãŒãåå®çŸ©ããŸãã
äžè¬ã«ããã®ã¢ãããŒãã§ã¯ããŒã¿ ã³ã³ã·ã¥ãŒããäžæãããããšã¯ãªãããŸãã¯ãšãªã倿Žããå¿ èŠããããŸãããBigQuery ã¹ãã¬ãŒãžã®ã¯ãšãªã¯ãBigLake ããŒãã«ã§ã¯äžå¯èœãªææ³ã䜿çšããŠæé©åã§ããŸããããšãã°ãBigQuery ã¹ãã¬ãŒãžã§ã¯ãã³ã³ã·ã¥ãŒãã¯ããŒã¹ããŒãã«ãšã¯ç°ãªãããŒãã£ã·ã§ãã³ã°ãšã¯ã©ã¹ã¿ãªã³ã°ãæã€ãããªã¢ã©ã€ãºã ãã¥ãŒãã¯ãšãªã§ãããŸã BigQuery BI Engine ã䜿çšã§ããŸãã
çŽæ¥èªã¿åã API
éåžžãããŒã¿ ãããã¥ãŒãµãŒãããŒã¿ ã³ã³ã·ã¥ãŒãã«ããŒã¹ããŒãã«ãžã®çŽæ¥èªã¿åãã¢ã¯ã»ã¹ãä»äžããããšã¯ããããããŸããããããã©ãŒãã³ã¹ãã³ã¹ããªã©ã®çç±ããããã®ãããªã¢ã¯ã»ã¹ãèš±å¯ããããšã¯å®çšçã§ããå ŽåããããŸãããã®ãããªå Žåã¯ãããŒãã« ã¹ããŒããå®å®ããŠããããã«ãããããç¹ã«æ³šæãå¿ èŠã§ãã
æšæºçãªãŠã§ã¢ããŠã¹å ã®ããŒã¿ã«çŽæ¥ã¢ã¯ã»ã¹ããæ¹æ³ã¯ 2 ã€ãããŸããããŒã¿ ãããã¥ãŒãµãŒã¯ãBigQuery Storage Read APIãCloud Storage JSON ãŸã㯠XML API ã®ããããã䜿çšã§ããŸããæ¬¡ã®å³ã¯ããããã® API ã䜿çšãã 2 ã€ã®ã³ã³ã·ã¥ãŒãã衚ããŠããŸãã1 ã€ã¯æ©æ¢°åŠç¿ïŒMLïŒã®ãŠãŒã¹ã±ãŒã¹ã§ããã 1 ã€ã¯ããŒã¿åŠçãžã§ãã§ãã
çŽæ¥èªã¿åãã€ã³ã¿ãŒãã§ãŒã¹ã®ããŒãžã§ãã³ã°ã¯è€éã§ããéåžžãããŒã¿ ãããã¥ãŒãµãŒã¯å¥ã®ã¹ããŒããæã€å¥ã®ããŒãã«ãäœæããå¿ èŠããããŸãããŸããéæšå¥šããŒãžã§ã³ã®ãã¹ãŠã®ããŒã¿ ã³ã³ã·ã¥ãŒããæ°ããããŒãžã§ã³ã«ç§»è¡ãããŸã§ãããŒãã«ã® 2 ã€ã®ããŒãžã§ã³ãç¶æããå¿ èŠããããŸããã³ã³ã·ã¥ãŒããããŒãã«ã®åæ§ç¯ãšæ°ããã¹ããŒããžã®åãæ¿ãã蚱容ã§ããå Žåã¯ãããŒã¿ã®éè€ãåé¿ã§ããŸããã¹ããŒãã®å€æŽã«äžäœäºææ§ãããå Žåã¯ãããŒã¹ããŒãã«ã®ç§»è¡ãåé¿ã§ããŸããããšãã°ãæ°ããåã®ã¿ã远å ããããããã®åã®ããŒã¿ããã¹ãŠã®è¡ã§ããã¯ãã£ã«ãããå Žåã¯ãããŒã¹ããŒãã«ãç§»è¡ããå¿ èŠã¯ãããŸããã
Storage Read API ãš Cloud Storage API ã®éãã®æŠèŠã以äžã§èª¬æããŸããäžè¬ã«ãããŒã¿ ãããã¥ãŒãµãŒã¯å¯èœãªéããåæã¢ããªã±ãŒã·ã§ã³ãšã㊠BigQuery API ã䜿çšããããšãããããããŸãã
Storage Read API: Storage Read API ã¯ãBigQuery ããŒãã«ã®ããŒã¿ã®èªã¿åããšãBigLake ããŒãã«ã®èªã¿åãã«äœ¿çšã§ããŸãããã® API ã¯ãã£ã«ã¿ãªã³ã°ãšãã现ããã¢ã¯ã»ã¹å¶åŸ¡ããµããŒãããŠãããããå®å®ããããŒã¿åæã ML ã³ã³ã·ã¥ãŒãã«é©ãããªãã·ã§ã³ã§ãã
Cloud Storage API: ããŒã¿ ãããã¥ãŒãµãŒããç¹å®ã® Cloud Storage ãã±ãããããŒã¿ ã³ã³ã·ã¥ãŒããšçŽæ¥å ±æããå¿ èŠãããå ŽåããããŸããããšãã°ãããŒã¿ ãããã¥ãŒãµãŒã¯ãããŒã¿ã³ã³ã·ã¥ãŒãããªãããã®çç±ã§ SQL ã€ã³ã¿ãŒãã§ãŒã¹ã䜿çšã§ããªãå ŽåããŸãã¯Storage Read API ã§ãµããŒããããŠããªãããŒã¿åœ¢åŒããã±ããã«ããå Žåã«ããã±ãããå ±æã§ããŸãã
äžè¬çã«ãããŒã¿ ãããã¥ãŒãµãŒãã¹ãã¬ãŒãž API ãä»ããçŽæ¥ã¢ã¯ã»ã¹ãèš±å¯ããããšã¯ããããããŸãããçŽæ¥ã¢ã¯ã»ã¹ã§ã¯ããã£ã«ã¿ãªã³ã°ããã现ããã¢ã¯ã»ã¹å¶åŸ¡ãè¡ãããšã¯ã§ããŸãããããããå°èŠæš¡ã§å®å®ããïŒã®ã¬ãã€ãã®ïŒããŒã¿ã»ããã«å¯ŸããçŽæ¥ã¢ã¯ã»ã¹ã¯æå¹ãªéžæã§ãã
ãã±ãããžã® Pub/Sub ã¢ã¯ã»ã¹ãèš±å¯ãããšãããŒã¿ ã³ã³ã·ã¥ãŒãã¯ç°¡åã«ããŒã¿ããããžã§ã¯ãã«ã³ããŒããŠåŠçã§ããããã«ãªããŸããäžè¬ã«ãåé¿ã§ããå Žåã¯ããŒã¿ã®ã³ããŒãããããããŸãããããŒã¿ã®ã³ããŒãè€æ°ãããšãã¹ãã¬ãŒãž ã³ã¹ããå¢å ããã¡ã³ããã³ã¹ãšãªããŒãžã®ãã©ããã³ã°ã®ãªãŒããŒããããå¢å ããŸãã
ã¹ããªãŒã ãšããŠã®ããŒã¿
ãã¡ã€ã³ã¯ãPub/Sub ãããã¯ã«ã¹ããªãŒãã³ã° ããŒã¿ããããªãã·ã¥ããããšã§ããã®ããŒã¿ãå ¬éã§ããŸããããŒã¿ã䜿çšãããµãã¹ã¯ã©ã€ããŒã¯ããã®ãããã¯ã«å ¬éãããã¡ãã»ãŒãžã䜿çšãããµãã¹ã¯ãªãã·ã§ã³ãäœæããŸããåãµãã¹ã¯ã©ã€ããŒã¯ããŒã¿ãåå¥ã«åä¿¡ã䜿çšããŸããæ¬¡ã®å³ã¯ããã®ãããªããŒã¿ ã¹ããªãŒã ã®äŸã瀺ããŠããŸãã
ãã®å³ã§ã¯ãåã蟌ã¿ãã€ãã©ã€ã³ãæªå å·¥ã®ã€ãã³ããèªã¿åããæ¡åŒµïŒãã¥ã¬ãŒãïŒãããã®ãã¥ã¬ãŒããããããŒã¿ãåæããŒã¿ã¹ãã¢ïŒBigQuery ããŒã¹ããŒãã«ïŒã«ä¿åããŸããåæã«ããã€ãã©ã€ã³ã¯æ¡å ãããã€ãã³ããå°çšãããã¯ã«ãããªãã·ã¥ããŸãããã®ãããã¯ã¯è€æ°ã®ãµãã¹ã¯ã©ã€ããŒã«ãã£ãŠäœ¿çšãããŸããåãµãã¹ã¯ã©ã€ããŒã¯ããããã®ã€ãã³ãããã£ã«ã¿ãªã³ã°ããŠãåèªã«é¢é£ããã€ãã³ãã®ã¿ãååŸããããšããããŸãããŸãããã€ãã©ã€ã³ã¯ã€ãã³ãçµ±èšãéèšããŠèªèº«ã®ãããã¯ã«å ¬éããå¥ã®ããŒã¿ ã³ã³ã·ã¥ãŒããåŠçã§ããããã«ããŸãã
Pub/Sub ãµãã¹ã¯ãªãã·ã§ã³ã®ãŠãŒã¹ã±ãŒã¹ã®äŸã次ã«ç€ºããŸãã
- æ¡å ãããã€ãã³ãïŒç¹å®ã®é¡§å®¢ã®æ³šæã«é¢ããããŒã¿ãšãšãã«é¡§å®¢ãããã¡ã€ã«æ å ±å šäœãæäŸãããªã©ïŒã
- éå» 15 åéã®åèšæ³šæçµ±èšãªã©ãã»ãŒãªã¢ã«ã¿ã€ã ã®éèšéç¥ã
- æ³šææ°ã忥ã®åãæéãšæ¯ã¹ãŠ 20% æžå°ããå Žåã«ã¢ã©ãŒããçæãããªã©ãããžãã¹ã¬ãã«ã®ã¢ã©ãŒãã
- ç¹å®ã®æ³šæå€æŽã¹ããŒã¿ã¹ãªã©ã®ããŒã¿å€æŽéç¥ïŒå€æŽããŒã¿ ãã£ããã£éç¥ã®ã³ã³ã»ãããšåæ§ïŒã
ããŒã¿ ãããã¥ãŒãµãŒã Pub/Sub ã¡ãã»ãŒãžã«äœ¿çšããããŒã¿åœ¢åŒã¯ãã³ã¹ããšã¡ãã»ãŒãžã®åŠçæ¹æ³ã«åœ±é¿ããŸããããŒã¿ã¡ãã·ã¥ ã¢ãŒããã¯ãã£ã§ã®å€§éã®ã¹ããªãŒã ã«ã¯ãAvro ãŸã㯠Protobuf 圢åŒãé©ããŠããŸããããŒã¿ ãããã¥ãŒãµãŒããããã®åœ¢åŒã䜿çšããå ŽåãPub/Sub ãããã¯ã«ã¹ããŒããå²ãåœãŠãããšãã§ããŸããã¹ããŒãã«ãããã³ã³ã·ã¥ãŒãã¯æ£ãã圢åŒã®ã¡ãã»ãŒãžãåãåãããã«ãªããŸãã
ã¹ããªãŒãã³ã° ããŒã¿æ§é ã¯åžžã«å€åããå¯èœæ§ãããããããã®ã€ã³ã¿ãŒãã§ãŒã¹ã®ããŒãžã§ãã³ã°ã§ã¯ãããŒã¿ ãããã¥ãŒãµãŒãšããŒã¿ ã³ã³ã·ã¥ãŒãã®éã§ã®èª¿æŽãå¿ èŠã«ãªããŸããããŒã¿ ãããã¥ãŒãµãŒãåãããšãã§ããäžè¬çãªã¢ãããŒãã¯æ¬¡ã®ãšããã§ãã
- ã¡ãã»ãŒãžæ§é ã倿Žããããã³ã«ãæ°ãããããã¯ãäœæãããŸããå€ãã®å Žåããã®ãããã¯ã«ã¯æç€ºç㪠Pub/Sub ã¹ããŒããå«ãŸããŸããæ°ããã€ã³ã¿ãŒãã§ãŒã¹ãå¿
èŠãšããããŒã¿ ã³ã³ã·ã¥ãŒãã¯ãæ°ããããŒã¿ã®äœ¿çšãéå§ã§ããŸããã¡ãã»ãŒãž ããŒãžã§ã³ã¯ããããã¯ã®ååïŒ
click_events_v1
ãªã©ïŒã«ãã£ãŠæé»çã«æå®ãããŸããã¡ãã»ãŒãžåœ¢åŒã¯å³å¯ã«åæå®ãããŸããåããããã¯å ã®ã¡ãã»ãŒãžéã§ã¯ã¡ãã»ãŒãžåœ¢åŒã«éãã¯ãããŸããããã®ã¢ãããŒãã®ãã¡ãªããã¯ãããŒã¿ ã³ã³ã·ã¥ãŒããæ°ãããµãã¹ã¯ãªãã·ã§ã³ã«åãæ¿ããããªãå¯èœæ§ãããããšã§ãããã®å ŽåãããŒã¿ ãããã¥ãŒãµãŒã¯ãã°ããã®éããã¹ãŠã®ã¢ã¯ãã£ããªãããã¯ã«ã€ãã³ããå ¬éãç¶ããå¿ èŠãããããããã¯ããµãã¹ã¯ã©ã€ãããããŒã¿ ã³ã³ã·ã¥ãŒãã¯ã¡ãã»ãŒãž ãããŒã®ã®ã£ããã«å¯ŸåŠããããéè€ãæé€ããå¿ èŠããããŸãã - ããŒã¿ã¯åžžã«åããããã¯ã«ãããªãã·ã¥ãããŸãããã ããã¡ãã»ãŒãžã®æ§é ã¯å€æŽãããå¯èœæ§ããããŸããïŒãã€ããŒããšã¯å¥ã«ïŒPub/Sub ã¡ãã»ãŒãžå±æ§ã¯ã¡ãã»ãŒãžã®ããŒãžã§ã³ãå®çŸ©ããŸãïŒäŸ:
v=1.0
ïŒããã®ã¢ãããŒãã«ãããã®ã£ãããéè€ã«å¯ŸåŠããå¿ èŠããªããªããŸãããã ãããã¹ãŠã®ããŒã¿ ã³ã³ã·ã¥ãŒãããæ°ããã¿ã€ãã®ã¡ãã»ãŒãžãåä¿¡ã§ããç¶æ ã§ããå¿ èŠããããŸãããã®ã¢ãããŒãã§ã¯ãããŒã¿ ãããã¥ãŒãµãŒã Pub/Sub ããã㯠ã¹ããŒãã䜿çšã§ããŸããã - ãã€ããªãã ã¢ãããŒããã¡ãã»ãŒãž ã¹ããŒãã«ã¯ãæ°ãããã£ãŒã«ãã«äœ¿çšã§ããä»»æã®ããŒã¿ ã»ã¯ã·ã§ã³ãå«ããããšãã§ããŸãããã®ã¢ãããŒãã§ã¯ãå³å¯ã«åæå®ãããããŒã¿ãæã€ããšãšãé »ç¹ã§è€éãªããŒãžã§ã³å€æŽã®éã§ãé©åãªãã©ã³ã¹ããšãããšãã§ããŸãã
ããŒã¿ã¢ã¯ã»ã¹ API
ããŒã¿ ãããã¥ãŒãµãŒã¯ãããŒã¿ ãŠã§ã¢ããŠã¹å ã®ããŒã¹ããŒãã«ã«çŽæ¥ã¢ã¯ã»ã¹ããããã®ã«ã¹ã¿ã API ãæ§ç¯ã§ããŸããéåžžããããã®ãããã¥ãŒãµãŒã¯ããã®ã«ã¹ã¿ã API ã REST ãŸã㯠gRPC API ãšããŠå ¬éããCloud Run ãŸã㯠Kubernetes ã¯ã©ã¹ã¿ã«ãããã€ããŸããApigee ãªã©ã® API ã²ãŒããŠã§ã€ã¯ããã©ãã£ã㯠ã¹ããããªã³ã°ããã£ãã·ã¥ ã¬ã€ã€ãªã©ããã®ä»ã®è¿œå æ©èœãæäŸã§ããŸãããããã®æ©èœã¯ã Google Cloud çµç¹ã®å€éšã®ã³ã³ã·ã¥ãŒãã«ããŒã¿ã¢ã¯ã»ã¹ API ãå ¬éããéã«åœ¹ç«ã¡ãŸããããŒã¿ã¢ã¯ã»ã¹ API ã®æœåšçãªåè£ã¯ãã¬ã€ãã³ã·ã®åœ±é¿ãåãããããåæå®è¡æ§ã«åªããã¯ãšãªã§ããã©ã¡ãã®ã¯ãšãªãåäž API ã§æ¯èŒçå°ããªçµæã 1 ã€è¿ãã广çã«ãã£ãã·ã¥ã§ããŸãã
ããŒã¿ã¢ã¯ã»ã¹çšã®ãã®ãããªã«ã¹ã¿ã API ã®äŸã次ã«ç€ºããŸãã
- ããŒãã«ãŸãã¯ãããã¯ãã® SLA ææšã®çµã¿åãããã¥ãŒã
- ç¹å®ã®ããŒãã«ã®äžäœ 10 ä»¶ã®ïŒãã£ãã·ã¥ãããŠããå¯èœæ§ãããïŒã¬ã³ãŒãã
- ããŒãã«çµ±èšã®ããŒã¿ã»ããïŒè¡ã®åèšæ°ããŸãã¯ããŒåå ã®ããŒã¿ååžïŒã
ã¢ããªã±ãŒã·ã§ã³ API ã®æ§ç¯ã«é¢ããçµç¹ã®ã¬ã€ãã©ã€ã³ãšã¬ããã³ã¹ã¯ãããŒã¿ ãããã¥ãŒãµãŒãäœæããã«ã¹ã¿ã API ã«ãé©çšãããŸããçµç¹ã®ã¬ã€ãã©ã€ã³ãšã¬ããã³ã¹ã§ã¯ããã¹ãã£ã³ã°ãã¢ãã¿ãªã³ã°ãã¢ã¯ã»ã¹å¶åŸ¡ãããŒãžã§ãã³ã°ãªã©ã®åé¡ã«å¯ŸåŠããå¿ èŠããããŸãã
ã«ã¹ã¿ã API ã®ãã¡ãªããã¯ããã®ã€ã³ã¿ãŒãã§ãŒã¹ã®ãã¹ãã£ã³ã°ã«å¿ èŠãªè¿œå ã®ã€ã³ãã©ã¹ãã©ã¯ãã£ãšãã«ã¹ã¿ã API ã®ã³ãŒãã£ã³ã°ããã³ã¡ã³ããã³ã¹ãããŒã¿ ãããã¥ãŒãµãŒãæ åœããç¹ã§ããããŒã¿ ãããã¥ãŒãµãŒããã«ã¹ã¿ã ããŒã¿ã¢ã¯ã»ã¹ API ã®äœæã決å®ããåã«ãä»ã®ãªãã·ã§ã³ã調ã¹ãŠããããšãããããããŸããããšãã°ãããŒã¿ ãããã¥ãŒãµãŒã¯ BigQuery BI Engine ã䜿çšããŠã¬ã¹ãã³ã¹ã®ã¬ã€ãã³ã·ãççž®ããåæå®è¡æ§ãé«ããããšãã§ããŸãã
Looker Blocks
ããžãã¹ ã€ã³ããªãžã§ã³ã¹ïŒBIïŒããŒã«ã§é »ç¹ã«äœ¿çšããã Looker ãªã©ã®ãããã¯ãã§ã¯ãBI ããŒã«åºæã®ãŠã£ãžã§ããã®ã»ãããç¶æãããšåœ¹ç«ã€ããšããããŸããããŒã¿ ãããã¥ãŒãµãŒ ããŒã ã¯ãã¡ã€ã³ã§äœ¿çšãããŠããåºç€ãšãªãããŒã¿ã¢ãã«ãèªèããŠãããããäºåã«æ§ç¯ãããå¯èŠåã»ããã®äœæãšç¶æã«æé©ã§ãã
Looker ã®å Žåããã®å¯èŠåã¯äžé£ã® Looker BlocksïŒäºåæ§ç¯ããã LookML ããŒã¿ã¢ãã«ïŒã«ãªããŸããLooker Blocks ã¯ãã³ã³ã·ã¥ãŒãããã¹ãããããã·ã¥ããŒãã«ç°¡åã«çµã¿èŸŒããŸãã
ML ã¢ãã«
ããŒã¿ãã¡ã€ã³ã§äœæ¥ããããŒã ã¯ãããŒã¿ãæ·±ãçè§£ããããŒã¿ã«é¢ããç¥èãæã£ãŠãããããå€ãã®å Žåããã¡ã€ã³ããŒã¿ã§ãã¬ãŒãã³ã°ããã ML ã¢ãã«ãæ§ç¯ããŠç¶æããããã®é©ãªããŒã ã§ãããããã® ML ã¢ãã«ã¯ã次ã®ãããªããã€ãã®ã€ã³ã¿ãŒãã§ãŒã¹ãä»ããŠå ¬éã§ããŸãã
- BigQuery ML ã¢ãã«ãå°çšã®ããŒã¿ã»ããã«ãããã€ããBigQuery ãããäºæž¬ã®ããã«ããŒã¿ ã³ã³ã·ã¥ãŒããšå ±æã§ããŸãã
- BigQuery ML ã¢ãã«ã¯ãVertex AI ã«ãšã¯ã¹ããŒãããŠãªã³ã©ã€ã³äºæž¬ã«äœ¿çšã§ããŸãã
æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹çšã®ããŒã¿ ãã±ãŒã·ã§ã³ã«é¢ããèæ ®äºé
ããŒã¿ ãããã¥ãŒãµãŒãããŒã¿ ãããã¯ãã®æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãå®çŸ©ããéã®éèŠãªèæ ®äºé ã¯ãããŒã¿ ãã±ãŒã·ã§ã³ã§ããäžè¬ã«ãã³ã¹ããæå°éã«æããããã«ãããŒã¿ã¯ä¿åãããŠãããªãŒãžã§ã³ãšåããªãŒãžã§ã³ã§åŠçããå¿ èŠããããŸãããã®ã¢ãããŒãã¯ãã¯ãã¹ãªãŒãžã§ã³ã®ããŒã¿äžãïŒå€åãïŒæéã®é²æ¢ã«åœ¹ç«ã¡ãŸãããã®ã¢ãããŒãã§ã¯ããŒã¿æ¶è²»ã®ã¬ã€ãã³ã·ãæå°ã«ãªããŸãããã®ãããªçç±ãããéåžžããã«ããªãŒãžã§ã³ã® BigQuery ãã±ãŒã·ã§ã³ã«ä¿åãããŠããããŒã¿ã¯ãããŒã¿ ãããã¯ããšããŠå ¬éããã®ã«æé©ã§ãã
ãã ãããã©ãŒãã³ã¹äžã®çç±ãããCloud Storage ã«ä¿åãããBigLake ããŒãã«ãŸãã¯çŽæ¥èªã¿åã API ãä»ããŠå ¬éãããããŒã¿ã¯ããªãŒãžã§ã³ ãã±ããã«ä¿åããå¿ èŠããããŸãã
ãããããã¯ãã§å ¬éããããããªãŒãžã§ã³ã«é 眮ãããŠããããŒã¿ããå¥ã®ãªãŒãžã§ã³ã®å¥ã®ãã¡ã€ã³ã®ããŒã¿ãšçµåããå¿ èŠãããå ŽåãããŒã¿ ã³ã³ã·ã¥ãŒãã¯æ¬¡ã®å¶éãèæ ®ããå¿ èŠããããŸãã
- BigQuery SQL ã䜿çšããã¯ãã¹ãªãŒãžã§ã³ ã¯ãšãªã¯ãµããŒããããŠããŸãããããŒã¿ã®äž»ãªå©ç𿹿³ã BigQuery SQL ã®å Žåãã¯ãšãªå ã®ãã¹ãŠã®ããŒãã«ãåããã±ãŒã·ã§ã³ã«ååšããŠããå¿ èŠããããŸãã
- BigQuery ã®å®é¡æéã®ã³ãããã¡ã³ãã¯ãªãŒãžã§ã³å¥ã§ãããããªãŒãžã§ã³ã®ãããžã§ã¯ãã§å®é¡æéã®ã³ãããã¡ã³ãã®ã¿ã䜿çšããŠãããã®ã®ãå¥ã®ãªãŒãžã§ã³ã®ããŒã¿ ãããã¯ãã«ã¯ãšãªãè¡ãå Žåããªã³ããã³ãæéãé©çšãããŸãã
- ããŒã¿ ã³ã³ã·ã¥ãŒãã¯ãçŽæ¥èªã¿åã API ã䜿çšããŠå¥ã®ãªãŒãžã§ã³ããããŒã¿ãèªã¿åãããšãã§ããŸãããã ããã¯ãã¹ãªãŒãžã§ã³ã®ãããã¯ãŒã¯äžãïŒå€åãïŒæéãé©çšãããå€§èŠæš¡ãªããŒã¿è»¢éã§ã¯ããŒã¿ ã³ã³ã·ã¥ãŒãã«ã¬ã€ãã³ã·ãçºçããå¯èœæ§ããããŸãã
ãªãŒãžã§ã³éã§ã¢ã¯ã»ã¹é »åºŠãé«ãããŒã¿ããããã®ãªãŒãžã§ã³ã«ã¬ããªã±ãŒãããããšã§ããããã¯ã ã³ã³ã·ã¥ãŒãã«ããã¯ãšãªã®ã³ã¹ããšã¬ã€ãã³ã·ãäœæžã§ããŸããããšãã°ãBigQuery ã®ããŒã¿ã»ãããä»ã®ãªãŒãžã§ã³ã«ã³ããŒã§ããŸãããã ããããŒã¿ã¯å¿
èŠãªå Žåã«ã®ã¿ã³ããŒããŠãã ãããããŒã¿ ãããã¥ãŒãµãŒã¯ãããŒã¿ãã³ããŒãããšãã«ãå©çšå¯èœãªãããã¯ã ããŒã¿ã®ãµãã»ããã®ã¿ãè€æ°ã®ãªãŒãžã§ã³ã§å©çšã§ããããã«ããããšãããããããŸãããã®ã¢ãããŒãã¯ãã¬ããªã±ãŒã·ã§ã³ ã¬ã€ãã³ã·ãšã³ã¹ããæå°éã«æããããã§åœ¹ç«ã¡ãŸãããã®ã¢ãããŒãã§ã¯ãæç€ºçã«åŒã³åºãããããŒã¿ ãã±ãŒã·ã§ã³ ãªãŒãžã§ã³ãšãè€æ°ã®ããŒãžã§ã³ã®æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãçšæããå¿
èŠãçããå ŽåããããŸããããšãã° BigQuery ã®æ¿èªæžã¿ãã¥ãŒã¯ãsales_eu_v1
ã sales_us_v1
ãªã©ã®ååã§å
¬éã§ããŸãã
Pub/Sub ãããã¯ã䜿çšããããŒã¿ ã¹ããªãŒã ã€ã³ã¿ãŒãã§ãŒã¹ã§ã¯ãã¡ãã»ãŒãžãä¿åãããŠãããªãŒãžã§ã³ãšã¯ç°ãªããªãŒãžã§ã³ã§ã¡ãã»ãŒãžãå©çšããããã«ã远å ã®ã¬ããªã±ãŒã·ã§ã³ ããžãã¯ã¯å¿ èŠãããŸããããã ãããã®å Žåã¯ã¯ãã¹ãªãŒãžã§ã³ã®äžãïŒå€åãïŒæéãé©çšãããŸãã
ããŒã¿ ã³ã³ã·ã¥ãŒããžã®æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ã®å ¬é
ãã®ã»ã¯ã·ã§ã³ã§ã¯ãæœåšçãªã³ã³ã·ã¥ãŒããæ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãæ€åºå¯èœã«ããæ¹æ³ã«ã€ããŠèª¬æããŸããData Catalog ã¯ãçµç¹ãããŒã¿æ€åºãšã¡ã¿ããŒã¿ç®¡çãµãŒãã¹ãæäŸããéã«äœ¿çšã§ãããã«ãããŒãžã ãµãŒãã¹ã§ããããŒã¿ ãããã¥ãŒãµãŒã¯ãããŒã¿ ãããã¯ãã®æ¶è²»ã€ã³ã¿ãŒãã§ãŒã¹ãæ€çŽ¢å¯èœã«ããŠãé©åãªã¡ã¿ããŒã¿ã§ã¢ãããŒã·ã§ã³ãä»ãããããã¯ã ã³ã³ã·ã¥ãŒããã»ã«ããµãŒãã¹ã§ã¢ã¯ã»ã¹ã§ããããã«ããå¿ èŠããããŸããæ°Ž
以éã®ã»ã¯ã·ã§ã³ã§ã¯ãåã€ã³ã¿ãŒãã§ãŒã¹ ã¿ã€ãã Data Catalog ãšã³ããªãšããŠã©ã®ããã«å®çŸ©ããããã«ã€ããŠèª¬æããŸãã
BigQuery ããŒã¹ã® SQL ã€ã³ã¿ãŒãã§ãŒã¹
ãã¯ãã«ã« ã¡ã¿ããŒã¿ïŒå®å šä¿®é£ŸãããããŒãã«åãããŒãã« ã¹ããŒããªã©ïŒã¯ãStorage Read API ã§å©çšå¯èœãªæ¿èªæžã¿ãã¥ãŒãBigLake ãã¥ãŒãBigQuery ããŒãã«ã«èªåçã«ç»é²ãããŸããããŒã¿ ãããã¥ãŒãµãŒããããŒã¿ ãããã¯ã ããã¥ã¡ã³ãã§ãããŒã¿ ã³ã³ã·ã¥ãŒããæ¯æŽããããã®è¿œå æ å ±ãæäŸããããšãããããããŸãã ããšãã°ããŠãŒã¶ãŒããšã³ããªã®ãããã¯ã ããã¥ã¡ã³ããèŠã€ããããããã«ãããŒã¿ ãããã¥ãŒãµãŒã¯ãšã³ããªã«é©çšãããã¿ã°ã® 1 ã€ã« URL ã远å ã§ããŸãããããã¥ãŒãµãŒã¯ä»¥äžã®ãã®ãæäŸã§ããŸãã
- ã¯ãšãªãã£ã«ã¿ã§äœ¿çšãããã¯ã©ã¹ã¿ååã®ã»ããã
- è«çåæåãæã€ãã£ãŒã«ãã®åæå€ïŒåããã£ãŒã«ãèšè¿°ã®äžéšãšããŠæå®ãããŠããªãå ŽåïŒã
- ä»ã®ããŒãã«ãšã®ãµããŒããããçµåã
ããŒã¿ ã¹ããªãŒã
Pub/Sub ãããã¯ã¯ Data Catalog ã«èªåçã«ç»é²ãããŸãããã ãããŒã¿ ãããã¥ãŒãµãŒã¯ãããŒã¿ ãããã¯ãã®ããã¥ã¡ã³ãã§ã¹ããŒããèšè¿°ããå¿ èŠããããŸãã
Cloud Storage API
Data Catalog ã¯ãCloud Storage ãã¡ã€ã« ãšã³ããªãšãã®ã¹ããŒãã®å®çŸ©ããµããŒãããŠããŸããããŒã¿ã¬ã€ã¯ ãã¡ã€ã«ã»ããã Dataplex Universal Catalog ã«ãã£ãŠç®¡çãããŠããå Žåããã®ãã¡ã€ã«ã»ãã㯠Data Catalog ã«èªåçã«ç»é²ãããŸããDataplex Universal Catalog ã«é¢é£ä»ããããŠããªããã¡ã€ã«ã»ããã¯ãå¥ã®æ¹æ³ã§è¿œå ãããŸãã
ãã®ä»ã®ã€ã³ã¿ãŒãã§ãŒã¹
ã«ã¹ã¿ã ãšã³ããªãäœæããããšã§ãData Catalog ããçµã¿èŸŒã¿ãµããŒãããªãä»ã®ã€ã³ã¿ãŒãã§ãŒã¹ã远å ã§ããŸãã
次ã®ã¹ããã
- ããŒã¿ã¡ãã·ã¥ ã¢ãŒããã¯ãã£ã®ãªãã¡ã¬ã³ã¹å®è£ ãåç §ããã
- BigQuery ã®è©³çްã確èªããã
- Dataplex ã«ã€ããŠèªãã
- Cloud ã¢ãŒããã¯ã㣠ã»ã³ã¿ãŒã§ããªãã¡ã¬ã³ã¹ ã¢ãŒããã¯ãã£ãå³ããã¹ã ãã©ã¯ãã£ã¹ã確èªããã