公开(公告)号：US20230007074A1

公开(公告)日：2023-01-05

申请号：US17940436

申请日：2022-09-08

Applicant: SNOWFLAKE INC.

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

IPC: H04L67/10 ,  H04L41/50 ,  H04L67/51 ,  H04L9/40

Abstract: Sharing data in a data exchange across multiple cloud computing platforms and/or cloud computing platform regions is described. An example method can include generating a consumer account corresponding to a first cloud entity and receiving, by the first cloud entity, a copy of a data set from a provider account corresponding to a second cloud computing entity, wherein the first cloud computing entity and the second cloud computing entity represent different regions of a cloud computing platform. The method may also include accessing, by the consumer account, the copy of the data set.

公开(公告)号：US11470089B2

公开(公告)日：2022-10-11

申请号：US17666473

申请日：2022-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

Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include executing one or more queries against data referenced by a data listing of a data exchange, the data exchange comprising a plurality of data listings provided by one or more data providers, gathering consumer information based on the one or more queries, assigning privileges that grant access to the consumer information to a share object, in response to the share object being added to a list of consumed share objects of a data provider that provided the data listing, generating a database that references the consumer information based on the share object, and granting access to the database to the data provider that provided the data listing.

公开(公告)号：US11461285B2

公开(公告)日：2022-10-04

申请号：US17694335

申请日：2022-03-14

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. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.

公开(公告)号：US11418577B1

公开(公告)日：2022-08-16

申请号：US17709689

申请日：2022-03-31

Applicant: SNOWFLAKE INC.

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

IPC: G06F15/173 ,  H04L67/10 ,  H04L9/40 ,  H04L41/50 ,  H04L67/51

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.

公开(公告)号：US20220197872A1

公开(公告)日：2022-06-23

申请号：US17694335

申请日：2022-03-14

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. For example, the method may include generating a global representation of a share object of a first database account located in a first region. The share object includes grant metadata associated with a set of objects of a database located in the first region and associated with the first database account. The method may further include, in response to a database refresh command received from a second database account associated with a database replica located in a second region, replicating the set of objects of the database to the database replica. The method may further include, in response to a share refresh command received from the second database account, replicating the grant metadata to a share object replica located in the second region.

公开(公告)号：US20220159007A1

公开(公告)日：2022-05-19

申请号：US17666473

申请日：2022-02-07

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Matthew Glickman ,  Christian Kleinerman ,  Prasanna Krishnan ,  Justin Langseth

IPC: H04L9/40 ,  H04L51/00 ,  G06F16/2455 ,  H04L41/22 ,  H04L67/1097

Abstract: Providing access to metrics on a private data exchange is described. An example computer-implemented method can include executing one or more queries against data referenced by a data listing of a data exchange, the data exchange comprising a plurality of data listings provided by one or more data providers, gathering consumer information based on the one or more queries, assigning privileges that grant access to the consumer information to a share object, in response to the share object being added to a list of consumed share objects of a data provider that provided the data listing, generating a database that references the consumer information based on the share object, and granting access to the database to the data provider that provided the data listing.

公开(公告)号：US11323506B2

公开(公告)日：2022-05-03

申请号：US17378562

申请日：2021-07-16

Applicant: SNOWFLAKE INC.

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

IPC: G06F15/173 ,  H04L67/10 ,  H04L29/06 ,  H04L41/50 ,  H04L67/51 ,  G06F16/23 ,  G06F21/62 ,  H04L67/1097 ,  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 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.

公开(公告)号：US11294868B2

公开(公告)日：2022-04-05

申请号：US17459334

申请日：2021-08-27

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. For example, the method may comprise modifying a share object of a first account of a data exchange into a global object wherein the share object includes grant metadata indicating share grants to a set of objects of a database. The method may further comprise creating, in a second account of the data exchange, a local replica of the share object on the remote deployment based on the global object, wherein the second account is located in a remote deployment. The set of objects of the database may be replicated to a local database replica on the remote deployment and the share grants may be replicated to the local replica of the share object.

公开(公告)号：US20210374159A1

公开(公告)日：2021-12-02

申请号：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

IPC: G06F16/27 ,  G06F16/23 ,  G06Q30/00 ,  G06F16/22 ,  G06Q30/02

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.

公开(公告)号：US20210266325A1

公开(公告)日：2021-08-26

申请号：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.