ClickHouse Open House + Training

RSVPing here on meetup is not registering!

Open House 2025 is the first ever ClickHouse User Conference! It is a premier one-day event for ClickHouse users, contributors, enthusiasts, and customers, hosted in the heart of San Francisco on 29 May. For those unable to join in person, the event will be streamed to multiple locations worldwide, ensuring everyone can be part of this global gathering.

Main website for registration.

We will also be hosting in person training in San Francisco on May 28th.
Workshops will be held at the Hyatt Regency Embarcadero. Join us for one of two training options: a full day course open to all levels, and a half day advanced course. Whether you're just starting with ClickHouse or refining an advanced deployment, these workshops will empower you with the tools and techniques to unlock the full potential of your data. You do not have to be registered to attend open house to attend the trainings, though you are welcome to both!

Some further info about our trainings
Option 1: ClickHouse Developer Training

Time: 9:00 AM – 5:00 PM PST (Full Day)
Who Should Attend: New or intermediate users looking to build a strong foundation in ClickHouse.
What You’ll Learn: The fastest way to ramp on ClickHouse. Topics range from introductory content to a deep dive on interacting with and understanding your data.

• Getting Started with ClickHouse
• ClickHouse Architecture
• Modeling and Analyzing Data
• Materialized Views
• Projections and Skipping Indexes
• Updating and Deleting Data

Option 2: ClickHouse Query Optimization Workshop

Time: 1:00 PM – 5:00 PM PST (Half Day)
Who Should Attend: Experienced ClickHouse users ready to dive deep into performance tuning.
What You’ll Learn: Advanced techniques to improve query performance, aimed at users with large ClickHouse instances.

• Advanced use of primary keys, skipping indexes, materialized views, and projections
• Techniques to avoid inefficient joins and improper data types
• How to leverage query logs and CPU/memory profiling to pinpoint bottlenecks
• Hands‑on labs applying real‑world optimization scenarios

Please register here for just the trainings.

We look forward to seeing you at our events!