-
公开(公告)号:US20220405252A1
公开(公告)日:2022-12-22
申请号:US17895823
申请日:2022-08-25
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 , G06F16/11 , G06F9/54 , G06F16/17
Abstract: Provided herein are systems and methods for an efficient method of replicating share objects to remote deployments. An example method includes receiving, at a first deployment in a data exchange, a refresh message from a second deployment in the data exchange, wherein the first deployment comprises a database that stores a database object. The method also includes, in response to receiving the refresh message, retrieving, at the first deployment, a share grant from a share object of the first deployment and transmitting, by a processing device of the first deployment, a message including the share grant to the second deployment. The share grant includes a reference to the database object and allows a consumer to use the database object.
-
公开(公告)号:US11436257B2
公开(公告)日:2022-09-06
申请号:US17352044
申请日:2021-06-18
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
Abstract: A method of implementing sub-table replication starts with the processor detecting an update to an entitlements table. The processor performs filtering of a data table based on the update to the entitlements table. The data table including an entitlements column. The processor detects an update to the entitlements column and performs incremental replication of the data table by causing a version-based replication to be executed. Other embodiments are also described herein.
-
公开(公告)号:US11265328B2
公开(公告)日:2022-03-01
申请号:US16746764
申请日:2020-01-17
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC: H04L29/06 , H04L12/58 , G06F16/2455 , H04L12/24 , H04L29/08 , H04L51/00 , H04L41/22 , H04L67/1097
Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include providing a data exchange by a cloud computing service on behalf of an entity. The data exchange may comprise several data listings provided by one or more data providers. The data listings reference one or more data sets stored in a data storage platform associated with the cloud computing service. The method may also include granting access the data listings, gathering consumer information based queries provided to data associated with the data listings, generating a new share comprising the consumer information, and granting access of the new share to the data provider that provided the data listing.
-
公开(公告)号:US11190524B2
公开(公告)日:2021-11-30
申请号:US17237416
申请日:2021-04-22
Applicant: SNOWFLAKE INC.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC: H04L29/06 , H04L12/58 , G06F16/2455 , H04L12/24 , H04L29/08
Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes adding a member to a data exchange. The data exchange comprises a set of listings. The method includes providing a set of rights to the member for accessing the set of listings and modifying the set of rights of the member with respect to a listing from the set of listings based on a set of access rules for the listing. The method further includes providing access to a portion of the data of the listing that is filtered based on the set of rights as modified.
-
公开(公告)号:US20210250400A1
公开(公告)日:2021-08-12
申请号:US17220887
申请日:2021-04-01
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example computer-implemented method can include receiving data sharing information from a data provider for sharing a data set in a data exchange from a first cloud computing entity to a set of second cloud computing entities. In response to receiving the data sharing information, the method may also include creating an account with each of the set of second cloud computing entities. The method may also further include sharing the data set from the first cloud computing entity with the set of second cloud computing entities using at least the corresponding account of that second cloud computing entity.
-
公开(公告)号:US10997210B1
公开(公告)日:2021-05-04
申请号:US16944983
申请日:2020-07-31
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
Abstract: A method of implementing sub-table replication starts with the processor detecting a first update to an entitlements table. The processor filters of a data table based on the first update. The processor then detects a second update to the entitlements table and performs incremental replication of the data table by causing a full inventory replication at a next refresh to be executed for provider accounts associated with the provider account identifiers in the entitlements table. Other embodiments are also described herein.
-
公开(公告)号:US10977268B2
公开(公告)日:2021-04-13
申请号:US16428592
申请日:2019-05-31
Applicant: Snowflake Inc.
Inventor: Justin Langseth , Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan
IPC: G06F16/2455 , G06F16/25 , 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.
-
公开(公告)号:US20210084104A1
公开(公告)日:2021-03-18
申请号:US16746764
申请日:2020-01-17
Applicant: Snowflake Inc.
Inventor: Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth , Benoit Dageville
IPC: H04L29/08 , G06F16/2455 , H04L12/24
Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include providing a data exchange by a cloud computing service on behalf of an entity. The data exchange may comprise several data listings provided by one or more data providers. The data listings reference one or more data sets stored in a data storage platform associated with the cloud computing service. The method may also include granting access the data listings, gathering consumer information based queries provided to data associated with the data listings, generating a new share comprising the consumer information, and granting access of the new share to the data provider that provided the data listing.
-
公开(公告)号:US20210081439A1
公开(公告)日:2021-03-18
申请号:US16746673
申请日:2020-01-17
Applicant: Snowflake Inc.
Inventor: Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth , Pui Kei Johnston Chu , Benoit Dageville
IPC: G06F16/28 , G06F16/2458 , G06F16/2457 , G06F9/50
Abstract: Providing a private data exchange is described. An example computer-implemented method can include providing a data exchange by a cloud computing service on behalf of an entity. The data exchange may comprise several data listings provided by one or more data providers. The data listings reference one or more data sets stored in a data storage platform associated with the cloud computing service. The method may also include designating a data exchange administrator account of the data exchange. The data exchange administrator account may be associated with the entity and may be capable of: granting and denying requests from data consumers to access the data exchange; and granting and denying requests from data providers to publish data listings on the data exchange.
-
公开(公告)号: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.
-
-
-
-
-
-
-
-
-