Deriving columns from other columns
Mark Needham Product Marketing Engineer, ClickHouse
In this video, we're going to learn how to use the DEFAULT, MATERIALIZED, and ALIAS modifiers to derive the value of one column from another one.


ClickHouse, ClickHouse Cloud
Cyber in Real Time: How Seemplicity & Reco Supercharged Their Security Analytics
Watch a live webinar with Seemplicity & Reco on building the future of cybersecurity with ClickHouse.


ClickHouse Cloud, ClickHouse
Milliseconds Matter: Best Practices for Real-Time Analytics
Learn best practices for architecting scalable, low-latency analytics with ClickHouse.


ClickHouse
The ClickHouse MCP Server
Mark Needham
Products
Resources
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.