公开(公告)号：WO2022261616A1

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

申请号：PCT/US2022/072771

申请日：2022-06-06

Applicant: SNOWFLAKE INC.

Inventor： BROSSARD, Elliott ,  KOMARLA SUKUMAR, Sukruth ,  KUNEN, Isaac ,  KUO, Ju-yi ,  LEANG, Jonathan Lee ,  MA, Edward ,  MANCHESTER, Schuyler James ,  PAULUS, Polita ,  SHAH, Saurin ,  ZINKOVSKY, Igor

IPC: G06F16/901

Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF signatures and interfaces (e.g., classes, sub-classes) that can be called by other users. Upon a UDF being called, one or more interface objects (e.g., InputStream) can be created and requests transferred to a execution node via a network channel. The execution node can implement multiple threads that are authorized and download file data from a staging location (e.g., internal stage, external stage) concurrently.

公开(公告)号：WO2022026974A1

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

申请号：PCT/US2021/070800

申请日：2021-06-30

Applicant: SNOWFLAKE INC.

Inventor： CSERI, Istvan ,  KUNEN, Isaac ,  LI, Bing ,  MA, Edward ,  SHANKAR, Srinath

IPC: G06F8/51

Abstract: The subject technology receives first code in a first programming language, the first code including a reference to a first dataset. The subject technology converting the first code to: second code in a second programming language different than the first programming language, and at least one data query in a second format different than the first programming language. Further the subject technology sends the converted first code and the at least one data query to a data system for execution.

公开(公告)号：WO2022261617A1

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

申请号：PCT/US2022/072772

申请日：2022-06-06

Applicant: SNOWFLAKE INC.

Inventor： BHATIA, Khushboo ,  KUNEN, Isaac ,  LI, Zihan ,  MA, Edward ,  SHANKAR, Srinath

IPC: G06F9/54

Abstract: Disclosed are systems, methods, and non-transitory computer- readable media for a providing stored procedures in a network-based database system. A database system executes a stored procedure within a sandbox process. The sandbox process separates the stored procedure from the other services and processes of the database system and may also limit the resources (e.g., storage, memory, etc.) and functionality available to the stored procedure. Stored procedures are commonly designed to execute database queries that are processed by other components of the database system. To provide for secure communication between the stored procedure and the other components of the database system, the sandbox process is loaded with java database connectivity (JDBC) libraries (e.g., JDBC instance) that is modified to limit the communication abilities of the stored procedure.

公开(公告)号：WO2021126599A1

公开(公告)日：2021-06-24

申请号：PCT/US2020/063794

申请日：2020-12-08

Applicant: SNOWFLAKE INC.

Inventor： LI, Bing ,  MA, Edward ,  RUI, Mingli ,  YU, Haowei ,  ZHAN, Andong

IPC: G06F16/2455 ,  G06F21/62 ,  G06F16/25 ,  G06F16/24552 ,  G06F16/24561 ,  G06F16/258 ,  G06F16/27 ,  G06F16/28 ,  H04L63/0281

Abstract: A shared database platform can interface with a cluster computing platform over a network through a connector. The data transferred over the network can include metadata result packages that can be distributed to worker nodes of the cluster computing platform, which receive the metadata objects and access the result data for further processing on a staging platform, such as a scalable storage platform.