-
公开(公告)号:US11928110B2
公开(公告)日:2024-03-12
申请号:US18051483
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Chong Han , Albert L. Hu , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/00 , G06F16/242 , G06F16/248 , G06F16/27 , G06F8/41
CPC classification number: G06F16/2448 , G06F16/248 , G06F16/27 , G06F8/433
Abstract: A database dependency resolver system can identify different dependencies of a user application and integrate the identified dependencies in different execution environments of a distributed database system. The different execution environments can manage different versions of a given programming language, or other types of computational architectures (e.g., different CPU types). A database user can provide a database statement (e.g., query) that activates the different dependencies in the different environments to generate results data.
-
公开(公告)号:US11675784B2
公开(公告)日:2023-06-13
申请号:US17823132
申请日:2022-08-30
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Istvan Cseri , Albert L. Hu , Isaac Kunen , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/22 , G06F16/2458 , G06F16/245 , G06F16/958 , H04L9/40
CPC classification number: G06F16/245 , G06F16/2282 , G06F16/2471 , G06F16/986 , H04L63/0281 , H04L63/0846
Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.
-
公开(公告)号:US11762978B1
公开(公告)日:2023-09-19
申请号:US18194407
申请日:2023-03-31
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Albert L. Hu , Ziliang Zhang , Igor Zinkovsky
CPC classification number: G06F21/44 , G06F21/53 , G06F2221/2141
Abstract: Methods, systems, and computer programs are presented for a packages policy object to enable customers to create and apply packages policies provided by third-party package managers. A user-defined function (UDF) is received by a cloud data platform. The UDF includes code related to at least one operation to be performed. The cloud data platform receives a package policy including at least one allowlist and at least one blocklist and compares the at least one allowlist and the at least one blocklist to the at least one package specification. The cloud data platform computes a difference set based on the comparison. The difference set includes metadata associated with one or more packages to remove. The cloud data platform determines whether the UDF is permitted based at least in part on the difference set.
-
公开(公告)号:US11138192B1
公开(公告)日:2021-10-05
申请号:US17302388
申请日:2021-04-30
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Istvan Cseri , Albert L. Hu , Isaac Kunen , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/00 , G06F16/245 , G06F16/22 , H04L29/06 , G06F16/958
Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.
-
公开(公告)号:US20240168947A1
公开(公告)日:2024-05-23
申请号:US18429286
申请日:2024-01-31
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Chong Han , Albert L. Hu , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/242 , G06F16/248 , G06F16/27
CPC classification number: G06F16/2448 , G06F16/248 , G06F16/27 , G06F8/433
Abstract: Multiple execution environments are established for processing database statements with diverse package dependencies. A database system receives a user application and identifies, via hardware processors, multiple package dependencies required by the application, including at least a first and a second package dependency. Upon receiving a database statement from a user that invokes these dependencies, the system retrieves the necessary packages from a repository. It then creates a first execution environment incorporating the first package dependency and a second execution environment with the second package dependency. Utilizing the multiple execution environments, the system generates results data in response to the database statement, effectively managing and executing user-defined functions that rely on different versions or types of package dependencies within a unified database framework.
-
6.
公开(公告)号:US20220350794A1
公开(公告)日:2022-11-03
申请号:US17646200
申请日:2021-12-28
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Istvan Cseri , Albert L. Hu , Isaac Kunen , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/245 , G06F16/22 , G06F16/958
Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.
-
公开(公告)号:US11243947B1
公开(公告)日:2022-02-08
申请号:US17388142
申请日:2021-07-29
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Istvan Cseri , Albert L. Hu , Isaac Kunen , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/00 , G06F16/245 , H04L29/06 , G06F16/22 , G06F16/958
Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.
-
公开(公告)号:US20240330430A1
公开(公告)日:2024-10-03
申请号:US18363322
申请日:2023-08-01
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Albert L. Hu , Ziliang Zhang , Igor Zinkovsky
CPC classification number: G06F21/44 , G06F21/53 , G06F2221/2141
Abstract: Methods, systems, and computer programs are presented for a policy to enable customers to create and apply allowed items and restricted items provided by third-party managers. User code is received by a cloud data platform, the code for performing an operation. The cloud data platform receives a policy including allowed items and restricted items. The cloud data platform compares the allowed and restricted items to a specification, and determines a difference based on the comparison. The cloud data platform determines whether to permit the operation based at least in part on the differences.
-
公开(公告)号:US20230273918A1
公开(公告)日:2023-08-31
申请号:US18051483
申请日:2022-10-31
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Chong Han , Albert L. Hu , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/242 , G06F16/248 , G06F16/27 , G06F8/41
CPC classification number: G06F16/2448 , G06F16/248 , G06F16/27 , G06F8/433
Abstract: A database dependency resolver system can identify different dependencies of a user application and integrate the identified dependencies in different execution environments of a distributed database system. The different execution environments can manage different versions of a given programming language, or other types of computational architectures (e.g., different CPU types). A database user can provide a database statement (e.g., query) that activates the different dependencies in the different environments to generate results data.
-
公开(公告)号:US20220414094A1
公开(公告)日:2022-12-29
申请号:US17823132
申请日:2022-08-30
Applicant: Snowflake Inc.
Inventor: Srilakshmi Chintala , Istvan Cseri , Albert L. Hu , Isaac Kunen , Nitya Kumar Sharma , Igor Zinkovsky
IPC: G06F16/2458 , G06F16/22
Abstract: A query referencing an external table function provided by a remote software component is received. Requests to execute the external table function on input data are sent to a proxy service. A first request includes a batch of input rows from the input data. A first response to the first request received from the proxy service includes a first portion of result data and a pagination token. The pagination token indicates that at least a second portion of the result data corresponding to the first batch of input rows is to be obtained from the remote software component. Based on the pagination token, a second request is sent to obtain the second portion of the result data. One or more responses are received from the proxy service that comprise at least the second portion of the result data. The result data is processed according to the query.
-
-
-
-
-
-
-
-
-