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

uokada id:uokada

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

${{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ã®ãƒãƒ¼ãƒ«éšŽå±¤è¨è¨ˆã¡ã‚ƒã‚“ã¨ã—ã¦ã¾ã™ã‹ï¼Ÿ | 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ç”Ÿæˆã¨ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ãƒªã‚¢ãƒ«ã‚¿ã‚¤ãƒ æ¤œç´¢ã‚·ã‚¹ãƒ†ãƒ ã®è©±
8. ãƒ„ã‚¤ãƒ¼ãƒˆIDç”Ÿæˆã‚·ã‚¹ãƒ†ãƒ Snowflakeã¨ã¯ lï¬ ãƒ¦ãƒ‹ãƒ¼ã‚¯ãªIDã‚’ç”Ÿæˆã™ã‚‹ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã‚µãƒ¼ãƒ“ã‚¹ lï¬ ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã®ãƒ„ã‚¤ãƒ¼ãƒˆID(ã‚¹ãƒ†ãƒ¼ã‚¿ã‚¹ID)ã®å‰²ã‚Šå½“ã¦ã«ä½¿ã‚ã‚Œã¦ã„ã‚‹ lï¬ ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ç¤¾ãŒOSSã§å…¬é–‹ä¸ (*) lï¬ ç‰¹å¾´ lï¬ 64 bitã®IDã‚’ç”Ÿæˆ lï¬ ã–ã£ãã‚Šæ™‚åˆ»é † lï¬ é€Ÿã„ lï¬ 10000 ID/ç§’ ã®ã‚¹ãƒ”ãƒ¼ãƒ‰ã§IDã‚’ç”Ÿæˆã§ãã‚‹(1ãƒ—ãƒã‚»ã‚¹ã‚ãŸã‚Š) lï¬ ãƒ¬ã‚¹ãƒãƒ³ã‚¹ 2 ms (+ãƒãƒƒãƒˆãƒ¯ãƒ¼ã‚¯ã®ãƒ¬ã‚¤ãƒ†ãƒ³ã‚·) lï¬ ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹ lï¬ è¤‡æ•°ã®ãƒžã‚·ãƒ³ãƒ»ãƒ—ãƒã‚»ã‚¹ã§å”èª¿å‹•ä½œã—ãªã„ lï¬ ä¸¦ã¹ãŸã ã‘ã‚¹ã‚±ãƒ¼ãƒ«ã™ã‚‹(ã¯ãš) (*) https://github.com/twitter/snowï¬‚ake 8 9. SnowflakeãŒé–‹ç™ºã•ã‚Œã‚‹ã¾ã§ lï¬ ãƒ„ã‚¤ãƒ¼ãƒˆã®æµé€Ÿå¢—åŠ ã¨ãƒ„ã‚¤ãƒƒã‚¿ãƒ¼ã®ã‚·ã‚¹ãƒ†ãƒ ç§»è¡Œ lï¬ 5å„„ãƒ„ã‚¤ãƒ¼ãƒˆ/æ—¥(ç´„6000ãƒ„ã‚¤ãƒ¼ãƒˆ/ç§’) (*1) lï¬ 2012å¹´1
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