-
公开(公告)号:US12287808B2
公开(公告)日:2025-04-29
申请号:US18472912
申请日:2023-09-22
Applicant: SNOWFLAKE INC.
Inventor: Thierry Cruanes , Benoit Dageville , Marcin Zukowski
IPC: G06F16/27 , A61F5/56 , G06F9/48 , G06F9/50 , G06F16/14 , G06F16/182 , G06F16/21 , G06F16/22 , G06F16/23 , G06F16/2453 , G06F16/2455 , G06F16/2458 , G06F16/25 , G06F16/28 , G06F16/951 , G06F16/9535 , G06F16/9538 , H04L67/1095 , H04L67/1097 , H04L67/568
Abstract: Example resource management systems and methods are described. In one implementation, a resource manager is configured to manage data processing tasks associated with multiple data elements. An execution platform is coupled to the resource manager and includes multiple execution nodes configured to store data retrieved from multiple remote storage devices. Each execution node includes a cache and a processor, where the cache and processor are independent of the remote storage devices. A metadata manager is configured to access metadata associated with at least a portion of the multiple data elements.
-
公开(公告)号:US20250117382A1
公开(公告)日:2025-04-10
申请号:US18988025
申请日:2024-12-19
Applicant: Snowflake Inc.
Inventor: Tyler Arthur Akidau , Fabian Hueske , Tyler Jones , Daniel Mills , Leon Papke , Prasanna Rajaperumal , Daniel E. Sotolongo
IPC: G06F16/2453
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.
-
公开(公告)号:US20250111083A1
公开(公告)日:2025-04-03
申请号:US18977758
申请日:2024-12-11
Applicant: Snowflake Inc.
Inventor: Artin Avanes , Thierry Cruanes , Monica J. Holboke , Allison Waingold Lee , Subramanian Muralidhar , David Schultz
IPC: G06F21/62 , G06F9/54 , G06F16/2455 , G06F21/53
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.
-
公开(公告)号:US20250111070A1
公开(公告)日:2025-04-03
申请号:US18375252
申请日:2023-09-29
Applicant: Snowflake Inc.
Inventor: Damien Carru , Eric Karlson , Haojie Luan , Mohamad Raja Gani Mohamad Abdul , Frantisek Rolinek
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.
-
公开(公告)号:US12248595B2
公开(公告)日:2025-03-11
申请号:US18306799
申请日:2023-04-25
Applicant: Snowflake Inc.
Inventor: Marion A. Brown , Keith M. Hoyle
IPC: G06F21/62 , G06F16/182 , H04L9/08 , H04L9/40
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.
-
公开(公告)号:US12248587B2
公开(公告)日:2025-03-11
申请号:US18187031
申请日:2023-03-21
Applicant: Snowflake Inc.
Inventor: Damien Carru , Jeremy Yujui Chen , Pui Kei Johnston Chu , Scott C. Gray , Unmesh Jagtap , Mohamad Raja Gani Mohamad Abdul , William A. Pugh , Ahmed Waseef Shawkat , Xu Xu
Abstract: A data platform for managing an application as a first-class database object. The data object can include User Interface (UI) components. The data application can be shared by a provider account to a plurality of consumer accounts using a share object and based on grant commands. The consumer accounts can deploy and operate the UI component based on the share object.
-
公开(公告)号:US12248485B2
公开(公告)日:2025-03-11
申请号:US18419165
申请日:2024-01-22
Applicant: Snowflake Inc.
Inventor: Harsha S. Kapre , Mark T. Keller , Srinath Shankar , Kushan A Zaveri
IPC: G06F16/2458 , G06F16/2453 , G06F16/2455 , G06F16/25
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.
-
公开(公告)号:US12242506B2
公开(公告)日:2025-03-04
申请号:US18498657
申请日:2023-10-31
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Shreyas Narendra Desai , Khondokar Sami Iqram , Subramanian Muralidhar , Chieh-Sheng Wang , Di Wu
Abstract: A database system can configure network devices, such as a primary database in a multi-tenant deployment and a secondary database in a private deployment, to send and receive sequence messages, such as input data indicative of a selection of a link. The database system can create a secure share area in the private deployment in response to receiving the input data indicative of the selection of the link. The database system can replicate the data from the multi-tenant deployment to the secure share area in the private deployment and share the replicated data from the secure share area to the secondary database hosted in the private deployment.
-
公开(公告)号:US12223085B2
公开(公告)日:2025-02-11
申请号:US18497205
申请日:2023-10-30
Applicant: Snowflake Inc.
Inventor: Marcus A. Henderson , Justin Langseth
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.
-
公开(公告)号:US12223083B2
公开(公告)日:2025-02-11
申请号:US18225573
申请日:2023-07-24
Applicant: Snowflake Inc.
Inventor: Ishaan Nerurkar , Christopher Hockenbrocht , Liam Damewood , Mihai Maruseac , Alexander Rozenshteyn
IPC: G06F21/62 , G06F16/2453 , G06F16/2455 , G06F16/2458 , G06F16/248 , G06F16/25 , G06N5/01 , G06N20/00 , G06N20/20 , H04L9/40
Abstract: A hardware database privacy device is communicatively coupled to a private database system. The hardware database privacy device receives a request from a client device to perform a query of the private database system and identifies a level of differential privacy corresponding to the request. The identified level of differential privacy includes privacy parameters (ε,δ) indicating the degree of information released about the private database system. The hardware database privacy device identifies a set of operations to be performed on the set of data that corresponds to the requested query. After the set of data is accessed, the set of operations is modified based on the identified level of differential privacy such that a performance of the modified set of operations produces a result set that is (ε,δ)-differentially private.
-
-
-
-
-
-
-
-
-