[B! snowflake] uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

uokada id:uokada

snowflakeã«é–¢ã™ã‚‹uokadaã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (10)

${{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}}

ãªãœãƒˆãƒ¨ã‚¿ã¯ãƒšã‚¿ãƒã‚¤ãƒˆç´šãƒ‡ãƒ¼ã‚¿ã‚’ã‚³ãƒ”ãƒ¼ã›ãšã«æ°‘ä¸»åŒ–ã§ããŸã®ã‹ï¼ŸSnowflake Summit 2025 Builders Keynoteã§æ˜Žã‹ã•ã‚ŒãŸç§˜è¨£ 2025/06/07 ï½œano
Snowflakeã¯ç±³å›½ã®ã‚¯ãƒ©ã‚¦ãƒ‰åž‹ãƒ‡ãƒ¼ã‚¿ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ã§ã™ã€‚å¾“æ¥ã®ãƒ‡ãƒ¼ã‚¿ã‚¦ã‚§ã‚¢ãƒã‚¦ã‚¹ã¨ãƒ‡ãƒ¼ã‚¿ãƒ¬ã‚¤ã‚¯ã‚’çµ±åˆã—ãŸã€Œãƒ‡ãƒ¼ã‚¿ã‚¯ãƒ©ã‚¦ãƒ‰ã€ã¨ã—ã¦ã€æ§‹é€ åŒ–ãƒ»åŠæ§‹é€ åŒ–ãƒ»éžæ§‹é€ åŒ–ãƒ‡ãƒ¼ã‚¿ã‚’ä¸€å…ƒç®¡ç†ã§ãã¾ã™ã€‚ ç‹¬è‡ªã®3å±¤ã‚¢ãƒ¼ã‚ãƒ†ã‚¯ãƒãƒ£ï¼ˆã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã€ã‚³ãƒ³ãƒ”ãƒ¥ãƒ¼ãƒˆã€ã‚¯ãƒ©ã‚¦ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ï¼‰ã«ã‚ˆã‚ŠAWSã€GCPã€Azureä¸Šã§æŸ”è»Ÿã«ã‚¹ã‚±ãƒ¼ãƒ«ã—ã€é«˜é€Ÿãƒ‡ãƒ¼ã‚¿å‡¦ç†ã‚’å®Ÿç¾ã—ã¾ã™ã€‚ãƒ•ãƒ«ãƒžãƒãƒ¼ã‚¸ãƒ‰ã‚µãƒ¼ãƒ“ã‚¹ã®ãŸã‚é‹ç”¨è² è·ãŒè»½æ¸›ã•ã‚Œã€ä¼æ¥å†…å¤–ã§ã®ãƒ‡ãƒ¼ã‚¿å…±æœ‰ã¨ã‚³ãƒ©ãƒœãƒ¬ãƒ¼ã‚·ãƒ§ãƒ³ã‚’ä¿ƒé€²ã™ã‚‹æ¬¡ä¸–ä»£ãƒ‡ãƒ¼ã‚¿æ´»ç”¨åŸºç›¤ã¨ã—ã¦å¤šãã®ä¼æ¥ã§æŽ¡ç”¨ã•ã‚Œã¦ã„ã¾ã™ã€‚ 1. é–‹ä¼šæŒ¨æ‹¶ã¨ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ç´¹ä»‹ã“ã®ã‚»ã‚¯ã‚·ãƒ§ãƒ³ã§ã¯ã€Snowflake Summitã®åŸºèª¿è¬›æ¼”ã®å†’é éƒ¨åˆ†ã¨ã—ã¦ã€å‚åŠ è€…ã¸ã®æ“è¿Žã®æŒ¨æ‹¶ã¨ã€Snowflakeã‚’æ”¯ãˆã‚‹Builderã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®ç¾çŠ¶ã«ã¤ã„ã¦ç´¹ä»‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ 1.1. Builderã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®æˆé•·ã¨ç¾çŠ¶ã‚³ãƒŸãƒ¥ãƒ‹ãƒ†ã‚£ã®è¦æ¨¡ã¨æˆé•· Sn
uokada 2025/07/19
snowflake
ãƒªãƒ³ã‚¯
Snowflake introduces SQL Spread Operator (**)
uokada 2025/04/25
snowflake
ãƒªãƒ³ã‚¯
Snowflakeã®ãƒãƒ¼ãƒ«éšŽå±¤è¨è¨ˆã¡ã‚ƒã‚“ã¨ã—ã¦ã¾ã™ã‹ï¼Ÿ | DevelopersIO
ãƒ‡ãƒ¼ã‚¿äº‹æ¥æœ¬éƒ¨ã®è’æœ¨ã§ã™ã€‚ Snowflakeã®ãƒãƒ¼ãƒ«ã‚’æ¥å‹™ã§é‹ç”¨ã—ã¦ã„ã‚‹ã¨ã€ãƒãƒ¼ãƒ«ã®æ•°ãŒå¤šããªã£ãŸã‚Šã€ã©ã®ãƒãƒ¼ãƒ«ã«ã©ã®æ¨©é™ãŒã¤ã„ã¦ã„ã‚‹ã‹åˆ†ã‹ã‚Šã¥ã‚‰ããªã‚Šç®¡ç†ãŒå¤§å¤‰ã«ãªã£ãŸã‚Šã™ã‚‹ã“ã¨ã‚ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ å®Ÿéš›ã«ç§ã‚‚é‹ç”¨ã—ã¦ã„ãä¸ã§ã€Snowflakeã®ãƒãƒ¼ãƒ«ã‚„æ¨©é™ã¯è‡ªç”±åº¦ãŒé«˜ãã©ã†ã„ã†è¨å®šã‚’ã—ãŸã‚‰ã„ã„ã®ã ã‚ã†ã€‚ã€‚ã¨æ‚©ã‚“ã§ã¾ã—ãŸã€‚ å…¬å¼ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆã«ã‚‚ãƒãƒ¼ãƒ«ã®æŽ¨å¥¨æ§‹æˆã«ã¤ã„ã¦è¨˜è¼‰ã—ã¦ã„ã¾ã™ãŒã€ã‚µãƒ³ãƒ—ãƒ«æ§‹æˆãªã©å…·ä½“çš„ãªæ§‹æˆã§å‚è€ƒæ–‡çŒ®ãŒã‚ã¾ã‚Šãªã‹ã£ãŸã®ã§ã€è‰²ã€…æ¤œè¨Žã—ãŸSnowflakeã®ãƒãƒ¼ãƒ«æ§‹æˆã«ã¤ã„ã¦ç´¹ä»‹ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Snowflakeãƒãƒ¼ãƒ«ã«ã¤ã„ã¦ ã¾ãšSnowflakeã®ãƒãƒ¼ãƒ«ã«ã¤ã„ã¦ç°¡å˜ã«èª¬æ˜Žã—ã¾ã™ã€‚ ãƒãƒ¼ãƒ«ã¨ã¯ Snowflakeã®ãƒãƒ¼ãƒ«ã¯ã€ã€Œã‚»ã‚ãƒ¥ãƒªãƒ†ã‚£ä¿è·å¯èƒ½ãªã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã«å¯¾ã™ã‚‹æ¨©é™ã®ä»˜ä¸Žã‚„å–ã‚Šæ¶ˆã—ãŒã§ãã‚‹ã‚¨ãƒ³ãƒ†ã‚£ãƒ†ã‚£ã€ã‚’æ„å‘³ã—ã¦ã„ã¾ã™ã€‚ è¦ã¯Snowflakeå†…ã«ä½œæˆã•ã‚Œ
uokada 2024/08/16
snowflake
ãƒªãƒ³ã‚¯
Support set column type for Snowflake connector by chenjian2664 Â· Pull Request #21395 Â· trinodb/trino
uokada 2024/04/17
snowflake
ãƒªãƒ³ã‚¯
7å¹´ä½¿ã£ãŸRedshiftã‹ã‚‰6ãƒ¶æœˆã‹ã‘ã¦Snowflakeã¸ç§»è¡Œã—ãŸè©±ã€€ã€œæ‰‹ã®å†…å…¨éƒ¨ãŠè¦‹ã›ã—ã¾ã™ã€œ
SNOWDAY JAPAN 2023ã§ã€Œ7å¹´ä½¿ã£ãŸRedshiftã‹ã‚‰6ãƒ¶æœˆã‹ã‘ã¦Snowflakeã¸ç§»è¡Œã—ãŸè©±ã€€ã€œæ‰‹ã®å†…å…¨éƒ¨ãŠè¦‹ã›ã—ã¾ã™ã€œã€ã¨ã„ã†ã‚¿ã‚¤ãƒˆãƒ«ã§ç™»å£‡ã—ãŸè³‡æ–™ã§ã™ã€‚ https://www.snowflake.com/about/events/snowday-japan-2023/?lanâ€¦
uokada 2023/05/15
snowflake

redshift
ãƒªãƒ³ã‚¯
è»½é‡ãªTime-based IDç”Ÿæˆå™¨â€shakeflake(ä»®ç§°)â€ã«ã¤ã„ã¦ - SmartNews Engineering Blog
å¤§å¹³ã§ã™ã€‚ä»Šå›žã¯ã•ã ã¾ã•ã—ãƒã‚¿ã¯ç‰¹ã«ç„¡ã—ã§ã™ã€‚ å…ˆæ—¥ã€ã‚µãƒ¼ãƒ“ã‚¹ã®ã‚¯ãƒãƒ¼ãƒ©ãƒ¼ã§ä½¿ç”¨ã—ã¦ã„ã‚‹IDç”Ÿæˆå™¨ã«ã¤ã„ã¦ç½®ãæ›ãˆã‚’è¡Œã„ã¾ã—ãŸã€‚éžå¸¸ã«åœ°å‘³ãªè©±ã«ãªã‚Šã¾ã™ãŒã€æœ¬è¨˜äº‹ã§ã¯ãã®è¾ºã®å†…å¹•ã®è©±ã‚’ã—ãŸã„ã¨æ€ã„ã¾ã™ã€‚ IDç”Ÿæˆã«ã¾ã¤ã‚ã‚‹è‹¦æ‚© å¼Šç¤¾ã‚´ã‚¯ãƒã®æä¾›ã—ã¦ã„ã‚‹SmartNewsã¯è¡¨å‘ãã¯ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚¢ãƒ—ãƒªã§ã™ãŒã€è£å´ã®ä»•çµ„ã¿ã¯æ¤œç´¢ã‚¨ãƒ³ã‚¸ãƒ³ã«è¿‘ä¼¼ã—ã¦ã„ã¾ã™ã€‚ãƒ¦ãƒ¼ã‚¶ãƒ¼ã®æ–¹ã€…ã®èˆˆå‘³é–¢å¿ƒã‚„ã€ã‚¢ã‚¯ã‚»ã‚¹å‚¾å‘ã‚’ã‚¯ã‚¨ãƒªãƒ¼ã¨ã—ã€ãã®å†…å®¹ã«å¿œã˜ãŸè©±é¡Œã®ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’æ¤œç´¢çµæžœã¨ã—ã¦è¿”å´ã™ã‚‹ã€ã¨ã„ã†é¢¨ã«æ‰ãˆã¦ã„ãŸã ãã¨ã€ãªã‚“ã¨ãªãç§ãŒè¨€ã‚ã‚“ã¨ã—ã¦ã„ã‚‹äº‹ã‚’æƒ³åƒã—ã¦ã„ãŸã ã‘ã‚‹ã‹ã¨æ€ã„ã¾ã™ã€‚ SmartNewsã¯Twitterã®ã¤ã¶ã‚„ãæƒ…å ±ã‚’ç”¨ã„ãŸãƒˆãƒ¬ãƒ³ãƒ‰åˆ†æžã‚’ãƒ™ãƒ¼ã‚¹ã¨ã—ã¦ãŠã‚Šã€è©±é¡Œã«ãªã£ã¦ã„ã‚‹ãƒ‹ãƒ¥ãƒ¼ã‚¹ã‚’é¸å®šã™ã‚‹ãŸã‚ã«ã¯ã€å¤§é‡ã®Twitterä¸Šã®tweetã€ãªã‚‰ã³ã«ãã®ä¸ã«å«ã¾ã‚Œã¦ã„ã‚‹URLã«å¯¾ã—ã¦ã‚¯ãƒãƒ¼ãƒ«ã‚’è¡Œã†å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚æ—¥ã€…é…
uokada 2019/02/05
id

engineering

snowflake
ãƒªãƒ³ã‚¯
ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªæŽ¡ç•ªã¨snowflake â€” Kyrt Blog
snowflake ã¯ã€Twitter ç¤¾ãŒä½œæˆã—ãŸã€ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDç”Ÿæˆã®ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ã„ãã¤ã‹ã®ç°¡å˜ãªä¿è¨¼ã§é«˜ã„ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã‚’å®Ÿç¾ã—ã¦ã„ã¾ã™ã€‚Twitter ç¤¾ãŒã€MySQLã‹ã‚‰ Cassandra ã«ç§»è¡Œã™ã‚‹ã«ã‚ãŸã£ã¦ã€Cassandra ã«ã‚·ãƒ¼ã‚±ãƒ³ã‚·ãƒ£ãƒ«ãª id ç”Ÿæˆã®ä»•çµ„ã¿ãŒç„¡ã‹ã£ãŸã“ã¨ã‹ã‚‰ä½œæˆã—ãŸãã†ã§ã™ã€‚ snowflake ã«ã¤ã„ã¦ã¯Twitter IDs, JSON and Snowflakeã«æ›¸ã„ã¦ã‚ã‚Šã¾ã™ã€‚ snowflake ã®ã‚³ãƒ¼ãƒ‰ã¯ã€Apache License, Version 2.0 ã§Snowflakeã«å…¬é–‹ã•ã‚Œã¦ã„ã¾ã™ã€‚ ã‚¹ã‚±ãƒ¼ãƒ©ãƒ–ãƒ«ãªæŽ¡ç•ªã€èƒŒæ™¯çš„ãªè©± Cloudã§ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã®ã‚ã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã‚’è¦‹æ®ãˆã¦ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã‚‹ã¨æŽ¡ç•ªã«é–¢ã™ã‚‹å•é¡ŒãŒå¿…ãšå‡ºã¦ãã¾ã™ã€‚å¾“æ¥ã€RDBã®è‡ªå‹•æŽ¡ç•ªãªã©ã«é ¼ã£ã¦ã„ãŸã®ãŒã‚³ã‚¹ãƒˆã€ã‚¹ã‚±ãƒ¼ãƒ©ãƒ“ãƒªãƒ†ã‚£ã€è€éšœå®³æ€§ã®è¦³ç‚¹ã‹
uokada 2016/11/03
snowflake

id

twitter
ãƒªãƒ³ã‚¯
ãƒ„ã‚¤ãƒ¼ãƒˆIDç”Ÿæˆã¨ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã®è©±
ã€Unite Tokyo 2019ã€‘Unityã ã£ãŸã‚‰ç°¡å˜ï¼ãƒžãƒ«ãƒãƒ—ãƒ¬ã‚¤ç”¨ã‚²ãƒ¼ãƒ ã‚µãƒ¼ãƒé–‹ç™º ï½žå®Ÿè·µç·¨ï½ž
uokada 2012/12/26
idã‚’8ãƒã‚¤ãƒˆã§ç”Ÿæˆã—ã¦æ ¼ç´ã—ã¦ã‚‹ã®ã¯1ãƒã‚¤ãƒˆã§ã‚‚å°ã•ãã—ãªã„ã¨twitterã‚¯ãƒ©ã‚¹ã®ã‚µãƒ¼ãƒ“ã‚¹ã ã¨ã‚¹ãƒˆãƒ¬ãƒ¼ã‚¸ã®è‚¥å¤§åŒ–ãŒãƒãƒ³ãƒ‘ãªã„ã‹ã‚‰ã ã‚ã†ãªã€‚

snowflake

programming

technology
ãƒªãƒ³ã‚¯
Snowflakeçš„ãªIDç”Ÿæˆæ–¹æ³•
ä½œã£ã¦ã„ã‚‹ãƒ—ãƒã‚°ãƒ©ãƒ ã§ãƒ©ãƒ³ãƒ€ãƒ ãªIDãŒå¿…è¦ã¨ãªã£ãŸãŸã‚ã€ã¡ã‚‡ã£ã¨ãƒªã‚µãƒ¼ãƒã—ã¾ã—ãŸã€‚ä¹…ã—ã¶ã‚Šã«Javaã§ã‚³ãƒ¼ãƒ‰ã‚’æ›¸ã„ã¦ã„ã¾ã™ã€‚ UUID å®Œå…¨ã«åˆ†æ•£ã—ãŸç’°å¢ƒã§ä½¿ç”¨ã™ã‚‹ã®ã«ã¯ã€UUID(Universally Unique Identifier)ãŒæœ€é©ã§ã™ã€‚1IDã‚ãŸã‚Š16ãƒã‚¤ãƒˆã®å®¹é‡ãŒå¿…è¦ã¨ãªã‚‹ç‚¹ã‚’ã®ãžã‘ã°ã€ç†æƒ³çš„ãªIDã¨è¨€ãˆã‚‹ã¨æ€ã„ã¾ã™ã€‚ãŸã IDã¯å¤§é‡ã«ä½¿ç”¨ã•ã‚Œã‚‹ã®ã§ã€16ãƒã‚¤ãƒˆã¨ã„ã†ã‚µã‚¤ã‚ºã¯ã¡ã‚‡ã£ã¨æ°—ã«ãªã‚Šã¾ã™ã€‚ Snowflake Snowflakeã¯TwitterãŒä½¿ç”¨ã—ã¦ãŠã‚Šã€Apache Licenseã§å…¬é–‹ã—ã¦ã„ã‚‹IDç”Ÿæˆæ–¹æ³•ã§ã™ã€‚ã‚ã‚‹ç¨‹åº¦åˆ†æ•£ã—ãŸç’°å¢ƒã§ã‚‚ã€1IDã‚ãŸã‚Š8ãƒã‚¤ãƒˆã®å®¹é‡ã§åˆ©ç”¨ã§ãã¾ã™ã€‚ã¾ãŸéžå¸¸ã«é‡è¦ãªç‰¹å¾´ã¨ã—ã¦IDã®å…ˆé éƒ¨åˆ†ã«ã‚¿ã‚¤ãƒ ã‚¹ã‚¿ãƒ³ãƒ—åˆ©ç”¨ã—ã¦ãŠã‚Šã€ç”Ÿæˆã•ã‚ŒãŸIDã¯ã‚ã‚‹ç¨‹åº¦æ™‚ç³»åˆ—ã«ä¸¦ã³ã¾ã™ã€‚8ãƒã‚¤ãƒˆã€ã¤ã¾ã‚Š64bitã‚’ä¸‹è¨˜ã®ã‚ˆã†ã«æŒ¯ã‚Šåˆ†ã‘ã¦ä½¿ç”¨ã—ã¾ã™ã€‚ å…ˆé 4
uokada 2012/07/17
snowflake

twitter

id
ãƒªãƒ³ã‚¯
Twitterã®status IDã®ä»•çµ„ã¿ãŒå¤‰ã‚ã‚‹
ã“ã‚Œä¸€éƒ¨ã®äººã«ã¨ã£ã¦ã¯å¤§ããªå¤‰åŒ–ã‹ã‚‚ã—ã‚Œãªã„ã‚“ã ã‘ã© ã‚ã¾ã‚Šè©±é¡Œã«ãªã£ã¦ã‚‹ã®ã‚’èžã‹ãªã„ã— æ¤œç´¢ã—ã¦ã‚‚æ—¥æœ¬èªžã®æƒ…å ±ãŒè¦‹ã‚ãŸã‚‰ãªã‹ã£ãŸã®ã§æ›¸ã„ã¦ãŠãã¾ã™ã€‚ 2010å¹´ã®9æœˆ21æ—¥ã‹ã‚‰ Twitter ã® status ID ã®ä»•çµ„ã¿ãŒå¤‰ã‚ã‚‹æ¨¡æ§˜ã€‚ Status IDs are changing on 21st September â€“ Twitter Development Talk | Google Groups ã“ã‚Œã¯ Twitter ã®ãƒ‡ãƒ¼ã‚¿ã‚’æ‰±ã†ã‚·ã‚¹ãƒ†ãƒ ã‚’ MySQL ã‹ã‚‰ Cassandra ã¸ç§»è¡Œã™ã‚‹ã“ã¨ã«ã‚ˆã‚‹ã‚‚ã®ã¿ãŸã„ã€‚ Cassandra ã«ã¯ãƒ¦ãƒ‹ãƒ¼ã‚¯ãª ID ã‚’ç”Ÿæˆã™ã‚‹ä»•çµ„ã¿ãŒãªã„ã®ã§ã€ status ID ã®ã‚ˆã†ã«ã‚½ãƒ¼ãƒˆå¯èƒ½ãª ID ã‚’åˆ©ç”¨ã™ã‚‹ãŸã‚ æ–°ãŸã« Snowflake ã‚’å°Žå…¥ã™ã‚‹ã¨ã®ã“ã¨ã€‚ ä¸Šè¨˜ãƒªãƒ³ã‚¯å…ˆã«ç´°ã‹ã„ã“ã¨ãŒæ›¸ã‹ã‚Œã¦ã‚‹ã‚“ã ã‘ã©ã€ ã“ã‚Œã«é–¢é€£ã™ã‚‹é‡è¦ãªãƒã‚¤ãƒ³ãƒˆã‚’
uokada 2011/05/25
twitter

snowflake
ãƒªãƒ³ã‚¯
1