Snowflake Inc. patent applications on October 3rd, 2024

Patent Applications by Snowflake Inc. on October 3rd, 2024

Snowflake Inc.: 10 patent applications

Snowflake Inc. has applied for patents in the areas of G06F16/2455 (4), G06F16/23 (4), G06F16/22 (4), G06F21/53 (2), G06F16/25 (2) G06F11/1469 (1), G06F16/2448 (1), G06F16/24542 (1), G06F16/24552 (1), G06F16/24557 (1)

With keywords such as: data, query, account, execution, cache, based, updated, methods, provider, and systems in patent application abstracts.

Patent Applications by Snowflake Inc.

20240330124. AUTOMATED FAILSAFE DATA RECOVERY_simplified_abstract_(snowflake inc.)

Inventor(s): Yi Fang of Kirkland WA (US) for snowflake inc., Kedar Nitin Shah of Sammamish WA (US) for snowflake inc., Yantao Song of Sammamish WA (US) for snowflake inc.

IPC Code(s): G06F11/14, G06F16/22

CPC Code(s): G06F11/1469

Abstract: provided herein are systems and methods for configuring data recovery. a method includes decoding, by at least one hardware processor, a request to recover historical table data. the request is received from an account of a data provider. the historical table data includes a plurality of partition files. each of the plurality of partition files includes a deleted file designation. based on the request, a recovery process of the plurality of partition files is performed to obtain recovered partition files. a schema associated with the historical table data is retrieved. metadata corresponding to the retrieved schema is generated. the metadata is associated with the recovered partition files to recover the historical table data.

20240330283. EXTENDED TELEMETRY METRIC DATA TYPES_simplified_abstract_(snowflake inc.)

Inventor(s): Qinye Li of Redwood City CA (US) for snowflake inc., Steven Parkes of Palo Alto CA (US) for snowflake inc., Xie Xu of Seattle WA (US) for snowflake inc.

IPC Code(s): G06F16/242, G06F16/23, G06F16/25

CPC Code(s): G06F16/2448

Abstract: provided herein are systems and methods for configuring extended telemetry metric data types. a system includes at least one hardware processor coupled to a memory and configured to detect an api call at an execution node of a database system. metric data emitted by a telemetry api corresponding to the api call is collected. the metric data is converted from a first data format associated with the telemetry api to a second data format to generate formatted metric data. the second data format is a native format to an event table of the database system. telemetry data based on the formatted metric data is ingested into the event table.

20240330287. QUERY PLAN CACHE SHADOW MODES_simplified_abstract_(snowflake inc.)

Inventor(s): Prashant Gaharwar of Fremont CA (US) for snowflake inc., Vineet Garg of San Jose CA (US) for snowflake inc., Nicola Dan Onose of San Jose CA (US) for snowflake inc., Jiaqi Yan of Menlo Park CA (US) for snowflake inc.

IPC Code(s): G06F16/2453

CPC Code(s): G06F16/24542

Abstract: the subject technology receives a query. the subject technology performs a lookup operation on a shadow cache. the subject technology performs a validation process on the particular query plan for determining a cache hit on the shadow cache. the subject technology performs a program building process to update the particular query plan with additional information for executing the particular query plan. the subject technology performs a compilation process to compile an updated program of the updated particular query plan. the subject technology determines that the updated particular query plan is cacheable based at least in part on the compilation process. the subject technology registers the updated particular query plan as a new entry in the shadow cache. the subject technology sends the updated program to an execution node for executing the updated particular query plan.

20240330296. ACTIVE INVALIDATION OF METADATA CACHE ENTRIES_simplified_abstract_(snowflake inc.)

Inventor(s): Benoit Dageville of San Mateo CA (US) for snowflake inc., Lyuping Du of Issaquah WA (US) for snowflake inc., Martin Hentschel of Berlin (DE) for snowflake inc., Elkhan Mammedov of Berlin (DE) for snowflake inc., Lukas Moll of Berlin (DE) for snowflake inc., Vikram Wakade of Sammamish WA (US) for snowflake inc.

IPC Code(s): G06F16/2455, G06F16/23

CPC Code(s): G06F16/24552

Abstract: techniques for active invalidation of cache entries are described. a first timestamp and a second timestamp are stored by a compute instance, the first timestamp corresponding to an initial time the computing instance read from a version update log in a database and the second timestamp corresponding to a last time the computing instance read from the version update log in the database. the compute instance can read records from the version update log that are associated with version timestamps greater than the second timestamp. the compute instance can invalidate a first set of cache entries with older versions stored in a cache based on reading the records, retaining a second set of cache entries, and then execute a query using the second set of cache entries.

20240330300. INDEXED GEOSPATIAL SEARCH_simplified_abstract_(snowflake inc.)

Inventor(s): Matthias Carl Adams of Berlin (DE) for snowflake inc., Mahmud Allahverdiyev of Berlin (DE) for snowflake inc., Ismail Oukid of Berlin (DE) for snowflake inc., Peter Popov of Berlin (DE) for snowflake inc., Alejandro Salinger of Berlin (DE) for snowflake inc.

IPC Code(s): G06F16/2455, G06F16/22, G06F16/28, G06F16/9035, G06F17/18

CPC Code(s): G06F16/24557

Abstract: a method to perform an indexed geospatial search includes retrieving, by at least one hardware processor, a query specifying a geography data column and a constant geography object. a first plurality of hash functions of a first set of cells covering a surface associated with the geography data column is determined. a search index of a database including the geography data column is updated based on the first plurality of hash functions to obtain an updated search index. the query is executed on a reduced scan set of the database. the reduced scan set is based on the updated search index.

20240330319. RESOURCE MANAGEMENT SYSTEMS AND METHODS_simplified_abstract_(snowflake inc.)

Inventor(s): Benoit Dageville of Foster City CA (US) for snowflake inc., Thierry j:;ruanes of San Mateo CA (US) for snowflake inc., Marcin Zukowski of San Mateo CA (US) for snowflake inc.

IPC Code(s): G06F16/27, A61F5/56, G06F9/48, G06F9/50, G06F16/14, G06F16/182, G06F16/21, G06F16/22, G06F16/23, G06F16/2453, G06F16/2455, G06F16/2458, G06F16/25, G06F16/28, G06F16/951, G06F16/9535, G06F16/9538, H04L67/1095, H04L67/1097, H04L67/568

CPC Code(s): G06F16/273

Abstract: example resource management systems and methods are described. in one implementation, a system includes a memory and a processing device operatively coupled to the memory. the processing device is to receive a query referencing database data stored in a storage platform, determine a task associated with processing the received query, and create an execution node comprising cache resources and processing resources. furthermore, a size of the cache resources of the execution node is determined upon creation of the execution node, based at least in part on the task, and processing resources of the execution node are determined upon creation of the execution node, based at least in part on the task. the execution node is included within a plurality of execution nodes to process the task associated with processing the received query.

20240330412. COLUMN CLASSIFICATION MODEL_simplified_abstract_(snowflake inc.)

Inventor(s): Zachary Charles Frazier of Seattle WA (US) for snowflake inc., Stephen Joe Jonany of Seattle WA (US) for snowflake inc., Yimeng Li of Bellevue WA (US) for snowflake inc., Nabajyoti Patowary of Seattle WA (US) for snowflake inc., Chao Tan of Issaquah WA (US) for snowflake inc., Yunqiao Zhang of Bellevue WA (US) for snowflake inc.

IPC Code(s): G06F18/241, G06F16/22

CPC Code(s): G06F18/241

Abstract: systems and methods for classifying columns using a model are provided. the systems and methods access a table associated with a column of features and retrieve a list of categories each associated with a different scoring model. the systems and methods, for each category in the list of categories, apply a respective scoring model to the features of the column to generate a respective set of confidence values indicating a likelihood that the column belongs to a respective one of the categories. the systems and methods process the respective sets of confidence values to select a target category from the list of categories and associate the selected target category with the column.

20240330430. PROVIDING ACCESS CONTROL FOR POLICIES_simplified_abstract_(snowflake inc.)

Inventor(s): Srilakshmi Chintala of Seattle WA (US) for snowflake inc., Albert L. Hu of Seattle WA (US) for snowflake inc., Ziliang Zhang of San Mateo CA (US) for snowflake inc., Igor Zinkovsky of Redmond WA (US) for snowflake inc.

IPC Code(s): G06F21/44, G06F21/53

CPC Code(s): G06F21/44

Abstract: methods, systems, and computer programs are presented for a policy to enable customers to create and apply allowed items and restricted items provided by third-party managers. user code is received by a cloud data platform, the code for performing an operation. the cloud data platform receives a policy including allowed items and restricted items. the cloud data platform compares the allowed and restricted items to a specification, and determines a difference based on the comparison. the cloud data platform determines whether to permit the operation based at least in part on the differences.

20240330437. LOGGING FROM USER-DEFINED FUNCTIONS_simplified_abstract_(snowflake inc.)

Inventor(s): Thierry Cruanes of San Mateo CA (US) for snowflake inc., Ganeshan Ramachandran Iyer of Redmond WA (US) for snowflake inc., Isaac Kunen of Seattle WA (US) for snowflake inc.

IPC Code(s): G06F21/54, G06F16/2455, G06F21/53, G06F21/60

CPC Code(s): G06F21/54

Abstract: the logging techniques described herein can enable using logging tools without having to use different methods for sandbox implementations and push out the log data to storage without problems. the log data is treated as sensitive data and is protected according to the defined security policies. further, the results may be compressed and encrypted.

20240333718. EVENTS ACCOUNT FOR NATIVE APP EVENT SHARING_simplified_abstract_(snowflake inc.)

Inventor(s): Damien Carru of New York NY (US) for snowflake inc., Pui Kei Johnston Chu of Unionville (CA) for snowflake inc., Unmesh Jagtap of San Mateo CA (US) for snowflake inc., Xiaodi Ke of Markham (CA) for snowflake inc., Subramanian Muralidhar of Mercer Island WA (US) for snowflake inc., James Pan of Oakville (CA) for snowflake inc.

IPC Code(s): H04L9/40, G06F11/07, G06F16/23, H04L67/125, H04L67/30

CPC Code(s): H04L63/102

Abstract: embodiments of the present disclosure provide a region-specific events account that is used as a central place to store the events shared by consumers of shared applications in that region. for each of a set of provider accounts in a first region, a global account object corresponding to the provider account is replicated to a second region to establish a replicated global account object in the second region. an account data persistence object (dpo) of a first provider account of the set of provider accounts is modified to designate the first provider account as an events account. the events account is a central location within the second region where execution information generated by execution of applications shared with consumer accounts in the second region is stored. the replicated global account object corresponding to the first provider account is updated to designate the first provider account as the events account.

Snowflake Inc. patent applications on October 3rd, 2024