公开(公告)号：US20230082040A1

公开(公告)日：2023-03-16

申请号：US18051075

申请日：2022-10-31

Applicant: Snowflake Inc.

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

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

Abstract: Disclosed are systems, methods, and non-transitory computer-readable media for receiving a remote procedure call from a stored procedure executing within a sandbox process. A database system converts the remote procedure call into a database query, and a sandbox process separates the stored procedure from the other services and processes the database query on a database.

公开(公告)号：US11436245B1

公开(公告)日：2022-09-06

申请号：US17453756

申请日：2021-11-05

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/2453

Abstract: Provided herein are systems and methods for query result data processing, including parallel fetching and processing of query result data. A system includes at least one hardware processor coupled to memory and configured to execute a query received from a first computing device, to obtain query result data. The at least one hardware processor is further configured to store the query result data at a storage location. The at least one hardware processor is further configured to generate query result information associated with the query result data. The query result information includes location information associated with the storage location and schema information associated with the query result data. The at least one hardware processor is further configured to encode the query result information for transmission to the first computing device.

公开(公告)号：US20220222144A1

公开(公告)日：2022-07-14

申请号：US17647255

申请日：2022-01-06

Applicant: Snowflake Inc.

Inventor： Bing Li ,  Zihan Li ,  Edward Ma ,  Mingli Rui ,  Srinath Shankar

IPC: G06F11/14 ,  G06F9/50 ,  G06F16/28 ,  G06F16/215

Abstract: A shared database platform can interface with a cluster computing platform over a network through a database connector and one or more cluster connectors. The data transferred over the network can include telemetry metadata that can be distributed to execution nodes of the cluster computing platform for generation and transmission of cluster data to the shared database platform.

公开(公告)号：US11249850B1

公开(公告)日：2022-02-15

申请号：US17399847

申请日：2021-08-11

Applicant: Snowflake Inc.

Inventor： Bing Li ,  Zihan Li ,  Edward Ma ,  Mingli Rui ,  Srinath Shankar

IPC: G06F16/21 ,  G06F11/14 ,  G06F16/215 ,  G06F9/50 ,  G06F16/28

Abstract: A shared database platform can interface with a cluster computing platform over a network through a database connector and one or more cluster connectors. The data transferred over the network can include telemetry metadata that can be distributed to execution nodes of the cluster computing platform for generation and transmission of cluster data to the shared database platform.

公开(公告)号：US20210374235A1

公开(公告)日：2021-12-02

申请号：US17352005

申请日：2021-06-18

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Derek Denny-Brown ,  Isaac Kunen ,  Soumitr Rajiv Pandey ,  Jacob Salassi ,  Srinath Shankar ,  Haowei Yu ,  Andong Zhan

IPC: G06F21/53 ,  G06F21/78 ,  G06F16/22 ,  G06F21/62 ,  H04L29/06 ,  G06F21/54

Abstract: The subject technology receives, in a computing process, a user defined function, the user defined function including code related to at least one operation to be performed. The subject technology determines by a security manager whether performing the at least one operation is permitted, the security manager determines restrictions, based at least in part on a security policy. The subject technology performs the at least one operation. The subject technology sends a result of the at least one operation to the computing process, where sending the result of the at least one operation utilizes a data transport mechanism that supports a network transfer of columnar data.

公开(公告)号：US12277101B2

公开(公告)日：2025-04-15

申请号：US18393279

申请日：2023-12-21

Applicant: Snowflake Inc.

Inventor： Srilakshmi Chintala ,  Jianzhun Du ,  Naresh Kumar ,  Srinath Shankar ,  Leonhard Franz Spiegelberg ,  Eric Shawn Vandenberg ,  Andong Zhan ,  Yun Zou

IPC: G06F16/22 ,  G06F16/11 ,  G06F16/242 ,  G06F16/2453

Abstract: A method provides deterministic row ordering for query result sets in a database system. A framework receives a query referencing a database table and generating a row index column in response. The framework generates the row index column that involves determining an order associated with source files underlying the referenced table and assigns each table row a unique index value based on the file order and row position within the files. The framework executes the received query to produce a result set ordered by the generated row index column. The framework determines row order based on analyzing underlying data file metadata and facilitates returning the result set with consistent, reliable ordering, enabling stable positional-based access semantics when querying distributed database tables.

公开(公告)号：US12190181B2

公开(公告)日：2025-01-07

申请号：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

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.

公开(公告)号：US12074991B2

公开(公告)日：2024-08-27

申请号：US18338909

申请日：2023-06-21

Applicant: Snowflake Inc.

Inventor： Harsh Chaturvedi ,  Harsha S. Kapre ,  Srinath Shankar

IPC: H04L9/32 ,  H04L67/1097 ,  H04L67/289

CPC classification number: H04L9/3268 ,  H04L9/3297 ,  H04L67/1097 ,  H04L67/289

Abstract: A proxy revocation service provides a reliable service for performing revocation checks. The proxy revocation service queries public certificate authorities for the revocation status of a set of digital certificates and maintains a database of the revocation statuses. The proxy revocation service provides a singular endpoint that is Application Protocol Interface (API) accessible to web clients. Web clients communicate with the proxy revocation service through use of API message to perform revocation checks, rather than communicating with the public certificate authorities using an online certificate status protocol (OCSP). Use of the proxy revocation service provides both a reliable service for performing revocation checks as well as shifts the complexity away from the web clients.

公开(公告)号：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.

公开(公告)号：US11921733B2

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

申请号：US17813662

申请日：2022-07-20

Applicant: Snowflake Inc.

Inventor： Harsha S. Kapre ,  Mark T. Keller ,  Srinath Shankar ,  Kushan A. Zaveri

IPC: G06F16/2458 ,  G06F16/2453 ,  G06F16/2455 ,  G06F16/25

CPC classification number: G06F16/2471 ,  G06F16/24532 ,  G06F16/24561 ,  G06F16/256 ,  G06F16/258

Abstract: Techniques for fetching query result data using result batches includes generating a plurality of result batches based on query result information. The query result information is associated with query result data generated from execution of a query. Each result batch of the plurality of result batches includes a result data retrieval function for a corresponding data portion of a plurality of data portions of the query result data. The plurality of result batches are encoded for distribution to a corresponding plurality of computing nodes. The techniques further include causing retrieving of the plurality of data portions of the query result data by the corresponding plurality of computing nodes based on the result data retrieval function for each of the plurality of data portions.