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: 14113
Venue: VLDB
Year: 2025
Pagerank: 4.4254065e-05
Overall Rank: 8,880 | 38.29%
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
7,887	SQLStorm: Taking Database Benchmarking into the LLM Era	2025	VLDB	4.6218382e-05
10,307	Global Hash Tables Strike Back! An Analysis of Parallel GROUP BY Aggregation	2026	VLDB	4.1905499e-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.00048217028
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039408116
208	Schism: a Workload-Driven Approach to Database Replication and Partitioning	2010	VLDB	0.00034478612
424	Amazon Redshift and the Case for Simpler Data Warehouses	2015	SIGMOD	0.00023604384
704	Query-based Workload Forecasting for Self-Driving Database Management Systems	2018	SIGMOD	0.00017785557
1,273	Amazon Redshift Re-invented	2022	SIGMOD	0.00012870386
2,242	Procedural Extensions of SQL: Understanding their usage in the wild	2021	VLDB	9.2124242e-05
2,553	Towards Cost-Optimal Query Processing in the Cloud	2021	VLDB	8.5522099e-05
2,914	Quantifying TPC-H Choke Points and Their Optimizations	2020	VLDB	7.9197583e-05
2,959	SQLShare: Results from a Multi-Year SQL-as-a-Service Experiment	2016	SIGMOD	7.8116974e-05
3,131	Why TPC Is Not Enough: An Analysis of the Amazon Redshift Fleet	2024	VLDB	7.5054309e-05
3,750	DIAMetrics: Benchmarking Query Engines at Scale	2020	VLDB	6.7864305e-05
4,547	Database-Agnostic Workload Management	2019	CIDR	6.0904384e-05
4,681	Cloud Analytics Benchmark	2023	VLDB	5.9953512e-05
5,524	Facilitating SQL Query Composition and Analysis	2020	SIGMOD	5.4589341e-05
6,399	HyBench: A New Benchmark for HTAP Databases	2024	VLDB	5.0740852e-05
9,205	Intelligent Automated Workload Analysis for Database Replatforming	2022	SIGMOD	4.3698717e-05
9,637	TracEx: Understanding and Analyzing Database Traces	2024	CIDR	4.3068069e-05
9,638	CDSBen: Benchmarking the Performance of Storage Services in Cloud-native Database System at ByteDance	2023	VLDB	4.3068069e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,972	End-to-End Declarative Data Analytics: Co-designing Engines, Interfaces, and Cloud Infrastructure	2026	CIDR	4.1905499e-05
11,655	Query-Driven Learning for Next Generation Predictive Modeling & Analytics	2019	SIGMOD	4.1905499e-05
3,435	Real-time Workload Pattern Analysis for Large-scale Cloud Databases	2023	VLDB	7.0946114e-05
3,128	Dynamic Workload Management for Very Large Data Warehouses – Juggling Feathers and Bowling Balls	2007	VLDB	7.5192383e-05
167	The Snowflake Elastic Data Warehouse	2016	SIGMOD	0.00039408116
2,553	Towards Cost-Optimal Query Processing in the Cloud	2021	VLDB	8.5522099e-05
13,241	White-Box OLAP Performance Modeling for the Cloud	2021	CIDR	-
3,777	Instance-Optimized Data Layouts for Cloud Analytics Workloads	2021	SIGMOD	6.7713324e-05
4,681	Cloud Analytics Benchmark	2023	VLDB	5.9953512e-05
8,410	Pruning in Snowflake: Working Smarter, Not Harder	2025	SIGMOD	4.5154358e-05