US 12,488,048 B2
Accessing data using a user-defined function (UDF)
Elliott Brossard, Kirkland, WA (US); Sukruth Komarla Sukumar, Bellevue, WA (US); Isaac Kunen, Seattle, WA (US); Ju-yi Kuo, Sammamish, WA (US); Jonathan Lee Leang, Seattle, WA (US); Edward Ma, San Jose, CA (US); Schuyler James Manchester, San Jose, CA (US); Polita Paulus, Kirkland, WA (US); Saurin Shah, Kirkland, WA (US); and Igor Zinkovsky, Redmond, WA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Aug. 19, 2024, as Appl. No. 18/808,262.
Application 18/808,262 is a continuation of application No. 18/063,253, filed on Dec. 8, 2022, granted, now 12,118,038.
Application 18/063,253 is a continuation of application No. 17/657,548, filed on Mar. 31, 2022, granted, now 11,550,845.
Application 17/657,548 is a continuation of application No. 17/463,325, filed on Aug. 31, 2021, granted, now 11,361,026.
Application 17/463,325 is a continuation of application No. 17/390,969, filed on Aug. 1, 2021, granted, now 11,423,081.
Application 17/390,969 is a continuation in part of application No. 17/244,349, filed on Apr. 29, 2021, granted, now 11,222,071.
Application 17/244,349 is a continuation of application No. 16/942,352, filed on Jul. 29, 2020, granted, now 10,997,243.
Claims priority of provisional application 63/197,803, filed on Jun. 7, 2021.
Claims priority of provisional application 63/046,229, filed on Jun. 30, 2020.
Prior Publication US 2024/0411812 A1, Dec. 12, 2024
Int. Cl. G06F 16/00 (2019.01); G06F 16/22 (2019.01); G06F 16/2455 (2019.01); G06F 16/901 (2019.01); G06F 16/908 (2019.01); G06F 16/955 (2019.01)
CPC G06F 16/9017 (2019.01) [G06F 16/2282 (2019.01); G06F 16/24568 (2019.01); G06F 16/908 (2019.01); G06F 16/955 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A method comprising:
generating, by at least one hardware processor, a user-defined function (UDF), the UDF including a file reference object corresponding to at least one file and a file operation configuration;
retrieving the at least one file based on a UDF call into the UDF, the retrieving further based on the file reference object;
determining a compression status of the at least one file; and
processing the UDF call to generate result data using the at least one file, the processing based on the compression status and the file operation configuration.