Two of fourteen models named Google BigQuery first on the direct prompt; zero named ClickHouse Cloud. Google BigQuery was named by fourteen of the fourteen models and ClickHouse Cloud by eleven and Google BigQuery carries 78 labels and ClickHouse Cloud 26, so the shares are not directly comparable.
Named in three categories this edition.
Named in six categories this edition.
Share is the count of first choices across the direct, paraphrase, budget and scale prompts over all fourteen models, for a mid-market B2B company; rank is within the category; every quote names the model and the prompt it came from. Both figures come from the data warehouses page.
Across every category in the November 2026 Edition, Google BigQuery and ClickHouse Cloud were named in the same answer sixty-two times, of the 274 answers naming Google BigQuery and the 204 naming ClickHouse Cloud. In those answers ClickHouse Cloud took the first choice one time and Google BigQuery twenty-five.
| Model | Direct | Paraphrase | Comparative | Budget-constrained | Scale-constrained | Negative |
|---|---|---|---|---|---|---|
| Claude Haiku 4.5 | ||||||
| GPT-5.4 mini | ||||||
| Gemini 3.5 Flash | ||||||
| Perplexity Sonar | ||||||
| Grok 4.20 | ||||||
| Mistral Small | ||||||
| DeepSeek V4 Flash | ||||||
| Llama 4 Maverick | ||||||
| Qwen 3.7 Flash | ||||||
| Kimi K2 | ||||||
| GLM 4.7 FlashX | ||||||
| MiniMax M2.5 | ||||||
| GPT-6 Luna | ||||||
| Muse Glimmer 30B |
Bold names in an answer are the products the judge labeled a first choice; a model naming several gives each of them that label. The full answer text for every row is in the record.
Every negative label with a quote, up to three, then the highest-weighted positives, up to three. Six of eight in this category shown.
“Tools like Snowflake, BigQuery, and Redshift are optimized for structured business intelligence (BI) and reporting.” Mistral Small · negative prompt · soft negative
“Be Cautionary If: You are not already on Google Cloud Platform (GCP) or need flexible capacity management.” Qwen 3.7 Flash · negative prompt · soft negative
“BigQuery is an excellent product, but you must implement strict quotas, cost controls, query limits” Gemini 3.5 Flash · negative prompt · soft negative
“For most small-to-mid-sized companies on a limited budget, Google BigQuery is arguably the best starting point” DeepSeek V4 Flash · budget prompt · first choice
“the most common "safe bet" is Snowflake or Google BigQuery because they abstract away cluster management” MiniMax M2.5 · comparative prompt · first choice
“Start with BigQuery if you are cost-conscious, have variable data volumes, or are already on Google Cloud.” Qwen 3.7 Flash · direct prompt · first choice
Every negative label with a quote, up to three, then the highest-weighted positives, up to three. Five of five in this category shown.
“often favor specialized engines like ClickHouse for cost/performance at scale” Grok 4.20 · comparative prompt · soft negative
“more specialized and less "all‑in‑one" for a typical mid‑size B2B stack” GLM 4.7 FlashX · paraphrase prompt · soft negative
“Best for Raw Cost Efficiency: ClickHouse Cloud ... order-of-magnitude better value (often 10x cheaper)” Qwen 3.7 Flash · budget prompt · first choice
“ClickHouse Cloud is consistently shown as the cost-performance leader.” Muse Glimmer 30B · budget prompt · first choice
“if your workloads are event-centric and latency-sensitive, ClickHouse or Firebolt will likely give you the best price-performance” MiniMax M2.5 · comparative prompt · alternative
Comparisons are drawn for the top eight products in each category, each against each. The output is the models' output; nothing here is a recommendation by the index.