公开(公告)号：US12204547B2

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

申请号：US18471001

申请日：2023-09-20

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Srilakshmi Chintala ,  Istvan Cseri ,  Rodger N. Kline ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/30 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/27

Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.

公开(公告)号：US20220413816A1

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

申请号：US17823621

申请日：2022-08-31

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Siddharth Kulkarni ,  Isaac Kunen

IPC: G06F8/41 ,  G06F9/54 ,  G06F21/60

Abstract: Embodiments described herein provide techniques for in-line compiling of UDFs in other programming languages. These techniques enable faster programming iterations because it allows users to compile directly in the cloud processing system. Moreover, it allows the UDFs to tie into existing libraries. The compiled results are treated as sensitive and handled with appropriate security policies, as with any other user data in the system.

公开(公告)号：US11423081B1

公开(公告)日：2022-08-23

申请号：US17390969

申请日：2021-08-01

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Sukruth Komarla Sukumar ,  Isaac Kunen ,  Ju-Yi Kuo ,  Jonathan Leang ,  Edward Ma ,  Schuyler James Manchester ,  Polita Paulus ,  Saurin Shah ,  Igor Zinkovsky

IPC: G06F16/00 ,  G06F16/901 ,  G06F16/955 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/908

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.

公开(公告)号：US20220237231A1

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

申请号：US17657548

申请日：2022-03-31

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Sukruth Komarla Sukumar ,  Isaac Kunen ,  Ju-yi Kuo ,  Jonathan Lee Leang ,  Edward Ma ,  Schuyler James Manchester ,  Polita Paulus ,  Saurin Shah ,  Igor Zinkovsky

IPC: G06F16/901 ,  G06F16/955 ,  G06F16/2455 ,  G06F16/22 ,  G06F16/908

Abstract: A file access system for user defined functions (UDFs) can be implemented on a distributed database system. The system can store UDF interfaces and file reference objects that can be called by other users. Upon a UDF being called, files on a stage, one or more interface objects (e.g., InputStream), and file reference objects can be implemented by execution nodes of the distributed database system. The execution nodes can implement multiple threads that are authenticated and can download file data from a staging location concurrently.

公开(公告)号：US12242475B2

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

申请号：US17039473

申请日：2020-09-30

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Istvan Cseri ,  Isaac Kunen ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/2453

Abstract: External functions can provide users of a database system the ability to invoke external services while operating from inside the database system. The techniques described herein address may detect throttling by the external system and automatically adjust or modify a request rate accordingly. Also, the techniques described herein may increase the request rate to optimize the use of the resources provided by the external system. These techniques allow the database system to improve efficiency when working with external services, which may or may not be elastic or scalable. Moreover, these techniques can decrease query execution times and reduce costs.

公开(公告)号：US11803552B2

公开(公告)日：2023-10-31

申请号：US17813548

申请日：2022-07-19

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Srilakshmi Chintala ,  Istvan Cseri ,  Rodger N. Kline ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/30 ,  G06F16/2455 ,  G06F16/25 ,  G06F16/27

CPC classification number: G06F16/24564 ,  G06F16/258 ,  G06F16/27

Abstract: An external function system can be implemented on a database to perform processing on one or more external network services. The external function system can comprise a particular external function for a particular external service, an outbound serializer function, and an inbound serializer function that are linked with the particular external function. The outbound serializer function can be configured to transform the data of a query from a database format to a different format of the particular external network service. The inbound deserializer function can be configured to receive data returned from the external service and transform the data to the format of the database.

公开(公告)号：US11347485B1

公开(公告)日：2022-05-31

申请号：US17389937

申请日：2021-07-30

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Istvan Cseri ,  Derek Denny-Brown ,  Filip Drozdowski ,  Isaac Kunen ,  Edward Ma

IPC: G06F9/44 ,  G06F8/41 ,  G06F16/22 ,  G06F8/30

Abstract: A system comprises at least one hardware processor and a memory storing instructions. When executed, the instructions cause the at least one hardware processor to perform operations comprising receiving, in a compiling process, a request to create a Java user-defined table function (Java UDTF), the Java UDTF including code related to receiving one or more input tables and transforming the one or more input tables to an output table; verifying a construct of the Java UDTF in the request is correct; and compiling to generate execution code that includes the Java UDTF when the construct of the Java UDTF is correct.

公开(公告)号：US20220100758A1

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

申请号：US17039473

申请日：2020-09-30

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Istvan Cseri ,  Isaac Kunen ,  Nitya Kumar Sharma ,  Igor Zinkovsky

IPC: G06F16/2453

Abstract: External functions can provide users of a database system the ability to invoke external services while operating from inside the database system. The techniques described herein address may detect throttling by the external system and automatically adjust or modify a request rate accordingly. Also, the techniques described herein may increase the request rate to optimize the use of the resources provided by the external system. These techniques allow the database system to improve efficiency when working with external services, which may or may not be elastic or scalable. Moreover, these techniques can decrease query execution times and reduce costs.

公开(公告)号：US20250068616A1

公开(公告)日：2025-02-27

申请号：US18944963

申请日：2024-11-12

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Chong Han ,  Igor Zinkovsky

IPC: G06F16/22 ,  G06F16/248 ,  G06F16/25 ,  G06F16/27

Abstract: A method to process UDFs includes performing, by at least one hardware processor of a database system, a resolution of application components to determine a plurality of resolved components of an application and a plurality of data types corresponding to the plurality of resolved components. The method includes instantiating a plurality of UDF clients. The plurality of UDF clients are associated with the plurality of data types. The method includes detecting a received database query specifies a data type of the plurality of data types. The method includes executing the received database query at a UDF client of the plurality of UDF clients.

公开(公告)号：US11645243B2

公开(公告)日：2023-05-09

申请号：US17522276

申请日：2021-11-09

Applicant: Snowflake Inc.

Inventor： Elliott Brossard ,  Sukruth Komarla Sukumar ,  Isaac Kunen ,  Ju-yi Kuo ,  Jonathan Lee Leang ,  Edward Ma ,  Schuyler James Manchester ,  Polita Paulus ,  Saurin Shah ,  Igor Zinkovsky

IPC: G06F12/00 ,  G06F16/00 ,  G06F16/182 ,  G06F9/54 ,  G06F16/14 ,  G06F16/176 ,  G06F16/13

CPC classification number: G06F16/183 ,  G06F9/547 ,  G06F16/13 ,  G06F16/148 ,  G06F16/176

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.