Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?

Summary: Analysis of 667M BI queries on Snowflake over two weeks, characterizing production analytic workloads at cloud scale across industries. Reveals detailed filter/join/aggregation behaviors and uncovers workload patterns absent from standard benchmarks, guiding DB research. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 14112
Venue: VLDB
Year: 2025
Pagerank: 4.4283999e-05
Overall Rank: 8,884 | 38.20%
DOI: 10.14778/3750601.3750632

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
8,207	SQLStorm: Taking Database Benchmarking into the LLM Era	2025	VLDB	4.5583637e-05
10,295	Global Hash Tables Strike Back! An Analysis of Parallel GROUP BY Aggregation	2026	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 19 of 19 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
109	Dremel: Interactive Analysis of Web-Scale Datasets	2010	VLDB	0.00048186983
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039180521
209	Schism: a Workload-Driven Approach to Database Replication and Partitioning	2010	VLDB	0.00034468292
426	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023594359
716	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017723171
1,284	Amazon Redshift Re-invented	2022	SIGMOD	0.00012837822
2,237	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.2212748e-05
2,568	Towards Cost-Optimal Query Processing in the Cloud	2021	VLDB	8.5239227e-05
2,916	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	7.9068048e-05
2,965	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	7.8059273e-05
3,178	Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet	2024	VLDB	7.4325992e-05
3,789	DIAMetrics: Benchmarking Query Engines at Scale	2020	VLDB	6.7644737e-05
4,549	Database-Agnostic Workload Management	2019	CIDR	6.0926728e-05
4,717	Cloud Analytics Benchmark	2023	VLDB	5.9751539e-05
5,473	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4885366e-05
5,923	HyBench: A New Benchmark for HTAP Databases	2024	VLDB	5.2721765e-05
9,203	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	4.3740313e-05
9,638	TracEx: Understanding and Analyzing Database Traces	2024	CIDR	4.3109052e-05
9,639	CDSBen: Benchmarking the Performance of Storage Services in Cloud-native Database System at ByteDance	2023	VLDB	4.3109052e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,973	End-to-End Declarative Data Analytics: Co-designing Engines, Interfaces, and Cloud Infrastructure	2026	CIDR	4.1945683e-05
3,429	Real-time Workload Pattern Analysis for Large-scale Cloud Databases	2023	VLDB	7.1010535e-05
11,650	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD	4.1945683e-05
3,122	Dynamic Workload Management for Very Large Data Warehouses – Juggling Feathers and Bowling Balls	2007	VLDB	7.5264988e-05
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039180521
2,568	Towards Cost-Optimal Query Processing in the Cloud	2021	VLDB	8.5239227e-05
13,228	White-Box OLAP Performance Modeling for the Cloud	2021	CIDR	-
3,779	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	6.7747205e-05
4,717	Cloud Analytics Benchmark	2023	VLDB	5.9751539e-05
8,415	Pruning in Snowflake: Working Smarter, Not Harder	2025	SIGMOD	4.5197687e-05