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

公开(公告)号：US10713380B1

公开(公告)日：2020-07-14

申请号：US16708067

申请日：2019-12-09

Applicant: Snowflake Inc.

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

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

Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method includes determining data stored in a first account to be compared with data stored in a second account. The method includes determining a function for generating a secure join key, wherein the secure join key includes a hashed string that hashes one or more of a data entry of the first account and a data entry of the second account. The method includes providing the secure join key to the first account and/or the second account.

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

公开(公告)号：US20250013648A1

公开(公告)日：2025-01-09

申请号：US18892783

申请日：2024-09-23

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/242 ,  G06F16/27 ,  G06F21/62

Abstract: Disclosed herein are systems and methods for query processing with restrictions in a database clean room. In an embodiment, a system receives a query directed to a combination of a first source dataset from a first database account of a distributed database and a second source dataset from a second database account of the distributed database. The system generates an approved statements table that contains database statement language that can be executed against the combination of the first and second source datasets. Based on determining that the approved statements table includes the query, the system executes the query to produce results data, and stores the results data in the first database account.

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

公开(公告)号：US20240168958A1

公开(公告)日：2024-05-23

申请号：US18425312

申请日：2024-01-29

Applicant: Snowflake Inc.

Inventor： Rachel Frances Blum ,  Justin Langseth ,  Michael Earle Rainey

IPC: G06F16/2455 ,  G06F16/242 ,  G06F16/27 ,  G06F21/62

CPC classification number: G06F16/24565 ,  G06F16/2443 ,  G06F16/27 ,  G06F21/6227

Abstract: Disclosed herein are systems and methods for query processing with restrictions in a database clean room. In an embodiment, a system receives a query directed to a combination of a first source dataset from a first database account of a distributed database and a second source dataset from a second database account of the distributed database. The system generates an approved statements table that contains database statement language that can be executed against the combination of the first and second source datasets. Based on determining that the approved statements table includes the query, the system executes the query to produce results data, and stores the results data in the first database account.

公开(公告)号：US11934553B2

公开(公告)日：2024-03-19

申请号：US17390935

申请日：2021-07-31

Applicant: Snowflake Inc.

Inventor： Justin Langseth ,  Michael Earle Rainey

IPC: G06F21/62 ,  G06F16/245 ,  G06F16/25 ,  G06F16/27 ,  G06F21/60

CPC classification number: G06F21/6227 ,  G06F16/245 ,  G06F16/258 ,  G06F16/27 ,  G06F21/602

Abstract: Embodiments of the present disclosure may provide a data clean room allowing encryption based data analysis across multiple accounts of different database users. The data clean room may also restrict which data may be used in the analysis and may restrict the output. A requesting user's data can be encrypted using a key and a provider user can generate a shareable database function that accepts the key to decrypt the data to generate the results data without exposing each others' data.