US 12,461,906 B2
File-based error handling during ingestion with transformation
Abdullah Al Mahmood, Bothell, WA (US); Ruta Dhaneshwar, Redmond, WA (US); Max Heimel, Berlin (DE); Xin Huang, Bellevue, WA (US); Canzhou Qu, Bellevue, WA (US); Purav B. Saraiya, Kirkland, WA (US); and Konstantinos Zoumpatianos, Berlin (DE)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on Nov. 5, 2024, as Appl. No. 18/938,063.
Application 18/938,063 is a continuation of application No. 18/321,994, filed on May 23, 2023, granted, now 12,169,486.
Claims priority of provisional application 63/380,163, filed on Oct. 19, 2022.
Prior Publication US 2025/0061107 A1, Feb. 20, 2025
This patent is subject to a terminal disclaimer.
Int. Cl. G06F 16/23 (2019.01); G06F 16/215 (2019.01); G06F 16/25 (2019.01)
CPC G06F 16/2365 (2019.01) [G06F 16/215 (2019.01); G06F 16/258 (2019.01)] 30 Claims
OG exemplary drawing
 
1. A machine-implemented method comprising:
parsing one or more input files to generate one or more input data columns during a copy operation to transfer data from the one or more input files to a database;
performing one or more operations on the one or more input data columns to produce one or more result data columns;
identifying one or more errors occurring during the performing of the one or more operations;
recording the one or more errors in one or more error indicator arrays corresponding to the one or more result data columns;
filtering the one or more result data columns based on the one or more error indicator arrays to generate one or more filtered result data columns; and
storing the one or more filtered result data columns into the database.