QUERY REFRESH USING MULTIPLE PROCESSING PIPELINES

    公开(公告)号:US20250117382A1

    公开(公告)日:2025-04-10

    申请号:US18988025

    申请日:2024-12-19

    Applicant: Snowflake Inc.

    Abstract: A system includes at least one hardware processor and at least one memory storing instructions that cause the at least one hardware processor to perform operations. The operations include generating a log of changes posted to a plurality of intermediate materialized tables (MTs) during execution of a query in a network-based database system. The query is associated with a source MT that the intermediate MTs depend on. The operations include rendering the log of changes into a dependency graph. The operations include configuring a plurality of processing pipelines based on the dependency graph. The operations include performing refreshes on one or more of the plurality of intermediate MTs in at least one of the plurality of processing pipelines to complete the refresh operation. The refreshes are performed responsive to detecting an instruction for a refresh operation on the source MT.

    DATA CLEAN ROOMS USING DEFINED ACCESS

    公开(公告)号:US20250111083A1

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

    申请号:US18977758

    申请日:2024-12-11

    Applicant: Snowflake Inc.

    Abstract: In an embodiment, a data platform creates an application in a data-provider account. The application includes one or more APIs corresponding to one or more underlying code blocks. The data platform shares provider data with the application in the data-provider account, and also installs, in a data-consumer account, an application instance of the application. The application instance includes one or more APIs corresponding to the one or more APIs in the application in the data-provider account. The data platform shares consumer data with the application instance in the data-consumer account, and invokes one or more of the APIs of the application instance to execute respective associated underlying code blocks, which are not visible to the data-consumer account. The data platform also saves output of the one or more respective associated underlying code blocks locally within the data-consumer account.

    AUTHORIZATION ON USER DEFINED ENTITY TYPES

    公开(公告)号:US20250111070A1

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

    申请号:US18375252

    申请日:2023-09-29

    Applicant: Snowflake Inc.

    Abstract: Disclosed are techniques for providing scoped grants that provide object-specific authorization for privileges on user-defined objects. A scoped grant is a grant of a generalized, non-specific privilege that also limits the contexts in which that grant is applicable (i.e., scopes the grant) during authorization, where the “context” is defined by the user-defined object upon which the privilege is being performed. A user statement requesting a grant of a privilege on a user-defined object may be received. A scoped privilege that provides a grant of a base privilege identified from the user statement and limits application of the grant of the base privilege to the user-defined object is created. Scoping object information associated with the user-defined object is provided to an authorization engine, wherein the scoping information includes a set of properties identifying the user-defined object. A scoped grant is created based on the scoped privilege using the scoping object information.

    Network intrusion event response and protection

    公开(公告)号:US12248595B2

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

    申请号:US18306799

    申请日:2023-04-25

    Applicant: Snowflake Inc.

    Abstract: Provided herein are systems and methods for network intrusion event response and remediation. A file encryption key is generated based on a first private key of a user and a root key associated with a primary deployment of a database system. File data is encoded at a source account of the user using the file encryption key. The file data is replicated from the source account into a target account of the user to generate replicated file data. Notification of a detected network intrusion event is encoded for transmission to the user. A failover of the source account to the target account is performed based on the notification. The failover grants the user access to the replicated file data based at least on a second private key of the user.

    Fetching query result data using result batches

    公开(公告)号:US12248485B2

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

    申请号:US18419165

    申请日:2024-01-22

    Applicant: Snowflake Inc.

    Abstract: Techniques for fetching query result data using result batches includes retrieving query result information from a first computing node of a database system. The query result information includes result data associated with a multi-stage execution of a query. A plurality of result batches are generated based on the query result information. Each result batch of the plurality of result batches includes a retrieval function for a portion of the result data. The portion of the result data for each result batch of the plurality of result batches is retrieved based on execution of the retrieval function by at least a second computing node of the database system. The result data associated with the multi-stage execution of the query is output based on completion of the retrieval.

    Identity resolution and data enrichment application framework

    公开(公告)号:US12223085B2

    公开(公告)日:2025-02-11

    申请号:US18497205

    申请日:2023-10-30

    Applicant: Snowflake Inc.

    Abstract: Techniques for identity resolution and data enrichment include instantiating, at an account of a data consumer, an identity resolution application using an installer stored procedure. A data object is configured, at the account of the data consumer, to share log data generated by the identity resolution application with an account of a data provider. The identity resolution application is enabled, at the account of the data consumer, for an identity resolution process using source data based on an instruction originating from the account of the data provider. The instruction is based on the configuring of the data object.

Patent Agency Ranking