Snowflake inc. (20250117382). QUERY REFRESH USING MULTIPLE PROCESSING PIPELINES
QUERY REFRESH USING MULTIPLE PROCESSING PIPELINES
Organization Name
Inventor(s)
Tyler Arthur Akidau of Seattle WA US
Tyler Jones of Redwood City CA US
Prasanna Rajaperumal of Bangalore IN
Daniel E. Sotolongo of Seattle WA US
QUERY REFRESH USING MULTIPLE PROCESSING PIPELINES
This abstract first appeared for US patent application 20250117382 titled 'QUERY REFRESH USING MULTIPLE PROCESSING PIPELINES
Original Abstract Submitted
a system includes at least one hardware processor and at least one memory storing instructions that cause the at least one hardware processor to perform operations. the operations include generating a log of changes posted to a plurality of intermediate materialized tables (mts) during execution of a query in a network-based database system. the query is associated with a source mt that the intermediate mts depend on. the operations include rendering the log of changes into a dependency graph. the operations include configuring a plurality of processing pipelines based on the dependency graph. the operations include performing refreshes on one or more of the plurality of intermediate mts in at least one of the plurality of processing pipelines to complete the refresh operation. the refreshes are performed responsive to detecting an instruction for a refresh operation on the source mt.