v.24.6New Feature

Added generateSnowflakeID SQL function for Twitter-style ID generation

Official CH changelog text
Added new SQL functions generateSnowflakeID for generating Twitter-style Snowflake IDs. #63577 (Danila Puzov).
Added new SQL function generateSnowflakeID for generating Twitter-style Snowflake IDs.

Why it matters

The feature provides a built-in method for generating unique, time-based distributed IDs within ClickHouse, enabling users to create scalable, collision-resistant identifiers without relying on external services.

How to use it

Use the generateSnowflakeID function directly in your SQL queries to generate Snowflake IDs. For example: 
SELECT generateSnowflakeID() AS id
FROM table_name

Related resources

PreviousNext