[B! BigQuery] ishisakaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

ishisaka id:ishisaka

BigQueryã«é–¢ã™ã‚‹ishisakaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (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}}

ã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã¯ã‚‚ã†è¦ã‚‰ãªã„ï¼ŸDuckDBãŒæãã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã®æ–°æ™‚ä»£ ðŸ¦† - Qiita
ç›®çš„ æœ¬ç¨¿ã§ã¯ã€DuckDBãŒã‚‚ãŸã‚‰ã™æ–°ã—ã„ã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã®å¯èƒ½æ€§ã‚’æŽ¢ã‚Šã¾ã™ã€‚ç‰¹ã«ã€2024å¹´æ™‚ç‚¹ã§ä¸»æµãªã€Œã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ã‚¦ãƒˆã€ãƒ¢ãƒ‡ãƒ«ã‚’å‰æã¨ã—ãŸãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚·ã‚¹ãƒ†ãƒ ã‹ã‚‰ã€ã‚ˆã‚Šã‚·ãƒ³ãƒ—ãƒ«ã§åŠ¹çŽ‡çš„ãªã€Œã‚¹ã‚±ãƒ¼ãƒ«ã‚¢ãƒƒãƒ—ã€ãƒ¢ãƒ‡ãƒ«ãŒå°†æ¥çš„ã«ä¸»æµã¨ãªã‚Šå¾—ã‚‹ç†ç”±ã‚’èª¬æ˜Žã—ã¾ã™ã€‚ã¾ãŸã€DuckDBã®æŠ€è¡“çš„ç‰¹æ€§ã€æ³¨ç›®ã•ã‚Œã¦ã„ã‚‹ç†ç”±ã€å…·ä½“çš„ãªãã®ç”¨é€”ã«ã¤ã„ã¦ã‚‚è©³ã—ãè§£èª¬ã—ã¾ã™ã€‚ å¯¾è±¡èªè€… ã‚½ãƒ•ãƒˆã‚¦ã‚§ã‚¢ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒˆï¼šã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã‚„é‹ç”¨ã‚³ã‚¹ãƒˆã®æœ€é©åŒ–ã‚’æ¤œè¨Žã—ã¦ã„ã‚‹äºº ãƒ‡ãƒ¼ã‚¿ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ï¼šã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒ‡ãƒ¼ã‚¿ã‚„ãƒã‚°ãƒ‡ãƒ¼ã‚¿ãªã©ã®æ§˜ã€…ãªãƒ‡ãƒ¼ã‚¿ã‚»ãƒƒãƒˆã‚’åŠ¹çŽ‡çš„ã«å‡¦ç†ã—ãŸã„äºº ã‚·ã‚¹ãƒ†ãƒ ç®¡ç†è€…ãƒ»é‹ç”¨è€…ï¼šã‚¯ãƒ©ã‚¦ãƒ‰ã‚³ã‚¹ãƒˆã®å‰Šæ¸›ã‚„åŠ¹çŽ‡çš„ãªãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚·ã‚¹ãƒ†ãƒ ã‚’æ¨¡ç´¢ã—ã¦ã„ã‚‹äºº æ¦‚è¦ DuckDBã¯ã€ã‚·ãƒ³ãƒ—ãƒ«ãªã‚·ã‚¹ãƒ†ãƒ è¨è¨ˆã‚’å¯èƒ½ã«ã™ã‚‹åˆ—æŒ‡å‘ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã‚¨ãƒ³ã‚¸ãƒ³ã¨ã—ã¦æ³¨ç›®ã‚’é›†ã‚ã¦ã„ã¾ã™ã€‚ BigQueryã‚„Redshiftãªã©ã‚’ä»£è¡¨ã¨ã™ã‚‹å¾“æ¥ã®ã€Œã‚¹ã‚±ãƒ¼
ishisaka 2025/06/15
BigQuery

DB

ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹

programming
ãƒªãƒ³ã‚¯
ãªãœç§ãŸã¡ã¯Sumo Logicã‚’æ¨ã¦ã¦BigQueryã‚’é¸ã‚“ã ã®ã‹ - tech.guitarrapc.cÃ³m
ãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã¯ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ã®ã‚¤ãƒ³ãƒ•ãƒ©ã§ã‚ã‚Šã€ã‚µãƒ¼ãƒ“ã‚¹é–‹ç™º/é‹ç”¨ã®ä¸ã§é‡è¦ãªä½ç½®ã‚’å ã‚ã¾ã™ã€‚ã‚°ãƒ©ãƒ‹ã§ã¯ã€ä»Šå¹´ã«å…¥ã£ã¦åˆ©ç”¨ã—ã¦ã„ã‚‹ãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã‚’ã€ Sumo Logicã‹ã‚‰Google BigQueryã«å®Œå…¨ç§»è¡Œã—ã¾ã—ãŸã€ æœ¬è¨˜äº‹ã¯ã€ã‚°ãƒ©ãƒ‹ã§è°è«–ã•ã‚ŒãŸã€Œãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã¨ã—ã¦ã®SumoLogicã¨BigQueryã€ã®ã¾ã¨ã‚ã‚’æŽ¨æ•²ã€è»¢è¼‰ã—ãŸã‚‚ã®ã§ã™ã€‚ã“ã‚Œã‹ã‚‰ãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã‚’æ¤œè¨Žã•ã‚Œã‚‹æ–¹ã€…ã«ã¨ã£ã¦ã€è°è«–ã®å†…å®¹ãŒå°‘ã—ã§ã‚‚å‚è€ƒã«ãªã‚‹ã“ã¨ã‚’é¡˜ã„å…¬é–‹ã—ã¾ã™ã€‚ ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ ã¾ãšã¯æ–‡è„ˆã‚’æ•´ãˆã‚‹ãŸã‚ã«ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ã‹ã‚‰ã€‚ ã‚¢ã‚¸ã‚§ãƒ³ãƒ€ æ—¥å¸¸çš„ãªã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ç›£è¦–ãƒ•ãƒãƒ¼ APM ã¨ã—ã¦ç›¤çŸ³ãªNew Relic ãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã«ã‚ˆã‚‹ã‚¢ãƒ‰ãƒ›ãƒƒã‚¯ãªãƒã‚°åˆ†æž ãƒã‚°åˆ†æžã‚µãƒ¼ãƒ“ã‚¹ã«æ±‚ã‚ã‚‹ã“ã¨ Sumo Logic ã®åˆ©ç”¨ã¨èª²é¡Œ Sumo Logic ã®åˆ©ç‚¹ Sumo Logicã§ç™ºç”Ÿã—ãŸèª²é¡Œ ãƒã‚°åŽé›†é‡ã®é™ç•Œ ãƒª
ishisaka 2015/08/17
.NET Framework

BigQuery

logging
ãƒªãƒ³ã‚¯
neue cc - LINQ to BigQuery - C#ã«ã‚ˆã‚‹åž‹ä»˜ãDSLã¨LINQPadã«ã‚ˆã‚‹Dumpã¨å¯è¦–åŒ–
ã¨ã€ã„ã†ã‚‚ã®ã‚’ä½œã‚Šã¾ã—ãŸã€‚BigQueryã¯Googleã®ãƒ“ãƒƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚µãƒ¼ãƒ“ã‚¹ã§ã€æœ€è¿‘éžå¸¸ã«è„šå…‰ã‚’æµ´ã³ã¦ã„ã¦ã€ä½•åº¦ã‚‚ã»ã£ã¦ã‚“ã¨ã‚Šã‚„Twitterã«ä¸ŠãŒã£ã¦ããŸã‚Šã—ã¦ã¾ã™ãã€‚è©³ç´°ã¯Google BigQuery ã®è©±ã¨ã‹Googleã®è™Žã®åã€ŒBigQueryã€ã‚’Fluentdãƒ¦ãƒ¼ã‚¶ãƒ¼ãŒä½¿ã‚ãªã„ç†ç”±ãŒãªããªã£ãŸç†ç”±ã‚ãŸã‚ŠãŒã„ã„ã‹ãªã€è¶…ã§ã‹ã„ãƒ‡ãƒ¼ã‚¿ã‚’Googleãƒ‘ãƒ¯ãƒ¼ã§æ•°åƒå°ã®ã‚µãƒ¼ãƒãƒ¼ä¸¦ã¹ã¦ãƒ•ãƒ«ã‚¹ã‚ãƒ£ãƒ³ã™ã‚‹ã‹ã‚‰ã€è¶…é€Ÿãã¦æœ€å¼·ãã€ã¨ã„ã†è©±ã€‚ã§ã€å®Ÿéš›å‡„ã„ã€‚è¶…å‡„ã„ã€‚ã—ã‹ã‚‚å¬‰ã—ã„ã®ãŒæ‰‹é–“ã„ã‚‰ãšãªã¨ã“ã‚ã§ã€æœ€åˆAmazon RedShiftã‚’æ¤œè¨Žã—ã¦è©¦ã—ã¦ã„ãŸã®ã§ã™ãŒã€åˆ—åœ§ç¸®ã‚¨ãƒ³ã‚³ãƒ¼ãƒ‰ã¨ã‹è€ƒãˆã‚‹ã®ã™ã£ã”ãå¤§å¤‰ã ã—ã€å®¹é‡ã‚„ãƒ‘ãƒ¯ãƒ¼ã‚‚ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã‚¿ã‚¤ãƒ—ã¨ç¨ã‚ã£ã“ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ã€‚ãã‚ŒãŒBigQueryã ã¨å®¹é‡ã¯æ ¼å®‰ã ã‹ã‚‰å¤§é‡ã«æ ¼ç´ã§ãã‚‹ã€ãƒãƒ¥ãƒ¼ãƒ‹ãƒ³ã‚°è¨å®šã‚‚ãªã—ã€ã“ã®æ‰‹è»½ã•ï¼ãŠã¾ã‘ã«ã‚¦ã‚§ãƒ–ã‚¤ãƒ³ã‚¿ãƒ¼ãƒ•ã‚§ã‚¤ã‚¹ãŒä¸ã€…å„ªã‚Œ
ishisaka 2014/09/24
BigQuery

linq

C#

.NET Framework
ãƒªãƒ³ã‚¯
ã‚°ãƒ¼ã‚°ãƒ«ã®BigQueryã€å¤§è¦æ¨¡å‡¦ç†ã®ã€Œä»•çµ„ã¿ã¯ç§˜å¯†ã§ã™ã€
å…ˆé€±è¡Œã‚ã‚ŒãŸã‚°ãƒ¼ã‚°ãƒ«ã®ã‚¤ãƒ™ãƒ³ãƒˆã€ŒGoogle I/Oã€ã§ç™ºè¡¨ã•ã‚ŒãŸã€å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿ã‚’SQLãƒ©ã‚¤ã‚¯ãªå‘½ä»¤ã«ã‚ˆã£ã¦é«˜é€Ÿã«å‡¦ç†ã—ã¦ãã‚Œã‚‹æ–°ã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ã€‚3æ—¥å‰ã«å…¬é–‹ã—ãŸè¨˜äº‹ã€Œã‚°ãƒ¼ã‚°ãƒ«ã«ã‚ˆã‚‹MapReduceã‚µãƒ¼ãƒ“ã‚¹ã€ŒBigQueryã€ãŒç™»å ´ã€‚SQLãƒ©ã‚¤ã‚¯ãªå‘½ä»¤ã§å¤§è¦æ¨¡ãƒ‡ãƒ¼ã‚¿æ“ä½œã€ã§ã€ãã®æ¦‚è¦ã‚’ãŠä¼ãˆã—ã¾ã—ãŸã€‚ ãã®BigQueryã«ã¤ã„ã¦ã€Google I/Oã®ã‚»ãƒƒã‚·ãƒ§ãƒ³ã«å‚åŠ ã•ã‚Œã¦ã„ãŸã‚¹ãƒ†ã‚£ãƒ«ãƒã‚¦ã‚¹ ä½è—¤ä¸€æ†²æ°ãŒã€ŒBigQueryã£ã¦ãªã‚“ãžï¼Ÿã€ã¨ã‚¨ãƒ³ãƒˆãƒªã‚’ãƒ–ãƒã‚°ã«æ›¸ã„ã¦ã„ã¾ã™ã€‚è‡ªç”±ã«ã‚³ãƒ”ãƒšã—ã¦ã„ã„ã¨è¨±å¯ã‚’ã„ãŸã ã„ãŸã®ã§ã€ã‚ã‚‰ãŸã‚ã¦BigQueryã¨ã¯ã©ã‚“ãªã‚‚ã®ãªã®ã‹ã€ãƒã‚¤ãƒ³ãƒˆã‚’ç´¹ä»‹ã—ã¾ã—ã‚‡ã†ã€‚ å¤§è¦æ¨¡ãªãƒ‡ãƒ¼ã‚¿ã‚’å‡¦ç†ã§ãã‚‹ã¨ã„ãˆã°ã€æ€ã„æµ®ã‹ã¶ã®ã¯MapReduceã§ã™ã€‚ä½è—¤æ°ã¯BigQueryã¨MapReduceã®é•ã„ã‚’ã“ã†æ›¸ã„ã¦ã„ã¾ã™ã€‚ MapReduceã¨ã¯ã©ã†é•ã†ï¼Ÿ å¤§è¦æ¨¡ãª
ishisaka 2010/05/28
BigQuery

Google
ãƒªãƒ³ã‚¯
1