Transforming log data with ClickHouse materialized views

Mark Needham Principal Product Marketing Manager, ClickHouse

In this video, we'll learn how to transform log entries using ClickHouse materialized views. We start with a bunch of log files in S3 and then show how to pull out the individual components using a regular expression and store them in a MergeTree table. We conclude by seeing that our solution can also handle any new files added to the S3 bucket.