US 12,277,101 B2
Dataframe workloads using read-only data snapshots
Srilakshmi Chintala, Seattle, WA (US); Jianzhun Du, Kirkland, WA (US); Naresh Kumar, Santa Clara, CA (US); Srinath Shankar, Belmont, CA (US); Leonhard Franz Spiegelberg, San Francisco, CA (US); Eric Shawn Vandenberg, Saratoga, CA (US); Andong Zhan, San Mateo, CA (US); and Yun Zou, Sunnyvale, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Dec. 21, 2023, as Appl. No. 18/393,279.
Claims priority of provisional application 63/583,525, filed on Sep. 18, 2023.
Prior Publication US 2025/0094403 A1, Mar. 20, 2025
Int. Cl. G06F 16/22 (2019.01); G06F 16/11 (2019.01); G06F 16/242 (2019.01); G06F 16/2453 (2019.01)
CPC G06F 16/2272 (2019.01) [G06F 16/128 (2019.01); G06F 16/244 (2019.01); G06F 16/2453 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by at least one hardware processor, a query referencing a table;
in response to receiving the query, generating a row index column for rows of a referenced table, the generating of the row index column comprising:
determining an order associated with source files underlying the referenced table; and
assigning each row of the referenced table a unique row position value based on the order of the source files and a position of each row within the source files;
generating a result set based on execution of the received query, the result set being ordered based on the generated row index column to provide deterministic row ordering; and
returning the result set with the deterministic row ordering.