Granular access control of packages

    公开(公告)号:US11762978B1

    公开(公告)日:2023-09-19

    申请号:US18194407

    申请日:2023-03-31

    Applicant: Snowflake Inc.

    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.

    Invoking external table functions from a database system

    公开(公告)号:US11138192B1

    公开(公告)日:2021-10-05

    申请号:US17302388

    申请日:2021-04-30

    Applicant: Snowflake Inc.

    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.

    MULTIPLE ENVIRONMENTS AND FUNCTIONS IN A DATABASE SYSTEM

    公开(公告)号:US20240168947A1

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

    申请号:US18429286

    申请日:2024-01-31

    Applicant: Snowflake Inc.

    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.

    PARTITIONING TO SUPPORT INVOCATION OF EXTERNAL TABLE FUNCTIONS ON MULTIPLE BATCHES OF INPUT ROWS

    公开(公告)号:US20220350794A1

    公开(公告)日:2022-11-03

    申请号:US17646200

    申请日:2021-12-28

    Applicant: Snowflake Inc.

    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.

    Handshake protocol to facilitate invocation of external table functions

    公开(公告)号:US11243947B1

    公开(公告)日:2022-02-08

    申请号:US17388142

    申请日:2021-07-29

    Applicant: Snowflake Inc.

    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.

    PROVIDING ACCESS CONTROL FOR POLICIES
    8.
    发明公开

    公开(公告)号:US20240330430A1

    公开(公告)日:2024-10-03

    申请号:US18363322

    申请日:2023-08-01

    Applicant: Snowflake Inc.

    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.

    CONFIGURING PARALLELISM PARAMETERS FOR INVOCATION OF EXTERNAL TABLE FUNCTIONS

    公开(公告)号:US20220414094A1

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

    申请号:US17823132

    申请日:2022-08-30

    Applicant: Snowflake Inc.

    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.

Patent Agency Ranking