Skip to content

Continuously loading S3 data into ClickHouse

Mark Needham

Principal Product Marketing Manager, ClickHouse In this video, we'll learn how to continuously load data into ClickHouse from AWS S3, using the S3Queue table engine. We start by exploring the config required on the serve to enable this functionality, before examining the S3 bucket that we're going to load into ClickHouse. We walk through the two modes of ingestion that we can use and adjust the flush frequency so that data is available in ClickHouse quicker. Finally, we use shadowtraffic.io to generate some more data and stream it into our S3 bucket, before checking that it's made its way into ClickHouse.

Recent videos

YouTube Video: IyI0YQBCy8U

How to

CDC ClickPipes: The Fastest Way to Replicate Your Database to ClickHouse

Marta Paes, Senior Product Manager at ClickHouse

YouTube Video: Mgsm11T7tO8

How to

Under-the-Hood: ClickHouse Incremental Materialized Views and Dictionaries

Maruthi Lokanathan, Solution Architect at ClickHouse Derek Chia, Principal TAM Architect at ClickHouse

YouTube Video: -piPcapMtc0

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.

Follow us

XBlueskySlackGithubTelegramMeetupRSS