US 11,748,318 B1
Schema evolution
Istvan Cseri, Seattle, WA (US); Benoit Dageville, San Mateo, CA (US); Ganeshan Ramachandran Iyer, Redmond, WA (US); Yucan Liu, Bellevue, WA (US); and Jiaqi Yan, Menlo Park, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Jan. 31, 2023, as Appl. No. 18/104,253.
Application 18/104,253 is a continuation of application No. 17/934,369, filed on Sep. 22, 2022, granted, now 11,625,367.
Claims priority of provisional application 63/366,034, filed on Jun. 8, 2022.
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/00 (2019.01); G06F 16/21 (2019.01)
CPC G06F 16/211 (2019.01) 24 Claims
OG exemplary drawing
 
1. A method comprising:
receiving, by a compute service manager, a copy command to copy a file into a source table;
generating, by the compute service manager, a query plan to execute the copy command;
assigning, by the compute service manager, one or more execution nodes to execute the query plan;
detecting, by the one or more execution nodes, a schema mismatch between the file and the source table;
generating, by the one or more execution nodes, a message based on detecting the schema mismatch;
modifying, by the compute service manager, a schema for the source table based on the message;
compiling, by the compute service manager, a modified query plan for the copy command based on the modified schema of the source table; and
executing, by the one or more execution nodes, the copy command based on the modified query plan to copy the file into the source table.