公开(公告)号：US20250023941A1

公开(公告)日：2025-01-16

申请号：US18900363

申请日：2024-09-27

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: H04L67/10 ,  G06F16/23 ,  G06F21/62 ,  H04L9/40 ,  H04L41/50 ,  H04L67/1097 ,  H04L67/51 ,  H04L67/53

Abstract: Sharing data in a data exchange across multiple cloud computing platforms is described. An example method includes copying, to a first cloud computing entity using a consumer account of the first cloud computing entity, a first subset of a data set associated with a provider account of a second cloud computing entity, wherein the provider account of the second cloud computing entity does not have access to the first cloud computing entity, and verifying existence of the first subset of the data set at the first cloud computing entity.

公开(公告)号：US12158970B2

公开(公告)日：2024-12-03

申请号：US18111821

申请日：2023-02-20

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Peter Povinec ,  Philipp Thomas Unterbrunner ,  Martin Hentschel

IPC: G06F21/62 ,  G06F21/60

Abstract: A method for directing queries to encrypted database files includes acquiring a mapping that links a first encrypted file with a different encrypted file. The first encrypted file is generated based on a first encryption key. The method includes generating, by one or more processors based on the mapping, an updated mapping to link a second encrypted file with the different encrypted file. The second encrypted file is generated based on a second encryption key. The method includes directing, using the mapping, a first query to the first encrypted file when the first query arrives before generating the updated mapping; and. The method includes directing, using the updated mapping, a second query to the second encrypted file when a second query arrives after generating the updated mapping.

公开(公告)号：US20240394395A1

公开(公告)日：2024-11-28

申请号：US18787930

申请日：2024-07-29

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Subramanian Muralidhar ,  Bowen Zhang

IPC: G06F21/62 ,  G06F16/21 ,  G06F16/25

Abstract: Embodiments of the present disclosure relate to sharing data using database roles. Database roles are generated within a database container of a provider account. Grants to a particular subset of the plurality of data objects of the database container may be assigned to each of the database roles, and each of the database roles are granted to a share object. The share object is mounted within a consumer account to generate an imported copy of each of the database roles. The imported copy of one or more of the database roles is granted to each of one or more account level roles of the consumer account. When a new object is added to a particular database role, it is immediately available for consumption by any account level roles to which the imported copy of the particular database role has been granted.

公开(公告)号：US20240323194A1

公开(公告)日：2024-09-26

申请号：US18673681

申请日：2024-05-24

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew J. Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: H04L9/40 ,  G06F16/2455 ,  G06F21/60 ,  G06F21/62 ,  H04L41/22 ,  H04L51/212 ,  H04L67/1097

CPC classification number: H04L63/102 ,  G06F16/2455 ,  G06F21/606 ,  G06F21/6218 ,  H04L41/22 ,  H04L51/212 ,  H04L63/101 ,  H04L67/1097

Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes creating, in a first data exchange belonging to a first data provider, a first listing. The method further comprises creating, in a second data exchange belonging to a second data provider, a second listing, the second listing comprising a tunnel to the first listing. The method also includes generating, in the second data exchange, a third listing, the third listing comprising data from the second listing and additional data from the second data provider.

公开(公告)号：US20240303252A1

公开(公告)日：2024-09-12

申请号：US18668578

申请日：2024-05-20

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Sameer Deshpande ,  Subramanian Muralidhar ,  Di Wu

IPC: G06F16/27 ,  G06F16/182 ,  G06F16/245

CPC classification number: G06F16/273 ,  G06F16/1844 ,  G06F16/245

Abstract: Techniques for database replication include a method performed by at least one hardware processor of a resource management node. The method includes detecting a request that a database instance of a database stored at a first network deployment is available at a second network deployment. Responsive to the request, the second network deployment is provisioned with a plurality of data objects. A first data object of the plurality of data objects includes a database shell. The database shell is reconfigured as the database instance of the database based on pushing data of the database into the database shell. Access to the database instance at the second network deployment is authorized based on at least a second data object of the plurality of data objects.

公开(公告)号：US20240273070A1

公开(公告)日：2024-08-15

申请号：US18652579

申请日：2024-05-01

Applicant: SNOWFLAKE INC.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  German Alberto Gil Echeverri ,  Prasanna Krishnan ,  Vishnu Dutt Paladugu ,  Bowen Zhang

IPC: G06F16/182 ,  G06F9/54 ,  G06F16/11 ,  G06F16/17

CPC classification number: G06F16/1844 ,  G06F9/546 ,  G06F16/128 ,  G06F16/1734 ,  G06F16/1827

Abstract: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes creating a share object for a first deployment of a data sharing platform. The share object includes share object metadata that describes access privileges in the first deployment. The method also includes creating, in a second deployment of the data sharing platform, a replica of the share object. The replica determines access privileges in the second deployment. The method also includes receiving, at the first deployment, a refresh message from the second deployment. The method also includes, in response to receiving the refresh message, transmitting the share object metadata from the first deployment to the second deployment and updating, by a processing device, the replica based on the share object metadata.

公开(公告)号：US12050711B2

公开(公告)日：2024-07-30

申请号：US18378575

申请日：2023-10-10

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Benoit Dageville ,  Shreyas Narendra Desai ,  Subramanian Muralidhar ,  Bowen Zhang

IPC: G06F21/62 ,  G06F16/21 ,  G06F16/25

CPC classification number: G06F21/6218 ,  G06F16/21 ,  G06F16/256 ,  G06F2221/2141

Abstract: Embodiments of the present disclosure relate to sharing data using database roles. Database roles are generated within a database container of a provider account. Grants to a particular subset of the plurality of data objects of the database container may be assigned to each of the database roles, and each of the database roles are granted to a share object. The share object is mounted within a consumer account to generate an imported copy of each of the database roles. The imported copy of one or more of the database roles is granted to each of one or more account level roles of the consumer account. When a new object is added to a particular database role, it is immediately available for consumption by any account level roles to which the imported copy of the particular database role has been granted.

公开(公告)号：US20240232226A1

公开(公告)日：2024-07-11

申请号：US18617083

申请日：2024-03-26

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Florian Andreas Funke ,  Peter Povinec

IPC: G06F16/28 ,  G06F9/50 ,  G06F16/2455 ,  H04L41/0896 ,  H04L41/5025 ,  H04L43/0817 ,  H04L67/1008 ,  H04L67/1097

CPC classification number: G06F16/283 ,  G06F9/5072 ,  G06F16/2455 ,  H04L41/0896 ,  H04L41/5025 ,  H04L67/1008 ,  H04L67/1097 ,  H04L43/0817

Abstract: A method implementing a fault-tolerant data warehouse including allocating a plurality of processing units to a data warehouse, the processing units located in different availability zones, an availability zone comprising one or more data centers. The method further includes, as a result of monitoring a number of queries running at an input degree of parallelism on the plurality of processing units of the data warehouse, determining that the number of queries is serviceable by one fewer processing units. The method further includes routing a query from a first processing unit to a second processing unit within the data warehouse, the query having a common session identifier with another query previously provided to the second processing unit, the second processing unit determined to be caching a data segment associated with a cloud storage resource, usable by the query, and removing the first processing unit from the data warehouse.

公开(公告)号：US12032588B2

公开(公告)日：2024-07-09

申请号：US18160802

申请日：2023-01-27

Applicant: SNOWFLAKE INC.

Inventor： Pui Kei Johnston Chu ,  Benoit Dageville ,  Matthew J. Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: G06F16/21 ,  G06F16/2455 ,  G06F16/25 ,  G06F21/62

CPC classification number: G06F16/254 ,  G06F16/21 ,  G06F16/2456 ,  G06F21/6218

Abstract: A method includes creating, by a first provider, a first listing referencing first shared data and comprising first access controls, wherein access to the first shared data by a second provider is filtered based on the first access controls, creating, by the second provider, a second listing referencing second shared data and the first shared data filtered based on the first access controls, and adding the second listing to a catalog in a data exchange, the catalog comprising metadata describing the second shared data.

公开(公告)号：US20240168938A1

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

申请号：US18427786

申请日：2024-01-30

Applicant: Snowflake Inc.

Inventor： Subramanian Muralidhar ,  Istvan Cseri ,  Torsten Grabs ,  Benoit Dageville

IPC: G06F16/23 ,  G06F9/46 ,  G06F16/18 ,  G06F16/245 ,  G06F16/27

CPC classification number: G06F16/2358 ,  G06F16/1865 ,  G06F16/2322 ,  G06F16/2365 ,  G06F16/245 ,  G06F16/278 ,  G06F9/466

Abstract: A system includes one or more processors configured as a change tracking manager, and data storage containing instructions executable by the one or more processors. A table data component of the change tracking manager stores table data for a database in a plurality of partitions. A transaction data component of the change tracking manager generates a change tracking entry based on executing a transaction on the table data. The change tracking entry includes information on at least one modification made to a first table version storing the table data. A change tracking component of the change tracking manager generates a change tracking stream associated with the at least one modification. The change tracking component updates a second table version to include the change tracking stream. The second table version includes modified table data based on completing execution of the transaction on the table data in the first table version.