US 12,321,350 B1
Query block boundary identification
Walter Zhen Cai, Seattle, WA (US); Sangyong Hwang, Sammamish, WA (US); Wesley A. Leung, Bellevue, WA (US); Sourav Sikdar, Houston, TX (US); and Li Yan, Redmond, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Nov. 30, 2023, as Appl. No. 18/525,296.
Int. Cl. G06F 16/00 (2019.01); G06F 16/2452 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/24542 (2019.01) [G06F 16/2452 (2019.01)] 20 Claims
OG exemplary drawing
 
1. A system comprising:
at least one hardware processor; and
a memory storing instructions that cause the at least one hardware processor to perform operations comprising:
receiving a query, the query including a set of statements;
generating a set of query blocks based on parsing the query, each query block being assigned a unique identifier and unique name;
storing query block metadata for each query block from the set of query blocks;
generating a set of logical query block boundaries;
performing a hash-based query block matching; and
generating, after performing the hash-based query block matching, a final query plan.