TTL Expressions for Columns and Tables

Why it matters

This feature provides a way to define automatic data lifecycle management by specifying TTL expressions directly on columns or tables. It helps users efficiently manage storage by automatically deleting or moving data based on age or other criteria, reducing manual maintenance and improving data freshness.

How to use it

Users can define TTL expressions in the CREATE TABLE or ALTER TABLE statements by adding the TTL clause on specific columns or for entire tables. The defined rules will execute automatically to expire data according to the specified conditions.