Mark Needham Principal Product Marketing Manager, ClickHouse
In this video, we'll learn about dynamic column selection in SQL with ClickHouse, using the New York taxi dataset. We’ll learn how to use the COLUMNS clause to return columns by regex, before showing how to apply functions to aggregate data and format results. We'll also learn how to modify the values of columns, as well as excluding fields that we don't want.


ClickHouse Cloud, How to
LogHouse, Observability for ClickHouse Cloud
Get an insider’s look at LogHouse, the ClickHouse-powered logging platform that drives observability for ClickHouse Cloud.


ClickHouse, How to
Powering Feature Stores with ClickHouse
Mark Needham Principal Product Marketing Engineer, ClickHouse


How to
Querying archive files with ClickHouse
Mark Needham Principal Product Marketing Manager, ClickHouse
Products
© 2025 ClickHouse, Inc. HQ in the Bay Area, CA and Amsterdam, NL.