-
公开(公告)号:US20240129360A1
公开(公告)日:2024-04-18
申请号:US18493606
申请日:2023-10-24
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
CPC classification number: H04L67/10 , G06F16/2379 , G06F21/6272 , H04L41/5096 , H04L63/0272 , H04L63/10 , H04L63/101 , H04L67/1097 , H04L67/51 , H04L67/53
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 creating a listing in a data exchange, the listing including a data set hosted by a first cloud computing entity. The data set can be shared with a second cloud computing entity. The method further includes receiving a request associated with a customer account of the second cloud computing entity to access the data set of the listing hosted by the first cloud computing entity and replicating at least a subset of the data set of the listing from the first cloud computing entity to a provider account at the second cloud computing entity to be accessible by the customer account at the second cloud computing entity.
-
公开(公告)号:US20240056453A1
公开(公告)日:2024-02-15
申请号:US18369404
申请日:2023-09-18
Applicant: SNOWFLAKE INC.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC: H04L9/40 , G06F16/2455 , H04L41/22 , H04L67/1097 , H04L51/212 , G06F21/60 , G06F21/62
CPC classification number: H04L63/102 , H04L63/101 , G06F16/2455 , H04L41/22 , H04L67/1097 , H04L51/212 , G06F21/606 , G06F21/6218
Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes receiving a request for access to a first listing of a data exchange, each listing of the data exchange comprising version metadata. The method further includes, in response to the request, accessing a first version of a data set referenced by the first listing, wherein the first version of the data set comprises a first structure defined by first version metadata, a second listing of the data exchange references a second version of the data set, the second version of the data set comprising a second structure defined by second version metadata, and the second structure is incompatible with the first structure.
-
公开(公告)号:US20230244642A1
公开(公告)日:2023-08-03
申请号:US18134186
申请日:2023-04-13
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
CPC classification number: G06F16/1844 , G06F16/128 , G06F9/546 , G06F16/1827 , G06F16/1734
Abstract: Provided herein are systems and methods for replicating share objects to remote deployments. An example method includes generating, at a second deployment in a data exchange, a replica of a share object included in a first deployment of the data exchange. The share object grants privileges to a first account to access a first database of the first deployment, wherein the first database comprises a database object. The method also includes retrieving, at the first deployment, share grant metadata from the share object of the first deployment, wherein the share grant metadata includes a reference to the database object and allows the first account to use the database object. The method also includes transmitting a message comprising the share grant metadata to the replica in the second deployment. The share grant metadata in the replica allows a second account to use the database object replicated in the second deployment.
-
公开(公告)号:US11372891B2
公开(公告)日:2022-06-28
申请号:US17226141
申请日:2021-04-09
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 then 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.
-
公开(公告)号:US11308116B2
公开(公告)日:2022-04-19
申请号:US17015485
申请日:2020-09-09
Applicant: Snowflake, Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
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. The data warehouse to verify identity of users and execute instructions with respect to databases of the data warehouse.
-
公开(公告)号:US10798100B1
公开(公告)日:2020-10-06
申请号:US16746758
申请日:2020-01-17
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method comprises adding a new member to a data exchange, wherein the data exchange comprises a set of listings, each listing comprising data from one or more datasets stored on a cloud computing service. An account type is assigned to the new member, the account type comprising at least one of a consumer type, provider type, or exchange administrator type. Each of the account types associated with one or more rights with respect to the set of listings, such that the new member has a set of rights based on the account type. The set of rights of the new member are then modified with respect to one or more listings from the set of listings based on a set of visibility and access rules for each of the set of listings.
-
公开(公告)号:US11838293B2
公开(公告)日:2023-12-05
申请号:US18106901
申请日:2023-02-07
Applicant: Snowflake Inc.
Inventor: Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC: H04L9/40 , G06F16/2455 , H04L41/22 , H04L67/1097 , H04L51/212 , G06F21/60 , G06F21/62
CPC classification number: H04L63/102 , G06F16/2455 , G06F21/606 , G06F21/6218 , H04L41/22 , H04L51/212 , H04L63/101 , H04L67/1097
Abstract: Providing access to consumer information on a private data exchange is described. In an example, privileges are assigned to a share object, granting access to consumer information obtained from a query against data referenced by a data listing of a data exchange. The data exchange comprises one or more data listings provided by one or more data providers. In response to the share object being added to a list of consumed share objects of a data provider that provided the data listing, a database is generated that references the consumer information based on the share object. Access to the database is granted to the data provider that provided the data listing.
-
公开(公告)号:US20230362235A1
公开(公告)日:2023-11-09
申请号:US18222770
申请日:2023-07-17
Applicant: Snowflake Inc.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
CPC classification number: H04L67/10 , H04L63/0272 , H04L41/5096 , G06F16/2379 , G06F21/6272 , H04L63/101 , H04L67/1097 , H04L67/51 , H04L67/53 , H04L63/10
Abstract: Sharing data in a data exchange across multiple cloud computing platforms is described. An example method can include 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 then copying, to a third cloud computing entity using a consumer account of the third cloud computing entity, a second subset of the data set, wherein the provider account of the third cloud computing entity does not have access to the first cloud computing entity, for which the first subset of the data set is different from the second subset of the data set.
-
公开(公告)号:US11810089B2
公开(公告)日:2023-11-07
申请号:US17148384
申请日:2021-01-13
Applicant: Snowflake Inc.
Inventor: Matthew Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth , Benoit Dageville
CPC classification number: G06Q20/1235 , G06F16/22 , G06F21/6218 , G06Q20/127 , G06Q40/04 , H04L63/0414
Abstract: A method includes receiving, from a client device, a request to access data of a data exchange platform. The method further includes receiving a selection corresponding to a monetization option for the data. The method further includes executing, by one or more processors, a monetization operation corresponding to the selection without directing the client device outside of the data exchange platform. The method further includes granting the client device access to the data of the data exchange platform in response to successfully performing the monetization operation.
-
公开(公告)号:US20230244695A1
公开(公告)日:2023-08-03
申请号: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/27 , G06F16/23 , G06F16/22 , 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.
-
-
-
-
-
-
-
-
-