ClickHouse logo
  • English
  • Japanese
  • Products
    • ClickHouse CloudClickHouse Cloud
      The best way to use ClickHouse.
      Available on AWS, GCP, and Azure.
    • ClickHouse BYOCBring Your Own Cloud
      A fully managed ClickHouse Cloud service,
      deployed in your own AWS account.
    • ClickHouseClickHouse
      Spin up a database with open-
      source ClickHouse.
    • chDBView 100+ integrations
    View 100+ integrations ->->
  • Use cases
    • Real-time analytics
    • Machine learning and GenAI
    • Data warehousing
    • Observability
    • All use cases
    All use cases ->->
  • Docs
  • Resources
    • User stories
    • Blog
    • Events
    • News
    • Learning and certification
    • Comparisons
      • BigQuery
      • PostgreSQL
      • Redshift
      • Snowflake
    • Videos
    • Demos
  • Pricing
  • Contact us
  • English
  • Japanese
42.3kSign in

Videos / ClickHouse

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.

Recent videos

YouTube Video: UAgYxbqz6XIYouTube Video: UAgYxbqz6XI
ClickHouse Cloud, ClickHouse

Milliseconds Matter: Best Practices for Real-Time Analytics

Learn best practices for architecting scalable, low-latency analytics with ClickHouse.

YouTube Video: y9biAm_FkqwYouTube Video: y9biAm_Fkqw
ClickHouse

The ClickHouse MCP Server

Mark Needham

YouTube Video: mJCo_wszNicYouTube Video: mJCo_wszNic
ClickHouse

The ClickHouse monitoring dashboard

Mark Needham, Product Marketing Engineer

Follow us
X imageBluesky imageSlack image
GitHub imageTelegram imageMeetup image
Rss image

Products

  • ClickHouse Cloud
  • ClickHouse
  • Bring Your Own Cloud
  • ClickHouse Government
  • ClickHouse Keeper
  • ClickStack
  • ClickPipes
  • Integrations
  • chDB
  • Trust center
  • Pricing

Resources

  • Documentation
  • Training
  • Support
  • Benchmarks
  • Use cases
  • Videos
  • Demos
  • Real-time data warehouse
  • Open House videos

Company

  • Blog
  • Our story
  • Careers
  • Contact us
  • Events
  • News
  • Media

Join our community

  • GitHub
  • Slack
  • LinkedIn
  • X
  • Bluesky
  • Telegram
  • Meetup

Comparisons

  • BigQuery
  • PostgreSQL
  • Redshift
  • Snowflake
  • Partners

  • AWS
  • Azure
ClickHouse logo
Stay informed on feature releases, product roadmap, support, and cloud offerings!
Loading form...
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.
TrademarkPrivacySecurityLegalCookie policy