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

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

公开(公告)号：US12008001B2

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

申请号：US17804434

申请日：2022-05-27

Applicant: Snowflake Inc.

Inventor： Matthew J. Glickman ,  Orestis Kostakis ,  Justin Langseth

IPC: G06F16/245 ,  G06F16/24 ,  G06F16/242 ,  G06F16/2455

CPC classification number: G06F16/24568 ,  G06F16/244 ,  G06F16/2456 ,  G06F16/24564

Abstract: Systems, methods, and machine-readable storage devices provide for identifying a user dataset on a distributed database. The system includes generating a similarity score dataset that indicates a similarity between the user dataset and a plurality of datasets of other users of the distributed database. The system generates a plurality of overlap queries that are configured to output overlap datasets between the user dataset and one or more of the plurality of datasets. The system further generates a results dataset by applying one or more of the plurality of overlap queries to a joined dataset comprising data from the user dataset and one of the plurality of datasets of other users on the distributed database.

公开(公告)号：US11843608B2

公开(公告)日：2023-12-12

申请号：US18184145

申请日：2023-03-15

Applicant: SNOWFLAKE INC.

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

IPC: H04L29/06 ,  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: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes generating a plurality of listings in a data exchange, each of the plurality of listings comprising version metadata and referencing a data set within a database. The method further includes receiving a request for access to a first listing of the plurality of listings and, in response to the request, accessing a first version of the data set that is compatible with first version metadata of the first listing.

公开(公告)号：US20230385284A1

公开(公告)日：2023-11-30

申请号：US17804434

申请日：2022-05-27

Applicant: Snowflake Inc.

Inventor： Matthew J. Glickman ,  Orestis Kostakis ,  Justin Langseth

IPC: G06F16/2455 ,  G06F16/242

CPC classification number: G06F16/24568 ,  G06F16/2456 ,  G06F16/244 ,  G06F16/24564

Abstract: Systems, methods, and machine-readable storage devices provide for identifying a user dataset on a distributed database. The system includes generating a similarity score dataset that indicates a similarity between the user dataset and a plurality of datasets of other users of the distributed database. The system generates a plurality of overlap queries that are configured to output overlap datasets between the user dataset and one or more of the plurality of datasets. The system further generates a results dataset by applying one or more of the plurality of overlap queries to a joined dataset comprising data from the user dataset and one of the plurality of datasets of other users on the distributed database.

公开(公告)号：US20230169087A1

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

申请号：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/25 ,  G06F21/62 ,  G06F16/2455

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

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.

公开(公告)号：US20230004672A1

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

申请号：US17900759

申请日：2022-08-31

Applicant: SNOWFLAKE INC.

Inventor： Justin Langseth ,  Matthew J. Glickman ,  Christian Kleinerman ,  Robert Muglia ,  Daniel Freundel ,  Thierry Cruanes ,  Allison Waingold Lee

IPC: G06F21/62 ,  G06F16/2455 ,  H04L9/32

Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The secure UDF returns a count of matching data points between the consumer account and the provider account, and the method provides the count of matching data points to the consumer account.

公开(公告)号：US11531681B2

公开(公告)日：2022-12-20

申请号：US17704783

申请日：2022-03-25

Applicant: Snowflake Inc.

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

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

Abstract: A method for accessing listings in a data exchange includes creating a first listing in a data exchange, the first listing referencing a first database of a plurality of databases and specifying identity-based sharing of the first database, creating a second listing in the data exchange, the second listing referencing a second database of the plurality of databases and data of the first database shared according to the identity-based sharing of the first database, and receiving an instruction from a user of the data exchange, the instruction referencing the second listing and instructing the addition of the second listing to a set of consumed data shares accessible by the user.

公开(公告)号：US20220327232A1

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

申请号：US17847681

申请日：2022-06-23

Applicant: SNOWFLAKE INC.

Inventor： Justin Langseth ,  Matthew J. Glickman ,  Christian Kleinerman ,  Robert Muglia ,  Daniel Freundel ,  Thierry Cruanes ,  Allison Waingold Lee

IPC: G06F21/62 ,  G06F16/2455 ,  H04L9/32

Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method creates a secure view of datapoints of a consumer account and processes, using a secure user defined function (UDF), the datapoints of the consumer account and datapoints of a provider account to generate a secure join key. The datapoints of the consumer account are provided to the secure UDF using the secure view. The method further performs, by a processor, an analysis of the datapoints of the consumer account and the datapoints of the provider account of the secure join key. The analysis returns a count value of overlapping datapoints between the consumer account and the provider account. The method further adjusts the count value of overlapping datapoints based on a number of distinct rows associated with the provider account, and provides the adjusted count value of overlapping datapoints to the consumer account.

公开(公告)号：US20220217150A1

公开(公告)日：2022-07-07

申请号：US17702115

申请日：2022-03-23

Applicant: SNOWFLAKE INC.

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

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

Abstract: Systems and methods for managing membership in a private data exchange are provided herein. In one embodiment, the method includes generating a plurality of listings in a data exchange. A first listing of the plurality of listings may include a reference to a first version of shared data within a first database, where the first version is one of a plurality of versions of the shared data within the first database. The method further includes receiving a request from a member of the data exchange for access to the first listing and limiting, by a processing device, access for the member to the first version of the shared data of the first database referenced by the first listing.