DBScholar

Back to papers

What's the Difference? Incremental Processing with Change Queries in Snowflake

Summary: Snowflake introduces CHANGES queries and STREAM objects to query and consume incremental changes to tables over time. We detail semantics, discuss implementation challenges, report production usage, and contrast with other change-query offerings. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
6761
Venue
SIGMOD
Year
2023
Pagerank
5.3251649e-05
Overall Rank
9,064 | 37.82%
DOI
10.1145/3589776

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{akidau_sigmod23,
        title = {{What's the Difference? Incremental Processing with Change Queries in Snowflake}},
        author = {Akidau, Tyler and Barbier, Paul and Cseri, Istvan and Hueske, Fabian and Jones, Tyler and Lionheart, Sasha and Mills, Daniel and Pauliukevich, Dzmitry and Probst, Lukas and Semmler, Niklas and Sotolongo, Dan and Zhang, Boyuan},
        series = {{SIGMOD} '23},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3589776},
        url = {https://dl.acm.org/doi/10.1145/3589776},
        year = {2023}
}

Incoming Citations (Sorted by Pagerank)

Showing 2 of 2 citing papers.

Rank Citing Paper Year Venue Pagerank
9,050 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD 5.3251649e-05
10,842 Agamotto: Scheduling of Deadline-Oriented Incremental Query Execution under Uncertain Resource Price 2025 VLDB 5.093636e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank Cited Paper Year Venue Pagerank
61 Maintaining Views Incrementally 1993 SIGMOD 0.00039026867
220 Storm @Twitter 2014 SIGMOD 0.00024244587
224 MillWheel: Fault-Tolerant Stream Processing at Internet Scale 2013 VLDB 0.00024130894
445 Apache Calcite: A Foundational Framework for Optimized Query Processing Over Heterogeneous Data Sources 2018 SIGMOD 0.00018336751
455 Differential dataflow 2013 CIDR 0.00018133241
732 Cayuga: A General Purpose Event Monitoring System 2007 CIDR 0.00014536846
1,190 Structured Streaming: A Declarative API for Real-Time Applications in Apache Spark 2018 SIGMOD 0.00011743246
1,895 Samza: Stateful Scalable Stream Processing at LinkedIn 2017 VLDB 9.5260291e-05
2,469 FoundationDB: A Distributed Unbundled Transactional Key Value Store 2021 SIGMOD 8.5354086e-05
4,389 Consistency and Completeness: Rethinking Distributed Stream Processing in Apache Kafka 2021 SIGMOD 6.7304854e-05
4,907 One SQL to Rule Them All – an Efficient and Syntactically Idiomatic Approach to Management of Streams and Tables 2019 SIGMOD 6.4494002e-05
6,626 Tempura: A General Cost-Based Optimizer Framework for Incremental Data Processing 2021 VLDB 5.8198723e-05
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,534 Shared Arrangements: practical inter-query sharing for streaming dataflows 2020 VLDB
2 4,583 Continuous Analytics: Rethinking Query Processing in a Network-Effect World 2009 CIDR
3 2,838 Continuous Queries in Oracle 2007 VLDB
4 7,660 Pruning in Snowflake: Working Smarter, Not Harder 2025 SIGMOD
5 5,552 Enabling Incremental Query Re-Optimization 2016 SIGMOD
6 8,846 Workload Insights From The Snowflake Data Cloud: What Do Production Analytic Queries Really Look Like? 2025 VLDB
7 7,967 Thrifty Query Execution via Incrementability 2020 SIGMOD
8 8,065 Changing Flights in Mid-air: A Model for Safely Modifying Continuous Queries 2011 SIGMOD
9 4,985 Change Propagation Without Joins 2023 VLDB
10 9,050 Streaming Democratized: Ease Across the Latency Spectrum with Delayed View Semantics and Snowflake Dynamic Tables 2025 SIGMOD