Configuring managed event tables using execution node processes

    公开(公告)号:US11645298B1

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

    申请号:US17934857

    申请日:2022-09-23

    Applicant: Snowflake Inc.

    CPC classification number: G06F16/254 G06F16/2282 G06F16/258

    Abstract: Techniques for configuring managed event tables include generating at a first process of an execution node, log data associated with execution of user-defined function (UDF) code. The log data is provided from the first process to a second process of the execution node. The first process is configured as a sub-process of the second process. The log data is formatted using the second process of the execution node, to generate formatted log data. The formatting is based on a configuration of a managed event table that is external to the execution node. The formatted log data is communicated from the second process of the execution node into a managed event table maintained at a computing node that is external to the execution node.

    Tracking intermediate changes in database data

    公开(公告)号:US11620281B2

    公开(公告)日:2023-04-04

    申请号:US17656960

    申请日:2022-03-29

    Applicant: Snowflake Inc.

    Abstract: Systems, methods, and devices for tracking a series of changes to database data are disclosed. A method includes executing a transaction to modify data in a micro-partition of a table of a database by generating a new micro-partition that embodies the transaction. The method includes associating transaction data with the new micro-partition, wherein the transaction data comprises a timestamp when the transaction was fully executed, and further includes associating modification data with the new micro-partition that comprises an indication of one or more rows of the table that were modified by the transaction. The method includes joining the transaction data with the modification data to generate joined data and querying the joined data to determine a listing of intermediate modifications made to the table between a first timestamp and a second timestamp.

    Accessing listings in a data exchange

    公开(公告)号:US11531681B2

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

    申请号:US17704783

    申请日:2022-03-25

    Applicant: Snowflake Inc.

    Abstract: A method for accessing listings in a data exchange includes creating a first listing in a data exchange, the first listing referencing a first database of a plurality of databases and specifying identity-based sharing of the first database, creating a second listing in the data exchange, the second listing referencing a second database of the plurality of databases and data of the first database shared according to the identity-based sharing of the first database, and receiving an instruction from a user of the data exchange, the instruction referencing the second listing and instructing the addition of the second listing to a set of consumed data shares accessible by the user.

    Share object discovery techniques
    140.
    发明授权

    公开(公告)号:US11520920B1

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

    申请号:US17580341

    申请日:2022-01-20

    Applicant: Snowflake Inc.

    Abstract: Embodiments of the present disclosure provide an enhanced method of discovering shared objects that utilizes share authorization in addition to role authorization when a role is attempting to discover shared objects. A consumer account may invoke an operation referencing shared objects within a provider account using an imported database as a current session database. In response, a call context of the operation may be updated to save the imported database as a current session database and the imported database may be mapped to a first share and to a shared database. A first authorization based on whether the role has access privileges to the shared objects may be performed. The shared database may be used to identify schemas and the schemas may be used to identify shares associated with the imported database. A secondary authorization may be performed based on permissions that the shares associated with the imported database have on the shared objects.

Patent Agency Ranking