Data Warehouses & Lakehouses arenaData Warehouses & Lakehouses
Cloud analytical data platforms — warehouses and lakehouses for SQL analytics over large datasets — judged on SQL surface, ingestion and pipelines, governance and RBAC, cost-model clarity, notebooks, semantic layers, sharing and marketplaces, streaming, dbt integration, and how completely an AI agent can run governed analytics through APIs, CLIs, and MCP. ClickHouse is judged in the Serverless & Developer Databases arena as that field's analytical anchor, and standalone query engines without managed warehousing stay out of scope here.
54 user stories · 216 judged cells · updated 2026-09-16 · Evidence as of 2026-09-16
Leaderboard — every product ranked by evidenceLeaderboard
Rank by
| 1 |  Databricksusage-based vs Snowflake ↗ | 70/100 | 76/100 | 17/100 | 17/100 | 55/100 | pypi 18.9M/wk | 14/45 verified · 2 disputed | 16/100 integrity | ||
| 2 |  Snowflakeusage-based vs Databricks ↗ | 58/100 | 42/100 | 43/100 | 32/100 | 32/100 | pypi 23.1M/wk | 19/44 verified · 1 disputed | 30/100 integrity | ||
| 3 |  BigQueryusage-based vs Databricks ↗ | 41/100 | 57/100 | 27/100 | 35/100 | 48/100 | pypi 32.7M/wk | 16/42 verified · 2 disputed | 0/100 integrity | ||
| 4 |  MotherDuckfree-tier vs Databricks ↗ | 56/100 | 56/100 | 30/100 | 16/100 | 15/100 | 21/36 verified | 45/100 integrity |
Best by user type — persona-weighted winnersBest by user type
Per persona, the product with the highest persona-weighted coverage over just that persona's stories — not the same ranking as the overall PA Score leaderboard above.
Best for platform-engineer
Snowflake
41/100
Runner-up: Databricks (39/100)
5 platform-engineer stories scored
Story matrix — every product × every judged storyStory matrix
54/54 stories shown · legend
Agent analytics — stories about agent analytics in this arenaAgent analytics
Agent ops
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Agent analytics — stories about agent analytics in this arenaMy agent can run governed SQL end to end — authenticate, discover schemas, query, and read results back through a CLI or API with no dashboard in the loop | ai-native | fullT 8/10 | fullT 8/10 | fullT 8/10 | fullT⚿ 8/10 |
| Agent analytics — stories about agent analytics in this arenaA built-in AI assistant writes, fixes, and explains SQL against my schemas from natural language, inside the product | ai-native | partialC 7/10 | fullC 8/10 | fullC 8/10 | fullT⚿ 8/10 |
| Agent analytics — stories about agent analytics in this arenaBusiness users can ask questions in natural language and get governed, semantically-grounded answers rather than hallucinated joins | ai-native | fullC 7/10 | fullC 8/10 | partialC 6/10 | partialT⚿ 6/10 |
Agenticness — how well agents can access and operate the productAgenticness
Agent access
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Agenticness — how well agents can access and operate the productPoint an agent at llms.txt or agent-oriented docs | ai-native | fullT 9/10 | fullT 8/10 | none 0/10 | fullT 9/10 |
| Agenticness — how well agents can access and operate the productRun the product headlessly / in CI for automation | ai-native | fullT 8/10 | fullT 8/10 | fullT 8/10 | fullT 8/10 |
| Agenticness — how well agents can access and operate the productPlug MCP servers into this product so it can use their tools | ai-native | none 0/10 | fullT 8/10 | none 0/10 | none 0/10 |
| Agenticness — how well agents can access and operate the productConnect an agent via an official MCP server | ai-native | fullT 9/10 | fullT 8/10 | partialT 6/10 | fullT⚿ 9/10 |
| Agenticness — how well agents can access and operate the productUse an official CLI | ai-native | fullT 8/10 | fullT 9/10 | fullT 8/10 | partialT 6/10 |
| Agenticness — how well agents can access and operate the productDrive the product through a documented public API | ai-native | fullT 8/10 | fullT 9/10 | fullT 8/10 | fullT⚿ 9/10 |
| Agenticness — how well agents can access and operate the productIssue scoped/least-privilege API credentials for an agent | ai-native | partialC 5/10 | partialC 4/10 | partialC 5/10 | partialT⚿ 6/10 |
| Agenticness — how well agents can access and operate the productBuild against official SDKs | ai-native | fullT 7/10 | fullT 9/10 | fullT 7/10 | fullT⚿ 8/10 |
| Agenticness — how well agents can access and operate the productSubscribe to events via webhooks | ai-native | none 0/10 | none 0/10 | none 0/10 | none 0/10 |
Agentic features
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Agenticness — how well agents can access and operate the productGet AI-generated insights and suggestions from my data inside the product | ai-native | fullC 8/10 | fullC 8/10 | fullC 8/10 | fullT⚿ 8/10 |
| Agenticness — how well agents can access and operate the productSet up automations that run autonomously in the background | ai-native | partialC 5/10 | fullC 7/10 | partialC 5/10 | partialC 5/10 |
| Agenticness — how well agents can access and operate the productDelegate tasks to a built-in AI assistant inside the product | ai-native | partialC 4/10 | fullC 8/10 | fullC 7/10 | partialC 7/10 |
| Agenticness — how well agents can access and operate the productOperate the product with natural-language commands | ai-native | partialC 7/10 | fullC 7/10 | partialC 7/10 | fullT⚿ 8/10 |
Api quality
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Agenticness — how well agents can access and operate the productExplore an interactive API reference with runnable examples | ai-native | partialT 3/10 | partialT 4/10 | none 0/10 | none 0/10 |
| Agenticness — how well agents can access and operate the productDownload a machine-readable API spec (OpenAPI or equivalent) | ai-native | fullT 8/10 | none 0/10 | partialT 6/10 | fullT 9/10 |
| Agenticness — how well agents can access and operate the productTest against a sandbox environment without touching production data | ai-native | partialC 5/10 | none 0/10 | fullC 7/10 | partialT 5/10 |
| Agenticness — how well agents can access and operate the productRely on versioned APIs with a documented deprecation policy | ai-native | partialC 6/10 | partialC 6/10 | partialT 4/10 | none 0/10 |
Automation depth — how much of the product can run unattendedAutomation depth
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Automation depth — how much of the product can run unattendedPerform bulk operations across many items at once | ai-native | partialC 6/10 | fullT 7/10 | fullX 7/10 | partialT 6/10 |
| Automation depth — how much of the product can run unattendedDefine rules that trigger actions automatically on events | ai-native | partialC 6/10 | partialC 6/10 | partialC 4/10 | none 0/10 |
| Automation depth — how much of the product can run unattendedSchedule recurring jobs or workflows | ai-native | partialC 4/10 | fullT 8/10 | fullC 7/10 | partialC 4/10 |
| Automation depth — how much of the product can run unattendedVersion, review, and roll back my automations | ai-native | partialC 4/10 | partialC 5/10 | partialC 5/10 | none 0/10 |
Cost economics — stories about cost economics in this arenaCost economics
Pricing
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Cost economics — stories about cost economics in this arenaThe pricing model is documented clearly enough that I can estimate a monthly bill for my workload before committing | platform-engineer | disputedD 5/10 | partialX 5/10 | disputedD 5/10 | partialC 6/10 |
| Cost economics — stories about cost economics in this arenaBudgets, resource monitors, or auto-suspend stop a runaway query or idle compute from burning money overnight | platform-engineer | fullX 8/10 | partialC 5/10 | disputedD 4/10 | partialC 5/10 |
Trial
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Cost economics — stories about cost economics in this arenaEvaluate with a free tier or trial — real queries on real data without a credit card or a sales call | analyst | partialX 5/10 | fullC 7/10 | fullC 8/10 | fullT 9/10 |
Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesEcosystem integrations
Bi
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesStandard drivers (JDBC/ODBC) and documented BI-tool integrations connect my dashboards without custom glue | analyst | none 0/10 | fullC 7/10 | fullT 9/10 | partialC 4/10 |
Dev loop
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesI get a fast local or free dev loop — a local engine, emulator, or sandbox — to develop transformations before touching production compute | data-engineer | none 0/10 | partialX 5/10 | partialC 5/10 | fullT 8/10 |
Transformation
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Ecosystem integrations — the surrounding ecosystem — integrations, marketplaces, community packagesDbt is a first-class citizen — a documented adapter or native dbt project support with vendor docs to match | data-engineer | fullX 8/10 | fullC 8/10 | none 0/10 | fullC 8/10 |
Governance access — stories about governance access in this arenaGovernance access
Access
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Governance access — stories about governance access in this arenaAccess control reaches tables, columns, and rows — roles plus masking policies — so one warehouse can serve many teams safely | platform-engineer | partialC 5/10 | disputedD 4/10 | partialT 5/10 | partialC 4/10 |
Governance
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Governance access — stories about governance access in this arenaI get audit logs of who ran what and column-level lineage of where data came from | platform-engineer | partialC 6/10 | fullC 8/10 | none 0/10 | none 0/10 |
| Governance access — stories about governance access in this arenaCompliance attestations (SOC 2, HIPAA, PCI) are documented so security review does not stall the rollout | platform-engineer | fullC 8/10 | fullC 8/10 | fullC 8/10 | none 0/10 |
Ingestion pipelines — stories about ingestion pipelines in this arenaIngestion pipelines
Connectors
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Ingestion pipelines — stories about ingestion pipelines in this arenaFirst-party and partner connectors cover my sources — SaaS apps, databases, and ETL/ELT tools — with documented setup | data-engineer | partialC 4/10 | partialC 6/10 | partialX 5/10 | partialC 5/10 |
Loading
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Ingestion pipelines — stories about ingestion pipelines in this arenaBulk-load CSV, JSON, and Parquet from cloud object storage with a single documented command | data-engineer | partialX 5/10 | partialC 6/10 | fullT 9/10 | partialC 5/10 |
| Ingestion pipelines — stories about ingestion pipelines in this arenaA managed service continuously ingests new files or events as they arrive, without me running my own pipeline infrastructure | data-engineer | fullX 8/10 | fullC 8/10 | fullC 8/10 | partialC 4/10 |
Notebooks workspace — stories about notebooks workspace in this arenaNotebooks workspace
Notebooks
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Notebooks workspace — stories about notebooks workspace in this arenaFirst-party notebooks let me mix SQL and Python against warehouse data, with results and charts inline | analyst | fullX 8/10 | fullC 8/10 | fullC 8/10 | partialX 4/10 |
Openness — open source, data portability, and self-hosting storiesOpenness
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Openness — open source, data portability, and self-hosting storiesDo everything through the API that I can do in the UI | ai-native | partialT 6/10 | disputedD 5/10 | partialT 7/10 | partialT⚿ 6/10 |
| Openness — open source, data portability, and self-hosting storiesExport all of my data in open formats and leave | ai-native | partialX 5/10 | partialX 6/10 | partialC 5/10 | partialT 5/10 |
| Openness — open source, data portability, and self-hosting storiesRead the product's source under an open license | ai-native | n/a | n/a | n/a | none 0/10 |
| Openness — open source, data portability, and self-hosting storiesSelf-host the core product | ai-native | n/a | none 0/10 | n/a | none 0/10 |
Privacy posture — data-handling and privacy storiesPrivacy posture
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Privacy posture — data-handling and privacy storiesChoose where my data is stored (region/residency) | ai-native | none 0/10 | none 0/10 | none 0/10 | none 0/10 |
| Privacy posture — data-handling and privacy storiesPrevent my data from being used to train AI models | ai-native | none 0/10 | none 0/10 | none 0/10 | none 0/10 |
| Privacy posture — data-handling and privacy storiesControl data retention and deletion | ai-native | partialC 5/10 | none 0/10 | partialC 5/10 | none 0/10 |
| Privacy posture — data-handling and privacy storiesOpt out of telemetry and usage tracking | ai-native | none 0/10 | none 0/10 | none 0/10 | none 0/10 |
Semantic layer — stories about semantic layer in this arenaSemantic layer
Semantics
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Semantic layer — stories about semantic layer in this arenaDefine a governed semantic model — metrics, dimensions, and joins declared once — that queries and AI tools answer against consistently | analyst | fullC 7/10 | fullC 8/10 | none 0/10 | partialC 4/10 |
Sharing marketplace — stories about sharing marketplace in this arenaSharing marketplace
Sharing
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Sharing marketplace — stories about sharing marketplace in this arenaA marketplace of third-party datasets lets me enrich my own data directly inside the platform | analyst | none 0/10 | fullC 8/10 | fullC 8/10 | none 0/10 |
| Sharing marketplace — stories about sharing marketplace in this arenaShare live datasets with another account or organization without copying data or building an export pipeline | data-engineer | fullC 9/10 | fullC 9/10 | fullC 9/10 | fullC 8/10 |
Sql analytics — stories about sql analytics in this arenaSql analytics
Lakehouse
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Sql analytics — stories about sql analytics in this arenaQuery open table formats and files in object storage — Iceberg, Delta, Parquet — without first loading them into proprietary storage | data-engineer | fullC 8/10 | partialC 6/10 | fullC 8/10 | partialC 5/10 |
Performance
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Sql analytics — stories about sql analytics in this arenaInspect query profiles and execution plans to find why a query is slow or expensive | data-engineer | fullX 8/10 | fullC 8/10 | fullX 9/10 | none 0/10 |
Recovery
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Sql analytics — stories about sql analytics in this arenaTime-travel — query data as of a past point and restore dropped or corrupted tables from history | data-engineer | fullC 9/10 | fullC 9/10 | partialC 3/10 | none 0/10 |
Sql
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Sql analytics — stories about sql analytics in this arenaI get a full analytical SQL surface — window functions, CTEs, semi-structured JSON, arrays, and rich date/time types — without bolt-on extensions | analyst | partialX 7/10 | partialC 5/10 | fullX 8/10 | partialT 5/10 |
Streaming realtime — stories about streaming realtime in this arenaStreaming realtime
Streaming
| Story | Persona | Snowflake | Databricks | BigQuery | MotherDuck |
|---|---|---|---|---|---|
| Streaming realtime — stories about streaming realtime in this arenaRun continuous or incremental transformations — streams, tasks, declarative pipelines, or continuous queries — inside the platform | data-engineer | fullC 8/10 | fullC 9/10 | fullC 8/10 | partialC 3/10 |
| Streaming realtime — stories about streaming realtime in this arenaStreaming writes land queryable within seconds through a documented streaming ingestion API | data-engineer | partialC 4/10 | fullC 7/10 | fullC 8/10 | none 0/10 |
Verdict✓ fullclear evidence~ partialwith caveats! disputedevidence conflicts— noneno evidence foundn/aquestion doesn't apply to this kind of product
ProofT probedtested by usX communityusers back itC claimedvendor claim onlyD contradictedevidence disagrees⚿ auth-gatedprobe hit a live sign-in wall — verified reachable, untestable keylessly
quality 0–10 · PA Score /100 · A–D = evidence confidence · full guideAdjacent arenas — categories often shopped togetherAdjacent arenas
Shopping this category often means shopping these too.
Serverless & Developer Databases arenaServerless & Developer Databases
5 products · leader: ClickHouse
Product Analytics arenaProduct Analytics
4 products · leader: PostHog
Workflow Automation arenaWorkflow Automation
6 products · leader: Windmill
Data Pipelines & ELT arenaData Pipelines & ELT
5 products · leader: dlt