{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,7,11]],"date-time":"2026-07-11T02:46:30Z","timestamp":1783737990233,"version":"3.55.0"},"reference-count":34,"publisher":"Association for Computing Machinery (ACM)","issue":"12","content-domain":{"domain":["dl.acm.org"],"crossmark-restriction":true},"short-container-title":["Proc. VLDB Endow."],"published-print":{"date-parts":[[2025,8]]},"abstract":"<jats:p>Capturing the characteristics of real-world analytical workloads is challenging yet critical for advancing industry practices and academic research. Historically, obtaining accurate query and data characteristics has been difficult, largely because detailed workload information has often been confined to on-premises database systems. With the rise of cloud-native databases like Snowflake, it has become possible to analyze production query workloads at scale and in greater detail. Leveraging this capability, this study presents a comprehensive analysis of analytics workloads across diverse customers and industries. In particular, we investigate the query characteristics of 667 million queries issued by the most popular BI tools against Snowflake over a two-week period. Based on this dataset, this paper makes two primary contributions: first, we conduct a detailed examination of query properties, with particular attention to filters, joins, aggregations, and other previously underexplored aspects. Second, we uncover unique and practically relevant query patterns that are typically absent from standard database benchmarks.<\/jats:p>","DOI":"10.14778\/3750601.3750632","type":"journal-article","created":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:05Z","timestamp":1758029885000},"page":"5126-5138","update-policy":"https:\/\/doi.org\/10.1145\/crossmark-policy","source":"Crossref","is-referenced-by-count":6,"title":["Workload Insights from the Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like?"],"prefix":"10.14778","volume":"18","author":[{"given":"Jan Vincent","family":"Szlang","sequence":"first","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sebastian","family":"Bress","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Sebastian","family":"Cattes","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Jonathan","family":"Dees","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Florian","family":"Funke","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Max","family":"Heimel","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Michel","family":"Oleynik","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Ismail","family":"Oukid","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]},{"given":"Tobias","family":"Maltenberger","sequence":"additional","affiliation":[{"name":"Snowflake, Inc., Berlin, Germany"}],"role":[{"vocabulary":"crossref","role":"author"}]}],"member":"320","published-online":{"date-parts":[[2025,9,16]]},"reference":[{"key":"e_1_2_1_1_1","unstructured":"Amirhossein Aleyasen. 2022. Overcoming barriers in data warehouse replatforming. Ph.D. Dissertation. University of Illinois at Urbana-Champaign."},{"key":"e_1_2_1_2_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526050"},{"key":"e_1_2_1_3_1","doi-asserted-by":"publisher","DOI":"10.1145\/3514221.3526045"},{"key":"e_1_2_1_4_1","doi-asserted-by":"publisher","DOI":"10.1145\/1594156.1594168"},{"key":"e_1_2_1_5_1","doi-asserted-by":"publisher","DOI":"10.1145\/2983323.2983336"},{"key":"e_1_2_1_6_1","unstructured":"ClickHouse. 2024. ClickBench: a Benchmark For Analytical Databases. github.com\/ClickHouse\/ClickBench. Accessed: 2025-07-10."},{"key":"e_1_2_1_7_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920853"},{"key":"e_1_2_1_8_1","volume-title":"Query Acceleration: Smarter Join Decisions. https:\/\/www.snowflake.com\/engineering-blog\/query-acceleration-smarter-join-decisions\/ Accessed: 2024-12-02.","author":"Daase Bjoern","year":"2024","unstructured":"Bjoern Daase and Rudi Leibbrandt. 2024. Query Acceleration: Smarter Join Decisions. https:\/\/www.snowflake.com\/engineering-blog\/query-acceleration-smarter-join-decisions\/ Accessed: 2024-12-02."},{"key":"e_1_2_1_9_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2903741"},{"key":"e_1_2_1_10_1","doi-asserted-by":"publisher","DOI":"10.1145\/3567464"},{"key":"e_1_2_1_11_1","doi-asserted-by":"publisher","DOI":"10.14778\/3389133.3389138"},{"key":"e_1_2_1_12_1","volume-title":"TracEx: Understanding and Analyzing Database Traces. In 14th Conference on Innovative Data Systems Research, CIDR 2024","author":"Durner Dominik","year":"2024","unstructured":"Dominik Durner, Lennart Espe, Jana Giceva, and Anja Gruenheid. 2024. TracEx: Understanding and Analyzing Database Traces. In 14th Conference on Innovative Data Systems Research, CIDR 2024, Chaminade, HI, USA, January 14\u201317, 2024. www.cidrdb.org."},{"key":"e_1_2_1_13_1","doi-asserted-by":"publisher","DOI":"10.1145\/2723372.2742795"},{"key":"e_1_2_1_14_1","doi-asserted-by":"publisher","DOI":"10.14778\/3457390.3457402"},{"key":"e_1_2_1_15_1","doi-asserted-by":"publisher","DOI":"10.1145\/2882903.2882957"},{"key":"e_1_2_1_16_1","volume-title":"9th Biennial Conference on Innovative Data Systems Research, CIDR","author":"Jain Shrainik","year":"2019","unstructured":"Shrainik Jain, Jiaqi Yan, Thierry Cruanes, and Bill Howe. 2019. Database-Agnostic Workload Management. In 9th Biennial Conference on Innovative Data Systems Research, CIDR 2019, Asilomar, CA, USA, January 13\u201316, 2019, Online Proceedings. www.cidrdb.org. http:\/\/cidrdb.org\/cidr2019\/papers\/p110-jain-cidr19.pdf"},{"key":"e_1_2_1_17_1","doi-asserted-by":"publisher","DOI":"10.14778\/3461535.3461549"},{"key":"e_1_2_1_18_1","doi-asserted-by":"publisher","DOI":"10.1109\/ICDM.2008.17"},{"key":"e_1_2_1_19_1","doi-asserted-by":"publisher","DOI":"10.1145\/3183713.3196908"},{"key":"e_1_2_1_20_1","doi-asserted-by":"publisher","DOI":"10.14778\/1920841.1920886"},{"key":"e_1_2_1_21_1","doi-asserted-by":"publisher","DOI":"10.1007\/978-3-030-55024-0_1"},{"key":"e_1_2_1_22_1","doi-asserted-by":"publisher","DOI":"10.1145\/3676151.3719353"},{"key":"e_1_2_1_23_1","unstructured":"Transaction Processing Performance Council (TPC). 2021. TPC BENCHMARK\u2122 DS Standard Specification Version 3.2.0. www.tpc.org\/TPC_Documents_Current_Versions\/pdf\/TPC-DS_v3.2.0.pdf. Accessed: 2025-07-10."},{"key":"e_1_2_1_24_1","unstructured":"Transaction Processing Performance Council (TPC). 2022. TPC BENCHMARK\u2122 H Standard Specification Version 3.0.1. www.tpc.org\/TPC_Documents_Current_Versions\/pdf\/TPC-H_v3.0.1.pdf. Accessed: 2025-07-10."},{"key":"e_1_2_1_25_1","doi-asserted-by":"publisher","DOI":"10.1109\/SOCA.2011.6166245"},{"key":"e_1_2_1_26_1","doi-asserted-by":"publisher","DOI":"10.14778\/3681954.3682031"},{"key":"e_1_2_1_27_1","doi-asserted-by":"publisher","DOI":"10.14778\/3583140.3583156"},{"key":"e_1_2_1_28_1","unstructured":"Aditya Vashistha and Shrainik Jain. 2015. Measuring Query Complexity in SQL-Share Workload. https:\/\/uwescience.github.io\/sqlshare\/pdfs\/Jain-Vashistha.pdf Accessed: 2025-07-10."},{"key":"e_1_2_1_29_1","doi-asserted-by":"publisher","DOI":"10.1145\/3209950.3209952"},{"key":"e_1_2_1_30_1","volume-title":"17th USENIX Symposium on Networked Systems Design and Implementation (NSDI 20)","author":"Vuppalapati Midhul","year":"2020","unstructured":"Midhul Vuppalapati, Justin Miron, Rachit Agarwal, Dan Truong, Ashish Motivala, and Thierry Cruanes. 2020. Building an elastic query engine on disaggregated storage. In 17th USENIX Symposium on Networked Systems Design and Implementation (NSDI 20). 449\u2013462."},{"key":"e_1_2_1_31_1","volume-title":"Building An Elastic Query Engine on Disaggregated Storage. In 17th USENIX Symposium on Networked Systems Design and Implementation, NSDI 2020","author":"Vuppalapati Midhul","year":"2020","unstructured":"Midhul Vuppalapati, Justin Miron, Rachit Agarwal, Dan Truong, Ashish Motivala, and Thierry Cruanes. 2020. Building An Elastic Query Engine on Disaggregated Storage. In 17th USENIX Symposium on Networked Systems Design and Implementation, NSDI 2020, Santa Clara, CA, USA, February 25\u201327, 2020, Ranjita Bhagwan and George Porter (Eds.). USENIX Association, 449\u2013462. https:\/\/www.usenix.org\/conference\/nsdi20\/presentation\/vuppalapati"},{"key":"e_1_2_1_32_1","doi-asserted-by":"publisher","DOI":"10.14778\/3641204.3641206"},{"key":"e_1_2_1_33_1","doi-asserted-by":"publisher","DOI":"10.14778\/3611540.3611549"},{"key":"e_1_2_1_34_1","doi-asserted-by":"publisher","DOI":"10.1145\/3318464.3380602"}],"container-title":["Proceedings of the VLDB Endowment"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/dl.acm.org\/doi\/pdf\/10.14778\/3750601.3750632","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,9,16]],"date-time":"2025-09-16T13:38:14Z","timestamp":1758029894000},"score":1,"resource":{"primary":{"URL":"https:\/\/dl.acm.org\/doi\/10.14778\/3750601.3750632"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2025,8]]},"references-count":34,"journal-issue":{"issue":"12","published-print":{"date-parts":[[2025,8]]}},"alternative-id":["10.14778\/3750601.3750632"],"URL":"https:\/\/doi.org\/10.14778\/3750601.3750632","relation":{},"ISSN":["2150-8097"],"issn-type":[{"value":"2150-8097","type":"print"}],"subject":[],"published":{"date-parts":[[2025,8]]},"assertion":[{"value":"2025-09-16","order":3,"name":"published","label":"Published","group":{"name":"publication_history","label":"Publication History"}}]}}