Product @ClickhouseDB, fmr @getArctype (acq. ClickHouse), crossed the world by motorcycle in a past life. All opinions are my own. 🇺🇸 🇰🇬 🇨🇳

Washington DC
Joined May 2021
Zach Naimon retweeted
Executable UDFs are GA on ClickHouse Cloud (AWS, GCP, Azure). New since beta: compiled Rust/Go/C++/JS binaries, network access, memory limits, a deterministic flag for the query cache, Cloud API + Terraform, and per-query UDF metrics in 26.6+. We used them to count and price LLM tokens inside ClickHouse: buff.ly/9AtdZyd
2
6
16
1,646
Zach Naimon retweeted
You created a temporary table. A second later, it "doesn't exist." 👻 Your query landed on another replica. Replica-aware routing helps related queries reach the same replica. Now in public beta for Enterprise. clickhouse.com/blog/replica-…
3
11
1,137
Zach Naimon retweeted
AI made writing code faster, but the bottleneck is knowing whether it's safe to ship. clickhouse.com/blog/clicksta… Which is why we're partnering with @hud_hq: ClickStack shows where an issue is; Hud adds automatic, low-overhead function-level insight into why. Together, they give coding agents the runtime context to ship with confidence.
1
6
1
24
2,561
👊I've joined the crew at @ClickHouseDB to establish the *ClickHouse Labs* research group. We'll be working side-by-side with ClickHouse devs to cook up new ways to make the system even faster. I'll also be exploring new topics related to PostgreSQL. clickhouse.com/blog/andy-pav…
61
107
39
1,222
138,572
Zach Naimon retweeted
Welcome to ClickHouse, @andy_pavlo 👋 We're launching ClickHouse Labs, a new research group advancing foundational database technology, led by Andy as VP of Database Research. Andy is an award-winning database researcher, professor at Carnegie Mellon University’s Computer Science Department and longtime leader of the CMU Database Research Group. At ClickHouse Labs, he'll build a team to take on the hardest problems in database systems, testing their work on real workloads and publishing it in the open, across both ClickHouse and PostgreSQL. Read Andy’s blog: clickhouse.com/blog/andy-pav…
109
69
17
641
9,715,219
Zach Naimon retweeted
One of the most-requested ClickHouse Cloud features just hit public beta: executable UDFs. Write a Python function, zip it, deploy it to your cluster, call it like a built-in. A single DDL statement binds your Python to the data layer. clickhou.se/433E5xZ
5
9
2,254
Zach Naimon retweeted
Next month marks 10 years of @ClickHouseDB as an open source project and we are thrilled to welcome our community at our annual user conference today in San Francisco. To everyone who contributed code, filed an issue, or ran ClickHouse in production from the beginning: thank you. Today, we’re proud to share that ClickHouse has over 4,000 customers, passed $250M in ARR, and is trusted by teams like @AnthropicAI, @OpenAI, @cursor_ai, @Lovable, @vercel and many more building the future of AI. In this post, I cover the milestone, what we’re shipping, and what comes next: clickhouse.com/blog/thank-yo…
9
28
10
126
1,306,777
Zach Naimon retweeted
Both OpenAI and Anthropic are now using ClickHouse for observability. Clickhouse has the potential to become as big as Databricks, which is currenty valued at $134 billion. $NBIS owns 25% of Clickhouse. How can you be bearish on $NBIS?
OpenAI is transitioning away from Datadog and into ClickHouse services, where $NBIS holds a 25% stake
18
28
3
362
69,582
Zach Naimon retweeted
$NBIS JPMorgan’s observability expert flagged OpenAI moving logs to ClickHouse (28% owned by $NBIS) as a notable defection from Datadog at hyperscale. OpenAI defects from Datadog to ClickHouse because log ingestion + retention at scale is too expensive on third-party platforms. Nebius rips the Bullish for $NBIS
JPM software channel checks ( $NOW, OpenAI/Clickhouse ( $NBIS), Anthropic, $DT, etc. read thru):
8
24
7
327
78,320
OpenAI is transitioning away from Datadog and into ClickHouse services, where $NBIS holds a 25% stake
JPM software channel checks ( $NOW, OpenAI/Clickhouse ( $NBIS), Anthropic, $DT, etc. read thru):
23
52
35
866
708,657
Zach Naimon retweeted
"The AI bear case for @Snowflake revolves around differences in human vs. agent preferences for accessing data and the continued march of infrastructure that prices to one paradigm becoming obsolete as the world advances. In particular, while Snowflake's query engine works very well at human speeds (loading a dashboard, running a complex SQL query) upstarts like @ClickHouseDB ... argue that agents have very different preferences and prefer lightning fast queries that would be very expensive on Snowflake." 👏
Every day for the next long while, I'm going to tear down a new public software company and highlight the AI risks/opportunities around it- products launched to date, top startups, key quotes from earnings calls, etc. Day eighteen: Snowflake $SNOW Peak share price: $392.15 (Nov 19, 2021) Share price today: $121.11 (-69%) EV today: $39.8bn ARR today: $5.1bn (+30% Y/y) NRR: 125% EV/ARR: 7.8x GAAP Operating Margin: -25% (!!) EV/Run-rate GAAP EBIT: N/A Headcount: 9060 (+16% Y/y) What Snowflake does: Snowflake is the leading cloud data warehouse focused on helping companies store, manage and query tabular business data using SQL. A significant share of the world's largest enterprises have opted to pool their critical data onto/around Snowflake to create a data warehouse of record to power everything from observability to analytics to data applications. The key innovation powering Snowflake's rise was the separation of compute and storage as concepts, allowing users to apply elastic compute against fixed storage, reducing analytical queries that used to take hours to seconds. Like others in the space, Snowflake has expanded into other adjacent areas like python, ETL, BI, etc. AI bear case: The AI bear case for Snowflake revolves around differences in human vs. agent preferences for accessing data and the continued march of infrastructure that prices to one paradigm becoming obsolete as the world advances. In particular, while Snowflake's query engine works very well at human speeds (loading a dashboard, running a complex SQL query) upstarts like @ClickHouseDB and @motherduck argue that agents have very different preferences and prefer lightning fast queries that would be very expensive on Snowflake. In short, the bear case on Snowflake is that analytical queries will be run by agents in the future, and Snowflake's platform has an architectural innovator's dilemma in serving those use cases. AI bull case: The reality is, thousands of the world's largest companies have invested huge effort in standardizing/centralizing on Snowflake. The battle to be the system of record for aggregated tabular business data is already over at these companies- it will be Snowflake for the foreseeable future. The implication is that agents are actually a huge tailwind for Snowflake- they will need to access business data to operate, to derive insights, to understand context, etc. and Snowflake's business model has the clear advantage of letting it monetize those queries as if they were coming from a human. AI traction: It is hard for Snowflake to know exactly what share of its revenue comes from AI-driven queries, but it did say this on the Q4 call: "This quarter, we delivered the largest sequential increase in accounts using AI, bringing the total to more than 9,100 accounts." Beyond that, net retention ticked up last year to 125%, very impressive at this scale. Adjacent AI-native startup summary: Databricks, albeit not AI-native, is the juggernaut to watch here, with a reported 15,000 employees up 34% Y/y. Clickhouse - 536 employees, +86% y/y Motherduck - 133 employees, +46% Y/y Management Quotes: "And in just 3 months, Snowflake Intelligence has scaled from a nascent offering to an essential capability for over 2,500 accounts, almost doubling quarter-over-quarter." "Our deepened partnership with Anthropic is already helping customers like Intercom see significant impact." "And Matt, just to emphasize that point, just in fourth quarter, we saw a lot of benefit with AI that we had a small reduction in force and about 200 people in the company were impacted. So if you look at our fourth quarter net adds on a headcount basis, we only added 37 people. So AI has really changed the framework for investing in growth. It's no longer tied to headcount." "So we will be launching features like a per user cap on top of Snowflake Intelligence, so they can feel like there is a clear upper limit to how much they can get charged with an agent. We think models like this that are consumption-based with clear user caps and account caps offer the best of both worlds, which is consumption pricing with price predictability." "Yes. Super quickly, like partners, customers and our internal field are all incredibly excited about the results we're seeing with Cortex Code. The original value prop of Snowflake, which is change what's possible in terms of ease of use, it's just gone like 10x with Cortex Code. We showcased a number of instances where people are building pipelines faster, transformation faster, insights faster. And I think we're only at the beginning of what is possible." Commentary: Though the balance of evidence (and certainly my customer work) suggests that Snowflake should be a beneficiary of AI, it is certainly striking that the business impact seems to have been muted thus far. All of the ingredients are there- consumption-based pricing, AI lowering the barriers for humans to ask questions of data (aka AI-generated SQL), and data as a key foundational layer to agents. My suspicion is that some of this disappointment to-date may come from Snowflake's lack of alignment to the use-case where AI is working the best today (i.e. code). Analytical queries may simply be slower/harder to get right- but it certainly seems likely that in a future where agents accelerate the amount of knowledge work done in the enterprise, Snowflake's core business should see a meaningful tailwind. Once that question is answered, the burning question will be whether agent adoption presages an architectural shift towards data warehouses with a more AI-native architecture. My gut is that this will happen at some scale but won't create a wholesale shift and lead to a data warehouse replacement cycle. It will certainly be interesting to watch, though!
9
7
7
78
115,675
He said: no thanks, I can do it myself and can do it better 😂xitter.cf/Yoda4ever/status/20087…
120
1,296
17
43,303
2,044,137
Zach Naimon retweeted
Why does the DOJ continue to take down Epstein files? Who is directing this? Who are they protecting?
95
1,416
23
4,933
111,280
arrayFold() is my new favorite ClickHouse function
At ClickHouse, "impossible" is just another data problem waiting to be solved. To prove it, we decided to complete all 12 days of the 2025 Advent of Code challenge unconventionally. No Python, no JavaScript, no "real" programming languages. Just pure ClickHouse SQL 🚀 Curious how we did it? Read the blog here 👉 clickhou.se/3Nq8GAY
101
Zach Naimon retweeted
.@massive_com streams huge volumes of live market data. ClickHouse handles it with ease and low latency. StockHouse shows the full flow: streaming, storing, and visualizing real-time data with Perspective. 🔗 clickhou.se/4hOtRYH
2
7
1
22
2,512
Zach Naimon retweeted
The open-source Agentic Data Stack is here 🔥 👉 clickhou.se/3JLVPI1 Today, we’re excited to share that we’ve joined forces with @LibreChatAI. Together, ClickHouse and LibreChat form the foundation of the open-source Agentic Data Stack, empowering teams to deploy AI agents that analyze and act on large datasets through natural language. And it’s already powering real-world applications: ⬩@Shopify uses LibreChat internally with 1000+ custom agents and 30+ MCP servers ⬩@DaimlerTruck has deployed LibreChat company-wide for secure AI access ⬩@cBioPortal built a public genomics research agent for cancer data analysis on top of ClickHouse and LibreChat ⬩We deployed a LibreChat-backed agent that now handles approximately 70% of data warehouse queries for over 200 users, processing 33 million LLM tokens daily What doesn't change: ✓ LibreChat remains 100% open source (MIT license) ✓ Community-first development continues ✓ Your existing LibreChat deployments work exactly as before What gets better: ✓ Enterprise-ready features for production agentic analytics workloads ✓ Native LibreChat experience alongside ClickHouse Cloud instances ✓ Extended data visualization support, enterprise-grade security and governance, and a tailored semantic layer The future of data analysis isn't dashboards, it's agents that understand your questions and deliver answers instantly from billions of records. Welcome to the LibreChat team and community! 🎉 Try it yourself 👉 llm.clickhouse.com (And by the way, we are hiring. If interested, just ping @ryadhdotnet)
2
12
4
52
14,073
> faster than Lewis Hamilton head-to-head > now an investor in the fastest database on the planet very fitting @NicoRosberg
Replying to @ClickHouseDB
Thrilled to back ClickHouse as our first direct investment at Rosberg Ventures 🚀 Super excited to join an incredible group of investors on this next chapter of your journey!
2
108
Replying to @namedobject
we stan alexey
3
1
11
2,331
👏 Big moment at the AWS Summit NYC! @ZachNaimon took the keynote stage to share how ClickHouse is approaching agent-facing analytics with our remote MCP connector and Ask AI experience. 🤖 We’re also excited to announce that ClickHouse Cloud is now available in the new “AI Agents and Tools” category in the AWS Marketplace. Join the waitlist 👉 clickhouse.ai
1
3
17
5,336