SQL Dynamic Column Selection in ClickHouse

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.