Vital signs
Why it's on the table
On the table, Warehouse & Notebooks (Wh) is seat 45 of 58, in the Data & Analytics family. It is an emerging element — the job is real and here to stay, but the leaderboard still changes quarterly. Choose for this quarter, hold loosely, and watch the changelog. It is optional: plenty of companies run without it — until a specific trigger (scale, regulation, cost, or customers) makes it essential for them. It sits in the lowest paid band — lunch money against the hours it returns.
Warehouse & Notebooks: the top 5 — v2026.Q3
Edition v2026.Q3 · ranking, pricing and status verified 2026-08-06.
1HexHex Technologies
Community free · Professional $36/editor/mo · Team $75/editor/mo · Enterprise custom · compute add-ons $0.32–$4.06/hrBest for One workspace where founders and data folk ask questions in SQL, Python, or plain English — and the answers become shareable apps, not screenshots.
Repositioned from 'collaborative notebook' to 'The AI Analytics Platform' and shipped like it through 2026: Agent Tasks (Jun 16), MCP client connectivity (May 28), web search for agents (Jun 11), and agent Evals (Aug). $70M Series C (May 28, 2025; Avra, a16z, Sequoia, Snowflake) with 1,500+ teams including Notion, Figma, Brex, Ramp, Reddit, and Anthropic. The Hashboard acqui-hire folded a BI team directly into the agent push.
Watch $36–75/editor/mo stacks up fast for small teams, and the free Community tier is genuinely limited (5 published apps, 7-day history). No 2026 raise verified — the war chest is the May 2025 round while Snowflake, Databricks, and OpenAI all build competing analyst agents.
2DuckDB / MotherDuckDuckDB Labs (OSS) / MotherDuck (cloud)
DuckDB free (MIT) · MotherDuck Lite free (10GB, 10 compute-hrs/mo, 3 users) · Business $250/org/mo + usage · compute $0.60–$24/hr per-second billedBest for The default startup warehouse: laptop-fast analytics on the gigabytes-to-low-terabytes most companies actually have, with a serverless cloud when you need to share.
The small-data movement's flagship, and it won the argument: DuckDB crossed 40k GitHub stars (Aug 5, 2026) with a mature 1.5.x line plus an LTS channel, and DuckLake v1.0 (Apr 2026) gave it a credible lakehouse format simpler than Iceberg. MotherDuck's Lite tier is free forever at 10GB, and 2026 launches — Flights (agent-native Python pipelines, Jun) and Guides (a context layer for AI agents, Jul) — aim it squarely at agent-driven analytics.
Watch Single-node scale-up has a ceiling — at tens of TB or high-concurrency BI you're shopping again. MotherDuck's last verified raise is the $52.5M Series B (Sep 2023); no round since surfaced on vendor or press pages, so runway is a fair diligence question.
3BigQueryGoogle Cloud
Free: 1 TiB queries + 10 GiB storage/mo · on-demand $6.25/TiB scanned · slots from $0.04/slot-hr · startup credits $2k–$350kBest for GCP-native startups that want a zero-ops, petabyte-capable serverless warehouse that costs approximately nothing until real scale.
The best startup deal among the big-cloud warehouses: the first 1 TiB of queries and 10 GiB of storage each month are permanently free, on-demand is a transparent $6.25/TiB, and the Google for Startups Cloud Program covers $2k (pre-funded) to $200k–$350k (funded / AI-first) of whatever you do spend. Nothing to size, patch, or resume — a real advantage over credit-metered rivals for teams with no data engineer.
Watch On-demand billing punishes careless SELECT * on wide tables, and costs get opaque once you graduate to slot editions. Gemini-in-BigQuery assistance trails the dedicated notebook agents, and lock-in to GCP is the price of the convenience.
4ClickHouseClickHouse, Inc.
Open source free (Apache-2.0) · Cloud usage-based (scaled compute + storage, trial credits) · no public per-unit list pricesBest for When analytics is the product — user-facing dashboards, observability, or agent telemetry needing sub-second queries over billions of rows.
The breakout warehouse company of the cycle: $400M Series D at a $15B valuation (Jan 2026), annualized revenue tripled to $250M by May 2026 on an IPO path, and the Langfuse acquisition (announced with the Series D) planted it in LLM observability — a workload startups actually have in 2026. Open-source ClickHouse remains free and self-hostable when the cloud bill stings.
Watch Overkill below billions of rows — DuckDB covers that for free. Cloud pricing has no public per-unit rates (calculator-only), self-hosting is real ops work, and joins/mutations still trail general-purpose warehouses.
5Marimomarimo (CoreWeave since Oct 2025)
Free, Apache-2.0 · notebooks are pure .py files · molab cloud free tier (GPU-backed, expanding under CoreWeave)Best for Python-first builders who want notebooks that behave like software: reactive execution, git-diffable files, runnable as scripts, deployable as apps.
The open-source notebook with the momentum: 22.2k GitHub stars, users from OpenAI and Cloudflare to Stanford, and an AI-native editor with built-in SQL. Reactive cells kill the hidden-state bugs that make Jupyter notebooks unreproducible. CoreWeave's acquisition (Oct 30, 2025) funded the team from 2 to 8+ with a public pledge that the notebook stays free and permissively licensed, plus GPU compute behind the molab cloud.
Watch Ecosystem still a fraction of Jupyter's, and .py-file format means existing .ipynb workflows need conversion. Cloud roadmap (molab) now rides CoreWeave's strategy — fine today, worth watching as the parent's priorities shift.
Warehouse & Notebooks: the top 8 compared
Edition v2026.Q3 · ranking, pricing and status verified 2026-08-06.
| Tool | Role | Entry price | Free tier | Open source | AI / agents | Languages | Scale ceiling |
|---|---|---|---|---|---|---|---|
| Hex | Notebook + analytics layer | $36/editor/mo | Yes (Community) | No | Notebook · Threads · semantic agents + Evals | SQL + Python + no-code | Warehouse-bound (pushdown) |
| DuckDB / MotherDuck | Warehouse (local + serverless) | $0 → $250/org/mo | Yes (10GB, 3 users) | DuckDB: MIT | AI SQL · Guides context layer · Flights pipelines | SQL (+Python lib) | Single-node sweet spot ≲ low TB |
| BigQuery | Warehouse (serverless) | $6.25/TiB scanned | 1 TiB + 10 GiB/mo | No | Gemini in BigQuery | SQL (+notebooks) | Petabyte+ |
| ClickHouse | Real-time OLAP | Usage-based cloud | Trial credits; OSS free | Yes (Apache-2.0) | MCP/LLM integrations · Langfuse | SQL | Petabyte+, sub-second |
| Marimo | Notebook | $0 | Yes (+ molab cloud) | Yes (Apache-2.0) | AI-native editor, BYO model | Python + SQL | n/a (client to engines) |
| Snowflake | Warehouse (enterprise) | ~$2+/credit + $23/TB/mo | 30-day trial | No | Cortex AI · analyst agents | SQL + Snowpark Python | Petabyte+ |
| Deepnote | Notebook + data workspace | Free tier | Yes | Yes (Apache-2.0, 2026) | Agents · Claude Code integration | SQL + Python | Warehouse-bound |
| Jupyter | Notebook substrate | $0 | Yes | Yes (BSD) | Via extensions (jupyter-ai) | Python + kernels | n/a (client to engines) |
How to choose your warehouse & notebooks
- If your working data fits in memory or on one SSD — which is 90% of startups, per the small-data thesis
- DuckDB locally, MotherDuck Lite (free, 10GB) when you need sharing. Skip the distributed warehouse entirely; revisit only past low-terabyte scale.
- If non-analysts need answers, not just analysts needing queries
- Hex — Threads for plain-English self-serve on a governed semantic model beats mailing notebook links, and Agent Tasks handles the recurring questions.
- If you're on GCP or can get Google startup credits
- BigQuery — 1 TiB/month free queries plus $2k–$350k program credits means your warehouse is effectively free until product-market fit.
- If analytics is user-facing product — dashboards in your app, observability, agent telemetry
- ClickHouse (Cloud, or Tinybird for the managed-API path); DuckDB-class engines aren't built for that concurrency.
- If you want notebooks in git, reviewed like code, at zero cost
- Marimo — pure .py files with reactive execution; fall back to Jupyter only when a library or workflow demands .ipynb.
Warehouse & Notebooks: the whole field
21 more tools tracked in this category, including 8 dead, renamed, or sunsetting — a reference that hides the graveyard isn't one. Verified 2026-08-06.
| Tool | Maker | What it is | Entry | Status |
|---|---|---|---|---|
| Snowflake | Snowflake | The enterprise warehouse default; fine for startups on trial + startup credits, but per-credit pricing (unpublished list rates, ~$2+/credit) is the classic scale-up tax | 30-day trial, then per-credit | active |
| Databricks | Databricks | Full lakehouse platform with a Free Edition (Jun 2025) — real, but a heavyweight buy for a startup's first warehouse; also owns Neon (Postgres, 2025) | Free Edition · usage-based | active |
| Deepnote | Deepnote | Collaborative data workspace, open-sourced (Apache-2.0) in 2026; 500k+ users, agents launchable from Claude Code; acquired Hyperquery — the strongest Hex alternative | free tier | active |
| Jupyter / JupyterLab | Project Jupyter (BSD) | Still the substrate everything else defines itself against; jupyter-ai bolts LLMs on, but hidden-state reproducibility pain is why marimo exists | free | active |
| Google Colab | Free hosted Jupyter with GPUs; the ML-experiment default more than an analytics home | free · Pro from ~$10/mo | active | |
| molab | marimo / CoreWeave | Marimo's cloud — free tier with GPU-accelerated compute expanding post-acquisition | free tier | active |
| Observable | Observable | Reactive JavaScript notebooks (2.0 live 2026, 1M+ notebooks created) + Framework; dataviz-first, not a warehouse client for most teams | free tier | active |
| Evidence | Evidence (YC) | Open-source BI-as-code (SQL + markdown, ~33.6k weekly npm installs) plus an Analytics Agent — straddles this element and Bi | free (OSS) · cloud paid | active |
| Count | Count | Canvas-based agentic analytics (SQL + Python + whiteboard); 4,000+ data professionals, G2 2026 mid-market leader | free tier | active |
| Tinybird | Tinybird | Managed ClickHouse as developer APIs — the fastest path to user-facing analytics; used by Vercel, Canva | free tier | active |
| DuckLake | DuckDB Labs / MotherDuck | SQL-catalog lakehouse format, v1.0 Apr 2026 — the small-data answer to Iceberg's complexity | free | active |
| Firebolt | Firebolt | Efficiency-pitched cloud warehouse for data apps; squeezed between ClickHouse and the giants, momentum quiet | usage-based | fading |
| Bauplan | Bauplan Labs | Function-first lakehouse compute pitched at AI-agent data workflows; early but watched | usage-based | active |
| Fabi.ai | Fabi | AI-analyst notebook workspace for lean teams; seed-stage, single-source claims | free tier | active |
| Querybook | Pinterest (OSS) | Open-source big-data notebook/IDE; maintenance-mode energy since the agent wave | free | fading |
| Apache Zeppelin | Apache | The pre-Jupyter-dominance big-data notebook; releases sparse, mindshare gone | free | fading |
| Mode | ThoughtSpot | SQL-notebook BI pioneer; acquired by ThoughtSpot (2023), still sold under its own brand but roadmap serves the parent | free tier | acquired |
| Hashboard | → Hex | Metrics-first BI; team joined Hex with the May 2025 Series C | — | acquired |
| Hyperquery | → Deepnote | SQL doc-notebook; absorbed into Deepnote | — | acquired |
| Noteable | Noteable | Collaborative notebook startup; shut down late 2023 after the ChatGPT-plugin wave it rode receded | — | dead |
| Zepl | → DataRobot | Zeppelin-lineage notebook cloud; acquired by DataRobot (2021), product gone | — | dead |
Warehouse & Notebooks: the category in numbers
Edition v2026.Q3 · ranking, pricing and status verified 2026-08-06.
- ClickHouse: $400M Series D at $15B (Jan 16, 2026) + Langfuse acquisition; annualized revenue tripled to $250M by May 2026 on an IPO path [src]
- DuckDB crossed 40,000 GitHub stars Aug 5, 2026 (30k in Jun 2025); DuckLake v1.0 shipped Apr 2026 — small-data tooling compounding fast [src]
- Hex raised a $70M Series C (May 28, 2025 — Avra, a16z, Sequoia, Snowflake) and spent 2026 shipping agent infrastructure: MCP, Agent Tasks, Evals [src]
- Fivetran and dbt Labs completed their merger Jun 1, 2026 — the modern-data-stack's two poster children consolidating 'for the agentic AI era' [src]
- CoreWeave acquired marimo (Oct 30, 2025) — an AI-infrastructure giant buying a notebook, signaling notebooks as strategic agent surface [src]
- The small-data movement institutionalized: Small Data SF (backed by MotherDuck, Hex, Omni) rebrands as Data Outpost for Nov 4–5, 2026 — thesis: 'simplicity is scalable', modern hardware covers most workloads [src]
Warehouse & Notebooks: method & sources
Charter: ranked on startup fit — cost-to-first-answer, AI/agent capability, and honest scale ceiling — not enterprise feature depth. Hex 2026 funding: we could verify no round after the May 28, 2025 $70M Series C (vendor blog is primary; TechCrunch's hex tag stops at 2023); valuation undisclosed — aggregator figures not used. MotherDuck likewise shows no raise after Sep 2023 on vendor or press pages; noted as a diligence flag, not a red one. ClickHouse conflict resolved: Wikipedia carries the $6.35B Series C (May 2025); TechCrunch's $15B Series D (Jan 2026) is newer and primary-reported, so we cite it. Snowflake per-credit rates are not on its public pricing page — the ~$2+/credit figure is industry-common but weakly sourced here, and its startup-program page 404'd during research (program terms unverified). Adjacent elements: product/event analytics (PostHog, Amplitude) → An; conversational BI and modeled BI (Omni, Lightdash, and the consumption side of Hex Threads) → Bi; Langfuse (now ClickHouse-owned) → Ev; Streamlit-style data apps and app-builders → Vb; Neon/Postgres and OLTP databases belong to the database element, not here. Evidence and Count straddle Wh/Bi — listed here for their notebook/code-first workflows. Ranking criteria: verified commercial traction, independent satisfaction surveys, agent benchmarks, and founder-fit (price floor, lock-in, surfaces). Editorial, never paid — the charter. Machine-readable twin: wh.json.
All sources (25)
- https://hex.tech/pricing/
- https://hex.tech/blog/series-c/
- https://hex.tech/blog/
- https://learn.hex.tech/docs
- https://motherduck.com/pricing/
- https://motherduck.com/blog/
- https://duckdb.org/news/
- https://techcrunch.com/tag/clickhouse/
- https://en.wikipedia.org/wiki/ClickHouse
- https://clickhouse.com/pricing
- https://cloud.google.com/bigquery/pricing
- https://cloud.google.com/startup
- https://marimo.io/
- https://marimo.io/blog/joining-coreweave
- https://docs.marimo.io/
- https://deepnote.com/
- https://www.smalldatasf.com/
- https://www.getdbt.com/blog
- https://observablehq.com/
- https://evidence.dev/
- https://count.co/
- https://www.tinybird.co/
- https://mode.com/
- https://www.snowflake.com/en/pricing-options/
- https://techcrunch.com/tag/motherduck/
Our take
DuckDB-class tools made 'small data' respectable. Most startups never need more — and AI writes the SQL now.
Combines with
This is element 45 of 58. The table is versioned quarterly — when a tool loses its seat, the changelog records the succession.
Explore the full table →