v.21.10New Features

Add Conversion Functions for Snowflake ID and DateTime Types

Add conversion functions between "snowflake id" and DateTime, DateTime64. See #27058. #27704 (jasine).
Added conversion functions to transform "snowflake id" values into DateTime and DateTime64 formats in ClickHouse.

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 into DateTime or DateTime64 types. For example, apply the function around your Snowflake ID value within a SELECT statement to extract the timestamp component.