TBM Templateã®åæã»ããã¢ãããæ¯æŽããŸããDocker Composeç°å¢ã®æ§ç¯ããµã³ãã«ããŒã¿ã®ããŒããGrafanaããã·ã¥ããŒãã®åäœç¢ºèªããã©ãã«ã·ã¥ãŒãã£ã³ã°ãè¡ããŸãããã»ããã¢ããããç°å¢æ§ç¯ããåæèšå®ããdocker compose upããTBMãå§ãããããdbt seedãå®è¡ããGrafanaã衚瀺ãããªãããã³ã³ãããèµ·åããªãããããŒããç«¶åããTBMç°å¢ãç«ã¡äžãããªã©ã®ããŒã¯ãŒãã§çºåããŸãã
TBM Templateã®dltã³ãã¯ã¿ã®è¿œå ã»ã«ã¹ã¿ãã€ãºãæ¯æŽããŸããæ°ããå€éšãµãŒãã¹ããã®ããŒã¿åéãã€ãã©ã€ã³ã®æ§ç¯ãæ¢åã³ãã¯ã¿ã®ã¢ãã¯ããå®APIãžã®å€æŽãããŒã¿ãœãŒã¹è¿œå ãè¡ããŸãããã³ãã¯ã¿ã远å ããããŒã¿åéãèšå®ããdltãã€ãã©ã€ã³ãäœæããå€éšãµãŒãã¹ãæ¥ç¶ããAPIããããŒã¿ãååŸããã¢ãã¯ãå®ããŒã¿ã«å€æŽããæ°ããããŒã¿ãœãŒã¹ããTBMããŒã¿åéããªã©ã®ããŒã¯ãŒãã§çºåããŸãã
TBM Templateã®å ±æãªãœãŒã¹ãæäŸããå éšã¹ãã«ã§ããä»ã®tbmç³»ã¹ãã«ããåç §ãããŸããçŽæ¥ããªã¬ãŒãããããšã¯æ³å®ããŠããŸããã
TBM Templateã®é 賊ã«ãŒã«ã»ãã¹ã¿ãŒããŒã¿ã»ã³ã¹ãããŒã¿ã®ã«ã¹ã¿ãã€ãºãæ¯æŽããŸããCSVã·ãŒããã¡ã€ã«ã®ç·šéãæ°ããéšéããµãŒãã¹ã®è¿œå ãé 賊æ¯çã®å€æŽãã³ã¹ãããŒã¿ã®è¿œå ã»æŽæ°ãªã©ãè¡ããŸãããé 賊ã«ãŒã«ã倿Žããéšéã远å ããã³ã¹ãããŒã¿ãæŽæ°ãããµãŒãã¹ã远å ããããžãã¹ã±ã€ãããªãã£ã远å ããäºç®ããŒã¿ãç·šéããã·ãŒããæŽæ°ããTBMããŒã¿ãã«ã¹ã¿ãã€ãºããªã©ã®ããŒã¯ãŒãã§çºåããŸãã
TBM Templateã®Grafanaããã·ã¥ããŒãã®è¿œå ã»ç·šéãæ¯æŽããŸããæ°ããããã·ã¥ããŒãã®äœæãæ¢åããã·ã¥ããŒããžã®ããã«è¿œå ãSQLã¯ãšãªã®äœæãå¯èŠåã®èª¿æŽãè¡ããŸãããããã·ã¥ããŒãã远å ããGrafanaããã«ãäœæããã°ã©ãã远å ããå¯èŠåã倿Žããããã·ã¥ããŒããç·šéããTBMã®å¯èŠåããªã©ã®ããŒã¯ãŒãã§çºåããŸãã
TBM Templateã®dbtã¢ãã«ã®è¿œå ã»å€æŽãæ¯æŽããŸããæ°ããé 賊ã¹ãããã®è¿œå ãéèšããŒãã®äœæãã¹ããŒãžã³ã°ã¢ãã«ã®è¿œå ãæ¢åã¢ãã«ã®æ¡åŒµãè¡ããŸãããdbtã¢ãã«ã远å ããæ°ããããŒããäœæããé 賊ã¹ãããã远å ããéèšã¢ãã«ã倿Žããã¹ããŒãžã³ã°ã远å ããdbtã®SQLãä¿®æ£ããTBMã¢ãã«ãæ¡åŒµããªã©ã®ããŒã¯ãŒãã§çºåããŸãã