US 12,007,961 B2
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 Jun. 30, 2023, as Appl. No. 18/345,987.
Application 18/345,987 is a continuation of application No. 18/104,253, filed on Jan. 31, 2023, granted, now 11,748,318.
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.
Prior Publication US 2023/0401180 A1, Dec. 14, 2023
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 at least one hardware processor, a notification of a schema mismatch between a file to be ingested and a source table;
modifying a schema for the source table based on the notification;
quarantining at least one ingest task associated with the file to be ingested based on detecting the schema mismatch;
compiling a modified query plan for the at least one quarantined ingest task based on the modified schema of the source table;
executing the at least one quarantined ingest task based on the modified query plan; and
ingesting the file into the source table using the modified schema.