Snowflake inc. (20250086168). QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES
QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES
Organization Name
Inventor(s)
Tyler Arthur Akidau of Seattle WA (US)
Tyler Jones of Redwood City CA (US)
Daniel Mills of Seattle WA (US)
Prasanna Rajaperumal of Bangalore (IN)
Daniel E. Dotolongo of Seattle WA (US)
QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES
This abstract first appeared for US patent application 20250086168 titled 'QUERY EXECUTION USING INTERMEDIATE MATERIALIZED TABLES
Original Abstract Submitted
a method for query execution includes configuring, by at least one hardware processor, a materialized table (mt) based on the query and a base table. the mt includes a lag duration indicating a maximum time period that a result of a prior refresh of the query on the base table can lag behind a current time instance. the method further includes generating a query plan for the query. the method further includes determining multiple sets of data processing operations included in the query plan. the method further includes generating a plurality of intermediate mts. the one or more intermediate mts hold an intermediate processing state for the multiple sets of data processing operations. the method further includes configuring a refresh of the mt based on the intermediate processing state for the multiple sets of data processing operations.