公开(公告)号：US20240028597A1

公开(公告)日：2024-01-25

申请号：US18480028

申请日：2023-10-03

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.

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

公开(公告)号：US11816248B2

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

申请号：US18162701

申请日：2023-01-31

Applicant: Snowflake Inc.

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

IPC: G06F21/00 ,  G06F21/62 ,  G06F16/245 ,  G06F16/27

CPC classification number: G06F21/6254 ,  G06F16/245 ,  G06F16/27

Abstract: A distributed database generates a cross reference table that cross references a first dataset from a first database account and a second dataset from a second database account. The distributed database receives a query directed to a combination of the first and second datasets, and generates an interim table in the first database account by applying the query to the cross reference table and the first dataset. The distributed database generates results data in the second database account by applying the query to the interim table and the second dataset, and stores the results data in the first database account.

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

IPC: H04L67/10 ,  H04L9/40 ,  H04L41/50 ,  G06F16/23 ,  G06F21/62 ,  H04L67/1097 ,  H04L67/51 ,  H04L67/53

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

IPC: G06Q20/00 ,  G06Q20/12 ,  G06F16/22 ,  G06F21/62 ,  H04L9/40 ,  G06Q40/04

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.

公开(公告)号：US20230177055A1

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

申请号：US18161541

申请日：2023-01-30

Applicant: Snowflake Inc.

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

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

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

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.

公开(公告)号：US20230169200A1

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

申请号：US18153082

申请日：2023-01-11

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

CPC classification number: G06F21/6227 ,  G06F16/2456 ,  H04L9/3242

Abstract: Systems, methods, and devices for generating a secure join of database data are disclosed. A method generates a secure user defined function (UDF) that includes a one-way hash. The method uses the secure UDF to convert datapoints of a first account and datapoints of a second account into a secure join key, which is unidentifiable to the first account and the second account based on the one-way hash. The method then determines a count value of overlapping datapoints between the first account and the second account based on the secure join key.

公开(公告)号：US20230169198A1

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

申请号：US17538785

申请日：2021-11-30

Applicant: Snowflake Inc.

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

IPC: G06F21/62 ,  G06F16/27

CPC classification number: G06F21/6227 ,  G06F16/27

Abstract: Embodiments of the present disclosure may provide a data clean room architecture that dynamically restricts data included in the clean room. The data clean room architecture can implement row access policy or dynamic data masking for row and column based restrictions of data provided through the clean room. The data clean room architecture can provide a limited set of data that does not require obfuscation of data for direction matching and correlation of data in the different datasets, such as matching user identifiers or emails.

公开(公告)号：US11501015B2

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

申请号：US17644732

申请日：2021-12-16

Applicant: Snowflake Inc.

Inventor： Monica J. Holboke ,  Justin Langseth ,  Stuart Ozer ,  William L. Stratton, Jr.

IPC: G06F21/62 ,  G06F16/28 ,  G06N20/00 ,  G06K9/62 ,  G06F16/25

Abstract: A secure machine learning system of a database system can be implemented to use secure shared data to train a machine learning model. To manage the model, a first user of the database can share data in an encrypted view with a second user of the database, and further share one or more functions of an application that accesses the data while the data is encrypted. The second user can access functions of the application and can call the functions to generate a trained machine learning model and further generate machine learning outputs (e.g., predictions) from the trained model.

公开(公告)号：US20220350922A1

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

申请号：US17644722

申请日：2021-12-16

Applicant: Snowflake Inc.

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

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

Abstract: Embodiments of the present disclosure may provide a data clean room allowing secure data analysis across multiple accounts and across different regions and cloud providers. The data clean room may also restrict which data may be used in the analysis and may restrict the output. The overlap data may be anonymized to prevent sensitive information from being revealed. A version of a provider account can be created that is similar to a client account, such as in the same cloud type or the same region as the client database account. The client account can share data that is replicated to the provider account to complete client requests using an anonymized data and the cross reference table.