公开(公告)号：US20240176775A1

公开(公告)日：2024-05-30

申请号：US18194085

申请日：2023-03-31

Applicant: Snowflake Inc.

Inventor： Trevor Clinkenbeard

IPC: G06F16/23 ,  G06F16/27

CPC classification number: G06F16/2379 ,  G06F16/27

Abstract: The subject technology receives, by a proxy interface, the request to determine the read version of the transaction. The subject technology determines, based on the request, that the transaction is associated with the tag included in the request. The subject technology generates a sequence number for the request. The subject technology places the request in a queue associated with the tag based on the sequence number, the queue including a set of requests to determine a particular read version of a particular transaction. The subject technology determines, using a token bucket, that the request in the queue should be throttled based on information related to a quota for the tag stored in a distributed database key store.

公开(公告)号：US11995126B2

公开(公告)日：2024-05-28

申请号：US18104271

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Khalid Zaman Bijon ,  Thierry Cruanes ,  Simon Holm Jensen ,  Allison Waingold Lee ,  Daniel N. Meredith ,  Subramanian Muralidhar ,  David Schultz ,  Zixi Zhang

IPC: G06F16/903

CPC classification number: G06F16/90335

Abstract: A system for enforcing projection constraints on data values stored in specified variables of a shared dataset of a cloud data platform. A request is received from a first account of the cloud data platform that identifies a first operation to be performed on the shared dataset. A first set of data, including data accessed from a first variable, is accessed from the shared dataset to use in performing the first operation. A projection constraint policy attached to the first variable of the shared dataset is determined, and the projection constraint policy is further determined to be enforced based on the request. Based on the first set of data and the first operation, an output to the first request is generated.

公开(公告)号：US20240168958A1

公开(公告)日：2024-05-23

申请号：US18425312

申请日：2024-01-29

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/242 ,  G06F16/27 ,  G06F21/62

CPC classification number: G06F16/24565 ,  G06F16/2443 ,  G06F16/27 ,  G06F21/6227

Abstract: Disclosed herein are systems and methods for query processing with restrictions in a database clean room. In an embodiment, a system receives a query directed to a combination of a first source dataset from a first database account of a distributed database and a second source dataset from a second database account of the distributed database. The system generates an approved statements table that contains database statement language that can be executed against the combination of the first and second source datasets. Based on determining that the approved statements table includes the query, the system executes the query to produce results data, and stores the results data in the first database account.

公开(公告)号：US20240168950A1

公开(公告)日：2024-05-23

申请号：US18329915

申请日：2023-06-06

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Kavinder S. Dhaliwal ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F16/2455

CPC classification number: G06F16/24542 ,  G06F16/24564

Abstract: Techniques for reducing query compilation time are described. Dynamic compilation behavior based on query properties can reduce time and computational costs. For example, the techniques can identify stages and rewrite rules to skip or modify in the compilation process based on, among other things, properties of the parse tree and the query plan.

公开(公告)号：US20240168938A1

公开(公告)日：2024-05-23

申请号：US18427786

申请日：2024-01-30

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

IPC: G06F16/23 ,  G06F9/46 ,  G06F16/18 ,  G06F16/245 ,  G06F16/27

CPC classification number: G06F16/2358 ,  G06F16/1865 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/245 ,  G06F16/278 ,  G06F9/466

Abstract: A system includes one or more processors configured as a change tracking manager, and data storage containing instructions executable by the one or more processors. A table data component of the change tracking manager stores table data for a database in a plurality of partitions. A transaction data component of the change tracking manager generates a change tracking entry based on executing a transaction on the table data. The change tracking entry includes information on at least one modification made to a first table version storing the table data. A change tracking component of the change tracking manager generates a change tracking stream associated with the at least one modification. The change tracking component updates a second table version to include the change tracking stream. The second table version includes modified table data based on completing execution of the transaction on the table data in the first table version.

公开(公告)号：US20240168834A1

公开(公告)日：2024-05-23

申请号：US18429367

申请日：2024-01-31

Applicant: Snowflake Inc.

Inventor： Isaac Kunen ,  Srinath Shankar ,  Zihan Li ,  Khushboo Bhatia ,  Edward Ma

IPC: G06F9/54 ,  G06F16/2455 ,  G06F16/28 ,  G06F21/53

CPC classification number: G06F9/547 ,  G06F16/2455 ,  G06F16/289 ,  G06F21/53

Abstract: A database system configured to manage and execute stored procedures within a secure sandbox process. The system receives a response to a database query and, through an Application Programming Interface (API) executing within the sandbox process, converts the response into a remote procedure call. The sandbox process is modified to restrict communication with external networks while enabling communication with a designated execution node, which facilitates interaction between the stored procedure and database system components. The stored procedure, executing within the confines of the sandbox process, directs the API to communicate with the execution node. The execution node, in turn, submits the database query to the database system component.

公开(公告)号：US11989164B2

公开(公告)日：2024-05-21

申请号：US18051447

申请日：2022-10-31

Applicant: Snowflake Inc.

Inventor： Durga Mahesh Arikatla ,  Robert K. Chao ,  Li He ,  Joyce Lam ,  Xinyue Liu ,  Subramanian Muralidhar ,  Vishnu Dutt Paladugu ,  Shakhina Pulatova ,  Stephanie Stillman ,  Xin Wen ,  Di Wu ,  Ziqi Xu

IPC: G06F16/21

CPC classification number: G06F16/213

Abstract: A data dictionary generation system automatically populates and updates a data dictionary for listings offering shared data. A data dictionary includes metadata describing the shared data, including the individual objects, such as the individual tables, schemas, views, and functions. The shared data and each individual data object may be described in the data dictionary by a set of data fields that corresponds to the shared dataset or the object type of the individual object. The data dictionary can be presented to data consumers along with the description of the listing to provide data consumers with a comprehensive description of the shared data provided by a listing, including a high-level summary of the shared data and description of each individual object included in the shared data. The data dictionary allows data consumers to understand the contents of the shared data and how to use the shared data.

公开(公告)号：US11973763B1

公开(公告)日：2024-04-30

申请号：US18127576

申请日：2023-03-28

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Unmesh Jagtap ,  Xiaodi Ke ,  Subramanian Muralidhar ,  James Pan

IPC: H04L9/40 ,  G06F11/07 ,  G06F16/23 ,  H04L67/125 ,  H04L67/30

CPC classification number: H04L63/102 ,  G06F11/079 ,  G06F16/235 ,  H04L67/125 ,  H04L67/30

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. Use of such an account helps reduce the operational burden of a provider of the applications as they do not need to determine which accounts have shared events for each different consumer. The provider only needs to login to the events account which is in the same region as the consumer and can query all shared events from different applications that are being used in that region. Also, since the provider can designate an events account in each region, the shared events could be directly ingested into the events account without traveling to a different region.

公开(公告)号：US11971783B1

公开(公告)日：2024-04-30

申请号：US18340528

申请日：2023-06-23

Applicant: Snowflake Inc.

Inventor： Vlad Bunescu ,  Yan Huang ,  Jaeha Lee ,  Shiyu Qu ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F11/34 ,  G06F16/21

CPC classification number: G06F11/1433 ,  G06F11/3414 ,  G06F16/213 ,  G06F2201/80

Abstract: A method includes decoding, by at least one hardware processor, a notification of a changed database code of a database. A query is executed responsive to the notification. The query indicates a data processing command and a data object in the database. A regression in the changed database code is detected based on multiple regression testing operations applied to the data processing command and the data object. Analysis of the regression is performed to detect a rollout parameter of a plurality of rollout parameters as a root cause of the regression. The plurality of rollout parameters are associated with the changed database code. A determination is made on whether to perform a mitigation action for the regression based on the rollout parameter.

公开(公告)号：US20240135477A1

公开(公告)日：2024-04-25

申请号：US18047909

申请日：2022-10-18

Applicant: Snowflake Inc.

Inventor： Edward J. Fron ,  Nicholas A. Goodman ,  Kristl Smith Tyler

IPC: G06Q50/20 ,  G06F21/54

CPC classification number: G06Q50/205 ,  G06F21/54

Abstract: Provided herein are systems and methods for automated, secure, and credential-less evaluation (e.g., grading) of data processing task results (e.g., student/learner data processing lab result or assignment completion result) in a cloud environment using a learning management system (LMS). For example, a method includes detecting verification request code received from an account of a data consumer. The verification request code includes a call to an external function and a query statement associated with a task result obtained after completion of a data processing task. The verification request code is revised with metadata to obtain revised verification request code. The call to the external function is executed to cause an evaluation of the task result. A notification of a result of the evaluation is communicated to the account of the data consumer.