Snowflake Inc. patent applications on February 27th, 2025
Patent Applications by Snowflake Inc. on February 27th, 2025
Snowflake Inc.: 7 patent applications
Snowflake Inc. has applied for patents in the areas of G06F16/22 (3), G06F16/2455 (3), G06F11/14 (2), G06F16/23 (2), G06F16/27 (2) G06F11/1435 (1), G06F16/213 (1), G06F16/2291 (1), G06F16/2365 (1), G06F16/24537 (1)
With keywords such as: data, file, table, subject, technology, blob, query, error, node, and stage in patent application abstracts.
Patent Applications by Snowflake Inc.
20250068522. DATABASE METADATA CORRUPTION MITIGATION_simplified_abstract_(snowflake inc.)
Inventor(s): Selcuk Aya of Izmir (TR) for snowflake inc., Leonid Baraznenok of Bothell WA (US) for snowflake inc., Jaeha Lee of Redmond WA (US) for snowflake inc., Adrian Peter Neumann of Berlin (DE) for snowflake inc., Ryan Michael Thomas Shelly of San Francisco CA (US) for snowflake inc., Zerui Wei of San Mateo CA (US) for snowflake inc., Jiaqi Yan of Menlo Park CA (US) for snowflake inc.
IPC Code(s): G06F11/14, G06F11/07, G06F16/215
CPC Code(s): G06F11/1435
Abstract: embodiments of the present disclosure may provide a data protection system that performs identification of errors from queries on a database. the data protection system can further identify corrupted data from additional errors, are difficult to detect, and occur between layers of data in the database system. the data protection system can perform corrections of the error data by rebuilding database data or removing the corrupted data.
Inventor(s): Christian Diaconu of Kirkland WA (US) for snowflake inc., Chen Luo of San Mateo CA (US) for snowflake inc., Corbin McElhanney of San Mateo CA (US) for snowflake inc., Wumengjian Zhu of Cupertino CA (US) for snowflake inc.
IPC Code(s): G06F16/21, G06F16/2455, G06F16/2457
CPC Code(s): G06F16/213
Abstract: the subject technology receives a request to perform a table scan operation of a table. the subject technology determines that the table is being accessed for an initial time. the subject technology populates a columnar cache with data of the table provided by the table scan operation. the subject technology determines a set of schema versions of a set of rows from the data of the table. the subject technology determines schema information of each schema from the set of schema versions. the subject technology generates a result rowset and a second rowset comprising a union of columns that have appeared at least once in each row. the subject technology performs deserialization of rows from the result rowset and the second rowset. the subject technology provides the rows from the result rowset and the second rowset to write to a file in a particular format.
Inventor(s): Elliott Brossard of Kirkland WA (US) for snowflake inc., Chong Han of Bellevue WA (US) for snowflake inc., Igor Zinkovsky of Redmond WA (US) for snowflake inc.
IPC Code(s): G06F16/22, G06F16/248, G06F16/25, G06F16/27
CPC Code(s): G06F16/2291
Abstract: a method to process udfs includes performing, by at least one hardware processor of a database system, a resolution of application components to determine a plurality of resolved components of an application and a plurality of data types corresponding to the plurality of resolved components. the method includes instantiating a plurality of udf clients. the plurality of udf clients are associated with the plurality of data types. the method includes detecting a received database query specifies a data type of the plurality of data types. the method includes executing the received database query at a udf client of the plurality of udf clients.
20250068622. ERROR TABLES_simplified_abstract_(snowflake inc.)
Inventor(s): Abdullah Al Mahmood of Bothell WA (US) for snowflake inc., Tyler Jones of Redwood City CA (US) for snowflake inc., Xin Huang of Bellevue WA (US) for snowflake inc., Ganeshan Ramachandran Iyer of Redmond WA (US) for snowflake inc., Jiaxing Liang of Bellevue WA (US) for snowflake inc., Daniel Mills of Seattle WA (US) for snowflake inc., Subramanian Muralidhar of Mercer Island WA (US) for snowflake inc., Daniel E. Sotolongo of Seattle WA (US) for snowflake inc.
IPC Code(s): G06F16/23, G06F11/14, G06F16/22
CPC Code(s): G06F16/2365
Abstract: techniques for creating and using error tables to track errors associated with a base table are described. a command to perform an operation on a base table stored in a network-based data system can be received and executed, causing at least one error. at least one error record corresponding to the at least one error can be inputted into an error table, which is nested with the base table. contextual information can be added to the at least one error record.
Inventor(s): Hossein Ahmandi of Seattle WA (US) for snowflake inc., Jayanta Das of Bellevue WA (US) for snowflake inc., Joshua Klahr of San Carlos CA (US) for snowflake inc., Boyung Lee of Kirkland WA (US) for snowflake inc., Wenye Li of Bellevue WA (US) for snowflake inc., Abdul Q. Munir of Bozeman MT (US) for snowflake inc., Yi Pan of San Jose CA (US) for snowflake inc.
IPC Code(s): G06F16/2453, G06F16/2455, G06F16/27
CPC Code(s): G06F16/24537
Abstract: a method includes generating, by at least one hardware processor, a query plan of a query. the query includes a join operation between first time series data and second time series data. at least one node in the query plan corresponding to the join operation is modified to generate a modified query plan. the modifying is based on replacing the at least one node with a new node including a union operation. the union operation is based on the first time series data and the second time series data. execution of the query is scheduled based on the modified query plan.
Inventor(s): Mihir Dharamshi of Redmond WA (US) for snowflake inc., Cristian Diaconu of Kirkland WA (US) for snowflake inc., Chen Luo of San Mateo CA (US) for snowflake inc., Andrew McCormick of San Francisco CA (US) for snowflake inc., Corbin McEihanney of San Mateo CA (US) for snowflake inc., Joshua Slocum of Austin TX (US) for snowflake inc., Wumengjian Zhu of Cupertino CA (US) for snowflake inc.
IPC Code(s): G06F16/25, G06F16/11, G06F16/172, G06F16/23
CPC Code(s): G06F16/254
Abstract: the subject technology receives, by an execution node, blob metadata from a key-value store, the blob metadata including information related to a set of blob files. the subject technology determines, by the execution node using the blob metadata, whether a copy of each of the set of blob files is stored in a local cache of the execution node. the subject technology transforms at least one blob file, retrieved from a blob store, to a second file in a column file format, the at least one blob file being in a first format that is different than the column file format, the transforming comprising at least converting a particular snapshot file from the at least one blob file to a particular set of rowsets and writing the set of rowsets into the second file in the column file format. the subject technology stores the second file in the local cache.
20250068676. SYNCHRONIZING FILE-CATALOG TABLE WITH FILE STAGE_simplified_abstract_(snowflake inc.)
Inventor(s): Polita Paulus of Kirkland WA (US) for snowflake inc., Aravind Ramarathinam of Sammamish WA (US) for snowflake inc., Saurin Shah of Kirkland WA (US) for snowflake inc., Sukruth Komarla Sukumar of Bellevue WA (US) for snowflake inc.
IPC Code(s): G06F16/901, G06F16/22, G06F16/2455, G06F16/908, G06F16/955
CPC Code(s): G06F16/9017
Abstract: disclosed herein are embodiments of systems and methods for synchronizing file-catalog table with a file stage. in an embodiment, a data platform receives a notification of a modification to one or more files in a file stage. the file stage includes data storage having a storage location. the data platform updates, based on receiving the notification of the modification, a first file-catalog table for the file stage based on the modification. the first file-catalog table includes a row for each file in the file stage, as well as a column for each of one or more metadata properties of the one or more files in the file stage.
