Skip to content

Funnel Analytics and Distributed Queries in ClickHouse

Degena Woldemariam

Klaviyo This presentation was given at the ClickHouse Community Meetup in Boston on 11 December, 2023. - https://www.meetup.com/clickhouse-boston-user-group/events/296488840/

ClickHouse Cloud, powered by AWS

ClickHouse Cloud on AWS uses Amazon Simple Storage Service (Amazon S3), object storage for scalability, data availability, security, and performance. Amazon Elastic Compute Cloud (Amazon EC2) is used for high performance and efficiency for data-intensive workloads. AWS PrivateLink is used for secure connection between ClickHouse Cloud and the customer's VPC. ClickHouse Cloud also integrates with a wide range of other AWS services, including Amazon Managed Streaming for Apache Kafka, Amazon Quicksight, Amazon Relational Database Service, Amazon Glue and Amazon Kinesis.

aws qualified software

Recent videos

YouTube Video: GpRgNjD2Swk

Open House, User stories

Precomputing fraud signals with ClickHouse materialized views at Moniepoint

Johnson Adekunle and Abraham Imohiosen, Engineering Managers at Moniepoint, explain how precomputed customer state with ClickHouse materialized views turns fraud checks into lookups, reducing p90 aggregate lookup latency by 93.1%.

YouTube Video: kcSlDrWd-HU

Open House, User stories

How Twilio handles a petabyte of logs a day with ClickHouse Cloud

Avleen Vig, Site Reliability Architect at Twilio, explains how ClickHouse Cloud supports 30 million log lines per second at peak, a petabyte of raw logs per day, and 50% annual data growth.

YouTube Video: hWOe1H2nW3g

Open House, User stories

Observability for the age of agents: How Vercel uses ClickHouse

Dom Busser and Vincent Voyer explain how Vercel uses ClickHouse Cloud to ingest 100 billion log events a day, serve customer-facing observability, and support agents querying data with SQL.

Follow us

XBlueskySlackGithubTelegramMeetupRSS