Patents Assigned to SNOWFLAKE INC.
  • Patent number: 12032588
    Abstract: A method includes creating, by a first provider, a first listing referencing first shared data and comprising first access controls, wherein access to the first shared data by a second provider is filtered based on the first access controls, creating, by the second provider, a second listing referencing second shared data and the first shared data filtered based on the first access controls, and adding the second listing to a catalog in a data exchange, the catalog comprising metadata describing the second shared data.
    Type: Grant
    Filed: January 27, 2023
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventors: Pui Kei Johnston Chu, Benoit Dageville, Matthew J. Glickman, Christian Kleinerman, Prasanna Krishnan, Justin Langseth
  • Patent number: 12032995
    Abstract: A method includes decoding, by at least one hardware processor, an enqueue request received from a data process of a database system. The enqueue request includes a task. The task is enqueued in an in-memory task queue. An enqueue acknowledgment is encoded for transmission to the data process responsive to the enqueue request. The task is persisted in a storage location associated with the in-memory task queue. Initiate a lease of the task to a worker node in response to a lease request received from the worker node. A dequeue request is received from the worker node where the dequeue request indicates completion of the task by the worker node. The task is dequeued from the in-memory task queue based on the dequeue request.
    Type: Grant
    Filed: July 28, 2023
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventors: Gabriel Kliot, Ruji Xie, Subramanian Muralidhar, William Waddington
  • Patent number: 12032595
    Abstract: Techniques for database replication for a remote deployment include a method performed by a data platform executing instructions on at least one hardware processor. The method includes detecting receipt of a database replication request associated with a data consumer. The database replication request is requesting availability of an instance of a primary deployment database at a remote deployment of a data platform. In response to detecting the receipt of the database replication request, an account of a data provider at the remote deployment of the data platform is provisioned with a set of replication-preparation objects associated with the primary deployment database. A database refresh operation is invoked, causing database data be pushed from the primary deployment database to a database shell in the account of the data provider at the remote deployment, to create the instance of the primary deployment database.
    Type: Grant
    Filed: March 29, 2023
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventors: Pui Kei Johnston Chu, Benoit Dageville, Shreyas Narendra Desai, Sameer Deshpande, Subramanian Muralidhar, Di Wu
  • Patent number: 12032947
    Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.
    Type: Grant
    Filed: July 18, 2023
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventors: Damien Carru, Benoit Dageville, Unmesh Jagtap, Subramanian Muralidhar, Jan Michael Timmerman
  • Patent number: 12032919
    Abstract: Examples provide a large language model confidence scoring post-calibration based on a combination of temperature scaling, softmax denominator top-k probabilities selection, and polynomial regression. A secure machine learning system receives results generated by a machine learning (ML) model, the results including at least one confidence score. The secure ML system identifies at least one challenge in accuracy of the results generated by the ML model configured to perform document processing and understanding.
    Type: Grant
    Filed: August 16, 2023
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventor: Andrzej Szwabe
  • Patent number: 12032685
    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.
    Type: Grant
    Filed: September 29, 2022
    Date of Patent: July 9, 2024
    Assignee: Snowflake Inc.
    Inventors: Thierry Cruanes, Ganeshan Ramachandran Iyer, Isaac Kunen
  • Patent number: 12026221
    Abstract: Using an attributes model of a time series forecasting model, determine a set of features based on time series data, the set of features including periodic components. The time series data may be divided into a set of segments. For each segment of the set of segments, a weight may be assigned using an age of the segment, resulting in a set of weighted segments of time series data. Using a trend detection model of the time series forecasting model, trend data from the set of weighted segments of time series data may be determined. A time series forecast may be generated by combining the set of features and the trend data.
    Type: Grant
    Filed: February 22, 2023
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Michel Adar, Boxin Jiang, Qiming Jiang, John Reumann, Boyu Wang, Jiaxun Wu
  • Patent number: 12026145
    Abstract: Disclosed herein are systems and methods for providing percentile-based alerts from historical event-occurrence data. An embodiment of a method includes identifying a baseline result of an aggregation operation performed with respect to a detection set of attributes of event records. Each baseline result corresponds to a baseline set of one or more event records from a baseline time period within a baseline time window. The method includes determining a subject result of the aggregation operation performed with respect to the detection set of attributes of a subject set of the event records corresponding to a subject time period. The method includes determining, based on the baseline result and the subject result, whether the subject result indicates an alert condition for the detection set for the subject time period, and if so then outputting one or more alerts.
    Type: Grant
    Filed: May 31, 2022
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Andrey Fedorov, Maria Polyakova, Omer Singer
  • Patent number: 12026140
    Abstract: Methods, systems, and computer programs are presented for providing performance metrics in an online performance analysis system employing customer production workloads. A plurality of metric source data is received from a cloud data platform. A workload is identified as a stable workload candidate based at least in part on the plurality of metric source data. The cloud data platform generates a performance index based on the workload being identified as a stable workload candidate. The performance index is tracked over a period of time to identify changes in workload.
    Type: Grant
    Filed: February 21, 2023
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Vlad Bunescu, Joshua Klahr, Louis Magarshack, Shiyu Qu, Zerui Wei, Jiaqi Yan
  • Patent number: 12026153
    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.
    Type: Grant
    Filed: March 7, 2023
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Torsten Grabs, Istvan Cseri, Benoit Dageville
  • Patent number: 12026159
    Abstract: Queries executed against a materialized view can execute up to orders of magnitude faster than equivalent queries on a source (or base) table. However, although a query can reference a materialized view directly, a user (e.g., query author) may not know about a relevant materialized view. Moreover, if a source table has multiple materialized views generated, the user may not know which materialized view to reference in the query. Thus, embodiments of the present disclosure provide techniques for automatically rewriting queries directed to a source table to utilize existing materialized views.
    Type: Grant
    Filed: November 28, 2022
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Shrainik Jain, Allison Waingold Lee, Boyung Lee, Prasanna Rajaperumal, Jiaqi Yan, Yongsik Yoon
  • Patent number: 12026160
    Abstract: The subject technology receives a query, the query including a set of statements for performing the query. The subject technology populates a compilation context based at least in part the query. The subject technology invokes a compiler to perform a compilation process based on the compilation context. The subject technology performs a lookup operation on a stored plan cache for an exact match based on information from the compilation context. The subject technology, in response to determining an exact match, determines whether the particular query plan requires re-compilation based on a data dependent optimization. The subject technology determines whether a plan cache entry corresponding to the particular query plan includes a data property constraint. The subject technology determines whether the data property constraint still holds based on a set of data properties.
    Type: Grant
    Filed: April 14, 2023
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Thierry Cruanes, Xuelai Cui, Sangyong Hwang, Allison Waingold Lee, Boyung Lee, Nicola Dan Onose, William Waddington, Jiaqi Yan, Li Yan, Yongsik Yoon
  • Patent number: 12026129
    Abstract: Systems and methods for caching file system collections atomically. The systems and methods perform operations comprising: receiving a request to access a collection of data comprising a plurality of files stored on a storage device; in response to receiving the request, transferring the collection of data from the storage device to a first subfolder in a cache associated with the storage device; generating a lock file comprising a reference to the first subfolder in the cache; and atomically controlling access to the collection of data in the first subfolder and removal of the collection of data in the first subfolder from the cache via the lock file.
    Type: Grant
    Filed: March 30, 2022
    Date of Patent: July 2, 2024
    Assignee: Snowflake Inc.
    Inventors: Selcuk Aya, Ju-yi Kuo, Jonathan Lee Leang, Nitya Kumar Sharma, Igor Zinkovsky
  • Patent number: 12019779
    Abstract: A hardware database privacy device is communicatively coupled to a private database system. The hardware database privacy device receives a request from a client device to perform a query of the private database system and identifies a level of differential privacy corresponding to the request. The identified level of differential privacy includes privacy parameters (?,?) indicating the degree of information released about the private database system. The hardware database privacy device identifies a set of operations to be performed on the set of data that corresponds to the requested query. After the set of data is accessed, the set of operations is modified based on the identified level of differential privacy such that a performance of the modified set of operations produces a result set that is (?,?)-differentially private.
    Type: Grant
    Filed: July 29, 2021
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Ishaan Nerurkar, Christopher Hockenbrocht, Liam Damewood, Mihai Maruseac, Alexander Rozenshteyn
  • Patent number: 12019632
    Abstract: Embodiments of the present disclosure may provide a dynamic query execution model with fault tolerance and failure recovery techniques. Embodiments of the present disclosure may utilize checkpoints to map processed output files to their corresponding input files. Therefore, if an error occurs in processing one or more files, the system may only need to reschedule processing of selected file(s).
    Type: Grant
    Filed: September 7, 2022
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Thierry Cruanes, Igor Demura, Varun Ganesh, Prasanna Rajaperumal, Libo Wang, Jiaqi Yan
  • Patent number: 12021877
    Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes receiving a request for access to a first listing of a data exchange, each listing of the data exchange comprising version metadata. The method further includes, in response to the request, accessing a first version of a data set referenced by the first listing, wherein the first version of the data set comprises a first structure defined by first version metadata, a second listing of the data exchange references a second version of the data set, the second version of the data set comprising a second structure defined by second version metadata, and the second structure is incompatible with the first structure.
    Type: Grant
    Filed: September 18, 2023
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Pui Kei Johnston Chu, Benoit Dageville, Matthew J. Glickman, Christian Kleinerman, Prasanna Krishnan, Justin Langseth
  • Patent number: 12019735
    Abstract: A method for tracing function execution includes instantiating, by at least one hardware processor of a computing node, a user-defined function (UDF) server associated with a plurality of configurations. A plurality of child processes of the UDF server are instantiated using the plurality of configurations. A filtering process is configured at an operating system (OS) kernel of the computing node using a child process of the plurality of child processes. The filtering process includes a set of system call categories and a corresponding set of filtering policies. A system call received at the OS kernel and associated with a system call category of the set of system call categories is detected to violate a corresponding filtering policy of the set of filtering policies. A tracing event of the system call is initiated based on the detecting.
    Type: Grant
    Filed: July 20, 2023
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Brandon S. Baker, Derek Denny-Brown, Mark M. Manning, Andong Zhan
  • Patent number: 12022005
    Abstract: Signing source code using a vault device is described. An example method can include receiving, with a client device, source code that is to be committed to a repository. The method further can include sending, with a processing device to a vault device, a request to sign the source code. The method can further include receiving, from the vault device, a signed commit of the source code. In addition, the method can include pushing the source code and the signed commit to the repository, wherein the repository commits the source code and signed commit.
    Type: Grant
    Filed: January 27, 2023
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Mark M. Manning, Nathan A. Sfard
  • Patent number: 12020128
    Abstract: A method includes installing, in a consumer database account, a shared-instance database that includes a shared instance of a provider-account database that resides in a provider database account. The shared-instance database includes a first schema that includes provider-account training data, provider-account scoring data, a training function, and a scoring function. The method also includes invoking the training function from the consumer database account, which results in creation in the consumer database account of a second schema that includes a machine-learning-model instance of a machine learning model, and which also results in training the machine-learning model instance with at least the provider-account training data. Additionally, the method includes generating consumer-account scoring data by inputting, into the trained machine-learning-model instance, consumer-account input data that is stored in the consumer database account.
    Type: Grant
    Filed: January 31, 2023
    Date of Patent: June 25, 2024
    Assignee: Snowflake Inc.
    Inventors: Orestis Kostakis, Justin Langseth
  • Patent number: 12013876
    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: provide a plurality of execution nodes, each execution node comprising a cache and a processor, each execution node communicatively coupled to a storage platform; determine at least one task associated with processing a received query referencing database data stored in the storage platform; and create a new execution node within the plurality of execution nodes to process the at least one task associated with processing the received query.
    Type: Grant
    Filed: July 26, 2022
    Date of Patent: June 18, 2024
    Assignee: Snowflake Inc.
    Inventors: Benoit Dageville, Thierry Cruanes, Marcin Zukowski