US 11,704,100 B2
Inline compilation of user defined functions
Elliott Brossard, Kirkland, WA (US); Siddharth Kulkarni, Sammamish, WA (US); and Isaac Kunen, Seattle, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Aug. 31, 2022, as Appl. No. 17/823,621.
Application 17/823,621 is a continuation of application No. 17/389,871, filed on Jul. 30, 2021, granted, now 11,461,080.
Claims priority of provisional application 63/197,712, filed on Jun. 7, 2021.
Prior Publication US 2022/0413816 A1, Dec. 29, 2022
Int. Cl. G06F 8/41 (2018.01); G06F 21/60 (2013.01); G06F 9/54 (2006.01); G06F 21/53 (2013.01); G06F 16/2455 (2019.01); G06F 16/245 (2019.01)
CPC G06F 8/44 (2013.01) [G06F 9/547 (2013.01); G06F 16/245 (2019.01); G06F 16/2455 (2019.01); G06F 21/53 (2013.01); G06F 21/602 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a compute service manager of a cloud processing system operating using a first programming language, a query referencing a user defined function (UDF) including a body with a code portion in a second programming language;
generating a query plan to execute the query, the query plan including at least one function associated with the UDF;
transmitting the query plan to a processing node;
retrieving, by the processing node, stored compiled results associated with the UDF, wherein the processing node references a target storage defined in the UDF to retrieve the stored compiled results;
executing the UDF with the compiled results using data in a database referenced in the query; and
generating a response to the query based on executing the UDF.