v.21.10New Features
Add Conversion Functions for Snowflake ID and DateTime Types
Add conversion functions between "snowflake id" andDateTime,DateTime64. See #27058. #27704 (jasine).
Why it matters
This feature enables users to directly convert Snowflake-generated unique identifiers into standard ClickHouse date and timestamp types, simplifying the process of interpreting Snowflake IDs for time-based queries and analyses.How to use it
Use the newly introduced conversion functions in SQL queries to convert Snowflake IDs intoDateTime or DateTime64 types. For example, apply the function around your Snowflake ID value within a SELECT statement to extract the timestamp component.