ããã«ã¡ã¯ï¼ãã¯ã©ã¯äºæ¥é¨ æ©æ¢°å¦ç¿ã»ãã¼ã¿é¨ ãã¼ã¿ãã¼ã ã®@TrsNiumã§ãã æã ã®ãã¼ã¿åºç¤ã§ã¯ããã¼ã¿ã«ã¿ãã°ã½ãªã¥ã¼ã·ã§ã³ã¨ãã¦OpenMetadataãå°å ¥ãããã¼ã¿ã®ãã¸ãã¹çãªæå³ï¼ãã¸ãã¹ã¡ã¿ãã¼ã¿ï¼ãéç¨ç¶æ³ãå質æ å ±ï¼ãªãã¬ã¼ã·ã§ãã«ã¡â¦
ããã«ã¡ã¯ï¼ãã¯ã©ã¯äºæ¥é¨ æ©æ¢°å¦ç¿ã»ãã¼ã¿é¨ ãã¼ã¿ãã¼ã ã®@TrsNiumã§ãã å¼ç¤¾ã§ã¯BigQueryã¨Snowflakeä¸ã«ãã¼ã¿åºç¤ãæ§ç¯ãã¦ãã¾ãããã¼ã¿ãã¼ã ã¯ããã®ãã¼ã¿åºç¤ä¸ã«éç©ãããã¼ã¿ãéè¨ãããã¼ã¿ã³ã³ãã¼ãã³ãåãã¦ãåæãæ©æ¢°å¦ç¿ã®ç¨â¦
ã¯ããã« dbtï¼data build toolï¼ Python modelã¨Snowflakeã®Snowparkãæ´»ç¨ãããã¨ã§ããã¼ã¿åå¾ã¨å¤æã®éçºä½é¨ã®åä¸ãå®ç¾ã§ãã¾ããSQLã¯å®£è¨çãªè¨èªã§ãããè¤éãªæç¶ãçãªå¦çãæ¸ãã«ã¯éçãããã¾ããããããdbt Python modelã¯ãã®SQLã®å¼±â¦
ããã«ã¡ã¯ï¼ãã¯ã©ã¯äºæ¥é¨ æ©æ¢°å¦ç¿ã»ãã¼ã¿é¨ ãã¼ã¿ãã¼ã ã®@TrsNiumã§ãã å¼ç¤¾ã§ã¯ãGoogle Cloudã®BigQueryä¸ã«ãã¼ã¿åºç¤ãæ§ç¯ãã¦ãã¾ããBigQueryä¸ã«æ§ç¯ãããã¼ã¿åºç¤ã¯ãdbt (Data Build Tool) ãç¨ãã¦ELTãã¾ããELTã¨ã¯ãExtractï¼æ½åºï¼â¦
ã¯ããã« ããã«ã¡ã¯ï¼ãã¯ã©ã¯äºæ¥é¨ æ©æ¢°å¦ç¿ã»ãã¼ã¿é¨ ãã¼ã¿ãã¼ã ã®@TrsNiumã§ãã å¼ç¤¾ã§ã¯ããã¼ã¿ã®æå³ããã¼ã¿ã®è³ªããã¼ã¿ã®å©æ´»ç¨ãä¸å çã«ç®¡çãããã¨ãç®çã¨ãã¦ããã¼ã¿ã«ã¿ãã°ã½ãªã¥ã¼ã·ã§ã³ã®ä¸ç¨®ã§ããOpenMetadataãå°å ¥ãã¾ãããOâ¦