[B! dbt] takaya030ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

takaya030 id:takaya030

dbtã«é–¢ã™ã‚‹takaya030ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

dbtã®ãƒ¢ãƒ‡ãƒ«ã¨Tableauä¸Šã§ä½¿ã‚ã‚Œã¦ã„ã‚‹Workbookã®ä¾å˜é–¢ä¿‚ã‚’exposureã§è¡¨ç¾ã—ã¦ã€ãƒ‡ãƒ¼ã‚¿ç®¡ç†ã‚’åŠ¹çŽ‡çš„ã«è¡ŒãªãŠã† - yasuhisa's blog
3è¡Œã¾ã¨ã‚ dbtã®ã‚¸ãƒ§ãƒ–ãŒå¤±æ•—ã—ãŸéš›ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å»ƒæ¢æ¤œè¨Žã®éš›ã«ã€BIä¸Šã®ã©ã®ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã§åˆ©ç”¨ã•ã‚Œã¦ã„ã‚‹(ãƒ‡ãƒ¼ã‚¿ãƒªãƒãƒ¼ã‚¸)ã‹çŸ¥ã‚‹ã®ã¯é‡è¦ã§ã™ Tableauã®GraphQLã®APIã‹ã‚‰Workbookã¨BigQueryä¸Šã®ãƒ¢ãƒ‡ãƒ«ã®åŸ‹ã‚è¾¼ã¿ã®é–¢ä¿‚ã‚’çŸ¥ã‚‹ã“ã¨ãŒã§ãã¾ã™ dbtã®ãƒ¢ãƒ‡ãƒ«ã¨Tableauä¸Šã§ä½¿ã‚ã‚Œã¦ã„ã‚‹Workbookã®ä¾å˜é–¢ä¿‚ã‚’exposureã¨ã—ã¦å‡ºåŠ›ã™ã‚‹ã‚¹ã‚¯ãƒªãƒ—ãƒˆã«ã‚ˆã‚Šã€dbtã®ã‚¸ãƒ§ãƒ–ã®å¤±æ•—ã‚„ãƒ†ãƒ¼ãƒ–ãƒ«ã®å»ƒæ¢ãŒTableauã®ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã«ä¸Žãˆã‚‹å½±éŸ¿ãªã©ã‚’èª¿ã¹ã‚„ã™ããªã‚Šã¾ã—ãŸ 3è¡Œã¾ã¨ã‚ èƒŒæ™¯ èª²é¡Œ: dbtã®exposureã¨ã—ã¦ãƒ€ãƒƒã‚·ãƒ¥ãƒœãƒ¼ãƒ‰ã‚’æ‰‹å‹•ã§è¨˜å…¥ã—ç¶šã‘ã‚‹ã®ã¯é›£ã—ã„ è§£æ±ºæ–¹æ³•: Tableauã®GraphQLã®APIã‚’ä½¿ã„ã€ dbtã®exposureã‚’è‡ªå‹•ç”Ÿæˆã™ã‚‹ ç™ºå±•çš„è©±é¡Œ èƒŒæ™¯ æ¥å‹™ã«ãŠã„ã¦ã€DWHã‚„ãƒ‡ãƒ¼ã‚¿ãƒžãƒ¼ãƒˆã®ç”Ÿæˆã«dbtã‚’ã€BIãƒ„ãƒ¼ãƒ«ã¨ã—ã¦Tablea
takaya030 2023/10/09
bigquery

dbt

tableau
ãƒªãƒ³ã‚¯
æ´¾ç”Ÿå…ˆãƒ†ãƒ¼ãƒ–ãƒ«ã®å‚ç…§å›žæ•°ã‚‚è€ƒæ…®ã—ã¦å®‰å…¨ã«ãƒ†ãƒ¼ãƒ–ãƒ«ã‚’æ’¤é€€ã™ã‚‹ - yasuhisa's blog
3è¡Œã¾ã¨ã‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ’¤é€€æ™‚ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«ã®å‚ç…§å›žæ•°ã‚’è¦‹ã‚‹ã“ã¨ãŒå¤šã„ã¨æ€ã„ã¾ã™ãŒã€ãƒ†ãƒ¼ãƒ–ãƒ«å˜ç‹¬ã®å‚ç…§å›žæ•°ã‚’è¦‹ã‚‹ã ã‘ã ã¨ä¸ååˆ†ãªã“ã¨ãŒå¤šã„ã§ã™ æ´¾ç”Ÿå…ˆã®ãƒ†ãƒ¼ãƒ–ãƒ«ã®å‚ç…§å›žæ•°ã¾ã§è€ƒæ…®ã™ã‚‹ã¨ã€ãƒ†ãƒ¼ãƒ–ãƒ«ãŒæ’¤é€€ã§ãã‚‹ã‹å®‰å…¨ã«åˆ¤æ–ã™ã‚‹ã“ã¨ãŒã§ãã¾ã™ ãƒªãƒãƒ¼ã‚¸ä¸Šã®è¦ªåé–¢ä¿‚ã‚’WITH RECURSIVEã§è€ƒæ…®ã—ãªãŒã‚‰ã€ç´¯ç©å‚ç…§å›žæ•°ã‚’SQLã§å°Žå‡ºã§ãã‚‹ã‚ˆã†ã«ã—ã€å®‰å…¨ã«ãƒ†ãƒ¼ãƒ–ãƒ«æ’¤é€€ã‚’åˆ¤æ–ã§ãã‚‹ã‚ˆã†ã«ã—ã¾ã—ãŸ 3è¡Œã¾ã¨ã‚ èƒŒæ™¯: ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ’¤é€€ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«å˜ç‹¬ã®å‚ç…§å›žæ•°ã‚’è¦‹ã‚‹ã ã‘ã ã¨ä¸ååˆ† ã‚¢ã‚¤ãƒ‡ã‚£ã‚¢: ç´¯ç©å‚ç…§å›žæ•°ã‚’è¨ˆç®—ã™ã‚‹ å®Ÿè£… ãƒ†ãƒ¼ãƒ–ãƒ«é–“ã®è¦ªåé–¢ä¿‚ã‚’æŠ½å‡ºã™ã‚‹ WITH RECURSIVEã§ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¦ªåé–¢ä¿‚ã‚’è¾¿ã‚‹ ãƒ†ãƒ¼ãƒ–ãƒ«ã®è¦ªåé–¢ä¿‚ã‚’è€ƒæ…®ã—ãªãŒã‚‰ã€ç´¯ç©å‚ç…§å›žæ•°ã‚’è¨ˆç®—ã™ã‚‹ ã¾ã¨ã‚ èƒŒæ™¯: ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ’¤é€€ã«ã¯ãƒ†ãƒ¼ãƒ–ãƒ«å˜ç‹¬ã®å‚ç…§å›žæ•°ã‚’è¦‹ã‚‹ã ã‘ã ã¨ä¸ååˆ† ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã‚„ã‚¢ãƒŠãƒªãƒ†ã‚£ã‚¯ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ã®ä»•äº‹ã‚’ã—ã¦ã„ã‚‹ã¨ã€
takaya030 2023/10/09
bigquery

dbt
ãƒªãƒ³ã‚¯
dbtã®å…¬å¼å…¥é–€ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ŽQuickstart for dbt Cloud and BigQueryã€ã‚’å®Ÿè·µã—ã¦ã¿ãŸ #dbt | DevelopersIO
dbtã§ã¯å…¬å¼ãƒ»éžå…¬å¼ã‚’å«ã‚ã€éžå¸¸ã«å¤šãã®Webè³‡æ–™ãŒå…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚dbtãŒã©ã‚“ãªæ©Ÿèƒ½ã‚’å‚™ãˆã¦ã„ã‚‹ã®ã‹ã€ã©ã‚“ãªUIã‚„ç”»é¢ãƒ‡ã‚¶ã‚¤ãƒ³ãªã®ã‹ã‚’æŠŠæ¡ã™ã‚‹ã®ã¯ã‚„ã¯ã‚Šå®Ÿéš›ã«ãƒ¢ãƒŽã‚’å‹•ã‹ã—ã¦è©¦ã—ã¦ã¿ã‚‹ã€æŒ™å‹•ã‚’ä½“é¨“ã—ã¦ã¿ã‚‹ã¨ã„ã†ã®ãŒä¸€ç•ªã§ã™ãã€‚ ãã“ã§å½“ã‚¨ãƒ³ãƒˆãƒªã§ã¯ã€å…¨15ãƒ‘ãƒ¼ãƒˆã§æ§‹æˆã•ã‚Œã¦ã„ã‚‹dbtå…¬å¼ã®å…¥é–€å‘ã‘ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã€ŽQuickstart for dbt Cloud and BigQueryã€ã‚’å®Ÿéš›ã«è©¦ã—ãŸå†…å®¹ã‚’ãŠå±Šã‘ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ ç›®æ¬¡ 01.ã¯ã˜ã‚ã« 02.æ–°ã—ã„Google Cloudãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã‚’ä½œæˆ 03.BigQueryãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã®ä½œæˆ 04.BigQueryç’°å¢ƒã¸ã‚¢ã‚¯ã‚»ã‚¹ã™ã‚‹ãŸã‚ã®èªè¨¼æƒ…å ±ã‚’ä½œæˆ 05.dbt Cloudç’°å¢ƒã‹ã‚‰BigQueryã«æŽ¥ç¶š 06.dbt Cloudç®¡ç†ã®ãƒªãƒã‚¸ãƒˆãƒªã‚’è¨å®š 07.dbt ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã®åˆæœŸåŒ–ã¨é–‹ç™ºã®é–‹å§‹ 08.ã¯ã˜ã‚ã¦ã®ãƒ¢ãƒ‡ãƒ«æ§‹ç¯‰ 0
takaya030 2023/08/30
dbt

cloud

bigquery
ãƒªãƒ³ã‚¯
vscode-dbt-power-userã§dbtã®é–‹ç™ºã‚„ãƒ¬ãƒ“ãƒ¥ãƒ¼ã‚’åŠ¹çŽ‡åŒ–ã™ã‚‹ - yasuhisa's blog
èƒŒæ™¯ vscode-dbt-power-userãŒã‚ˆã‹ã£ãŸã¨ã“ã‚ å®šç¾©ã«ã•ã£ã¨è¡Œã‘ã‚‹ / æˆ»ã‚Œã‚‹(Go to definitionãŒä½¿ãˆã‚‹) VSCodeå†…ã§ãƒ¢ãƒ‡ãƒ«é–“ã®ãƒªãƒãƒ¼ã‚¸ãŒè¦‹ã‚Œã‚‹ VSCodeå†…ã‹ã‚‰dbtã®ãƒ¢ãƒ‡ãƒ«ã‚’ã•ã£ã¨å®Ÿè¡Œã§ãã‚‹ ãƒ¢ãƒ‡ãƒ«ãƒ•ã‚¡ã‚¤ãƒ«ã®å˜ç‹¬ã®å®Ÿè¡Œã‚‚ç°¡å˜ ã‚³ãƒ³ãƒ‘ã‚¤ãƒ«æ¸ˆã¿ã®SQLãƒ•ã‚¡ã‚¤ãƒ«ã‚’ã•ã£ã¨ãƒ—ãƒ¬ãƒ“ãƒ¥ãƒ¼ã§ãã‚‹ ã¾ã¨ã‚ è£œè¶³: vscode-dbt-power-userã®å°Žå…¥æ–¹æ³• èƒŒæ™¯ dbtã¯å‰è·æ™‚ä»£ã‹ã‚‰å«ã‚ã‚‹ã¨äºŒå¹´ä»¥ä¸Šä½¿ã£ã¦ã„ã¦ã€SQLã§DWHã‚„ãƒ‡ãƒ¼ã‚¿ãƒžãƒ¼ãƒˆã®é–‹ç™ºã‚’ã—ã‚ˆã†ã¨æ€ã†ã¨ã‚‚ã¯ã‚„ã“ã‚Œãªã—ã§ã¯ç”Ÿãã‚‰ã‚Œãªã„ãã‚‰ã„ã«ã¯ä¾¿åˆ©ã«ãªã£ã¦ã„ã‚‹ã€‚dbtãŒã‚ã£ã¦ã‚‚å¤§å¤‰ãªã‚¯ã‚¨ãƒªã¯å¤§å¤‰ã§ã¯ã‚ã‚‹ãŒã€å¤§å¤‰ã•ã¯å¤§åˆ†ç·©å’Œã—ã¦ãã‚Œã‚‹ã€‚dbtãŒãªãã¦ã€1ã¤ã®SQLãŒ1000è¡Œä»¥ä¸Šã‚ã‚Šã€ä¸é–“ã‚¯ã‚¨ãƒªãŒãƒ†ã‚¹ãƒˆã‚‚ã•ã‚Œã¦ã„ãªã„ã€ã¨ã„ã†çŠ¶æ³ã¯ã‚‚ã†æˆ»ã‚ŠãŸããªã„...ã€‚ dbtã«é™ã‚‰ãšã§ã‚ã‚‹ãŒã€ã‚³ãƒ¼ãƒ‰ã¯æ›¸ã„ã¦ã„ã‚‹ã¨
takaya030 2023/07/09
dbt

vscode
ãƒªãƒ³ã‚¯
1