公开(公告)号：US20200380007A1

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

申请号：US16428592

申请日：2019-05-31

Applicant: Snowflake Inc.

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

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

Abstract: A data warehouse storing databases for a plurality of users, including service providers hosting data for other users of the data warehouse may implement a data exchange. A provider of data creates a listing in the exchange including metadata. A consumer browses the metadata and select a listing to add to consumed shares of the consumer. Browsing may be filtered to implement a private exchange. Adding of data may be limited by access controls requiring verification of the consumer's identity. The added data may be filtered to include only data that relates to the consumer. Sharing may be bi-directional such that a request to add a listing for first data of a provider may also reference second data of the consumer such that the first data is added to the consumed shares of the consumer and the second data is added to the consumed shares of the provider.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US12093284B2

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

申请号：US18295987

申请日：2023-04-05

Applicant: Snowflake Inc.

Inventor： Pui Kei Johnston Chu ,  Shreyas Narendra Desai ,  German Alberto Gil Echeverri ,  Prasanna Krishnan ,  Nithin Mahesh ,  Subramanian Muralidhar ,  Eric Robinson ,  Sahaj Saini

IPC: G06F16/00 ,  G06F16/22 ,  G06F16/23 ,  G06F16/27 ,  G06Q30/018 ,  G06Q30/0204

CPC classification number: G06F16/275 ,  G06F16/2282 ,  G06F16/2379 ,  G06Q30/0185 ,  G06Q30/0205

Abstract: A system for sub-table replication within a materialized view of a source data table. A materialized view of a source data table is generated based on a query, the source data table having a plurality of data table rows associated with a plurality of client identifiers and including an entitlements column and data content, the entitlements column including a plurality of provider account identifiers and a plurality of consumer account identifiers. An update to an entitlements table of the source data table is detected where the entitlements table includes a plurality of entitlements table rows and where the entitlements table rows are associated with the client identifiers, the consumer account identifiers, and the provider account identifiers. An update to the source data table based on the first update to the entitlements table is detected, and an incremental replication of the materialized view of the source data table is performed.

公开(公告)号：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.

公开(公告)号：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.

公开(公告)号：US11973763B1

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

申请号：US18127576

申请日：2023-03-28

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Pui Kei Johnston Chu ,  Unmesh Jagtap ,  Xiaodi Ke ,  Subramanian Muralidhar ,  James Pan

IPC: H04L9/40 ,  G06F11/07 ,  G06F16/23 ,  H04L67/125 ,  H04L67/30

CPC classification number: H04L63/102 ,  G06F11/079 ,  G06F16/235 ,  H04L67/125 ,  H04L67/30

Abstract: Embodiments of the present disclosure provide a region-specific events account that is used as a central place to store the events shared by consumers of shared applications in that region. Use of such an account helps reduce the operational burden of a provider of the applications as they do not need to determine which accounts have shared events for each different consumer. The provider only needs to login to the events account which is in the same region as the consumer and can query all shared events from different applications that are being used in that region. Also, since the provider can designate an events account in each region, the shared events could be directly ingested into the events account without traveling to a different region.