Managed event tables in a database system

    公开(公告)号:US11487778B1

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

    申请号:US17649571

    申请日:2022-02-01

    Applicant: Snowflake Inc.

    Abstract: Provided herein are systems and methods for configuring managed event tables. A system includes at least one hardware processor coupled to a memory and configured to collect using an event table instance within a sandbox process, log data generated by a UDF during execution of the UDF code. The log data is provided from the sandbox process to an execution node process of the execution node. The log data is formatted using the execution node process, 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 at least one hardware processor further causes ingestion of the formatted log data from the execution node process into the managed event table.

    CONFIGURING AN EVENT TABLE USING COMPUTING NODE PROCESSES

    公开(公告)号:US20250086193A1

    公开(公告)日:2025-03-13

    申请号:US18954797

    申请日:2024-11-21

    Applicant: Snowflake inc.

    Abstract: Techniques for configuring a managed event table (MET) include detecting, by at least one hardware processor, a query for the MET. The query received at a first computing node of a network-based database system. The method includes retrieving via an ingestion function configured at the first computing node, reformatted data from a dedicated storage location of a first process into the MET. The reformatted data is based on log data associated with a second process. The first process and the second process are executing at a second computing node of the network-based database system. The method includes processing the query using the reformatted data in the MET.

    Configuring an event table using computing node processes

    公开(公告)号:US12182155B2

    公开(公告)日:2024-12-31

    申请号:US18302515

    申请日:2023-04-18

    Applicant: Snowflake Inc.

    Abstract: Techniques for configuring event tables include retrieving, by at least one hardware processor of a computing node, log data at a first process of the computing node. The log data is associated with a function executing at a second process of the computing node. The log data is revised using a table stage to generate revised log data. The table stage is configured as a dedicated storage location of the first process. The revising includes a data enrichment process based on metadata associated with execution of the function at the second process. The revised log data is ingested into an event table.

    APPLICATION VERSIONING AND UPGRADE
    15.
    发明公开

    公开(公告)号:US20240281245A1

    公开(公告)日:2024-08-22

    申请号:US18470585

    申请日:2023-09-20

    Applicant: Snowflake Inc.

    CPC classification number: G06F8/71 G06F8/658 G06F9/4488

    Abstract: Methodologies for upgrading and patching an in-database application package and its application instances. A data platform determines a number of objects of an application instance running on the data platform at a previous version level of an application package of the application instance. In response to determining the number of objects of the application package running on the data platform at the previous version level of the application package is one or more, the data platform continues determining the number of objects running on the data platform at a previous version level of the application package. In response to determining the number of objects of the application instance running on the data platform at the previous version level of the application package is none, the data platform upgrades the application instance to the new version of the application package.

    DATA PLATFORM WITH UNIFIED PRIVILEGES
    16.
    发明公开

    公开(公告)号:US20240163316A1

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

    申请号:US18423012

    申请日:2024-01-25

    Applicant: Snowflake Inc.

    CPC classification number: H04L63/20

    Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.

    DATA PLATFORM WITH UNIFIED PRIVILEGES
    17.
    发明公开

    公开(公告)号:US20230403306A1

    公开(公告)日:2023-12-14

    申请号:US18053956

    申请日:2022-11-09

    Applicant: Snowflake Inc.

    CPC classification number: H04L63/20

    Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.

    Versioned schema
    19.
    发明授权

    公开(公告)号:US11755311B1

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

    申请号:US18169823

    申请日:2023-02-15

    Applicant: Snowflake Inc.

    CPC classification number: G06F8/65 G06F16/219

    Abstract: A versioned schema of a data platform. A process of maintaining a call stack of executing objects of an application package having a versioned schema includes calling, by a first procedure executed by one or more processors, a second procedure of a versioned application instance, and determining, by the first procedure, a version of the second procedure based on a call context. In response to determining that the version of the second procedure is not in the call context, the first procedure determines a current version of the versioned application package adds the current version to the call context as the version of the second procedure.

Patent Agency Ranking