公开(公告)号：US20240346017A1

公开(公告)日：2024-10-17

申请号：US18643760

申请日：2024-04-23

Applicant: Snowflake Inc.

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

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

CPC classification number: G06F16/242 ,  G06F16/2456 ,  G06F16/27

Abstract: Embodiments of the present disclosure may provide a data sharing system implemented as a local application of a distributed database. A query from a query template can be validated and executed against shared dataset that comprises portions of data from the database dataset and additional portions of data from another database of the distributed database.

公开(公告)号：US20240303366A1

公开(公告)日：2024-09-12

申请号：US18651570

申请日：2024-04-30

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.

公开(公告)号：US12067019B2

公开(公告)日：2024-08-20

申请号：US17538785

申请日：2021-11-30

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: 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.

公开(公告)号：US20240273417A1

公开(公告)日：2024-08-15

申请号：US18643787

申请日：2024-04-23

Applicant: Snowflake Inc.

Inventor： Orestis Kostakis ,  Justin Langseth

IPC: G06N20/00

CPC classification number: G06N20/00

Abstract: Embodiments of the present disclosure may provide a data sharing system implemented as a local application in a consumer database of a distributed database. The local application can include a training function and a scoring function to train a machine learning model on provider and consumer data, and generate output data by applying the trained machine learning model on input data. The input data can include data portions from a consumer database and a provider database that are joined to create a joined dataset for scoring.

公开(公告)号：US12001581B2

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

申请号：US18162705

申请日：2023-01-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: A first database account shares, with a second database account, a secure function configured to accept an encrypted dataset and a decryption parameter. The first database account includes a first dataset. The second database account includes a second dataset. The second database account selects one or more rows and one or more columns of the second dataset as a searchable dataset, generates an encrypted searchable dataset by encrypting the searchable dataset with a key, and calls the secure function with the encrypted searchable dataset and the key. The secure function generates results of a query by: generating a decrypted searchable dataset by decrypting the encrypted searchable dataset with the key in a secure environment, obtaining the results by executing the query against a combination of the first dataset and the decrypted dataset in the secure environment to generated query-results data, and outputting the results to the second database account.

公开(公告)号：US11989630B2

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

申请号：US18162697

申请日：2023-01-31

Applicant: Snowflake Inc.

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

IPC: G06N3/00 ,  G06F16/25 ,  G06F16/28 ,  G06F18/214 ,  G06F21/62 ,  G06N20/00

CPC classification number: G06N20/00 ,  G06F16/256 ,  G06F16/283 ,  G06F18/214 ,  G06F21/6227

Abstract: A system for providing access to a database management system (DBMS) to a first user of a cloud data platform, the DBMS being generated by a second user. A machine learning model for training on a training dataset is included in the DBMS. The training dataset includes a first training dataset that is encrypted in the DBMS and a second training dataset that includes non-overlapping features with the first training dataset. A request, from the second user, to train the machine learning model on the first and second training datasets is identified. A trained machine learning model is generated by training the machine learning model on a joined dataset according to the request. One or more outputs from the trained machine learning model are generated by applying the trained machine learning model on new data.

公开(公告)号：US11921898B2

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

申请号：US17661337

申请日：2022-04-29

Applicant: Snowflake Inc.

Inventor： Marcus A. Henderson ,  Justin Langseth ,  Jamie B. Pfeiffer, Jr.

IPC: G06F21/62 ,  G06F16/22 ,  G06F16/2455 ,  G06F21/60

CPC classification number: G06F21/6254 ,  G06F16/2282 ,  G06F16/24568 ,  G06F21/602

Abstract: Provided herein are systems and methods for identity resolution and data enrichment. An example method performed by at least one hardware processor includes detecting at an account of a data provider, an update to personally identifiable information (PII). The PII is stored in a source table managed by an account of a data consumer. An identity resolution process is performed based on detecting the update. The identity resolution process includes generating a secure identifier of a user associated with the PII. The method further includes generating at the account of the data provider, a result table including the secure identifier. The result table is shared with the account of the data consumer.

公开(公告)号：US20230351044A1

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

申请号：US17661337

申请日：2022-04-29

Applicant: Snowflake Inc.

Inventor： Marcus A. Henderson ,  Justin Langseth ,  Jamie B. Pfeiffer, JR.

IPC: G06F21/62 ,  G06F21/60 ,  G06F16/2455 ,  G06F16/22

CPC classification number: G06F21/6254 ,  G06F21/602 ,  G06F16/24568 ,  G06F16/2282

Abstract: Provided herein are systems and methods for identity resolution and data enrichment. An example method performed by at least one hardware processor includes detecting at an account of a data provider, an update to personally identifiable information (PII). The PII is stored in a source table managed by an account of a data consumer. An identity resolution process is performed based on detecting the update. The identity resolution process includes generating a secure identifier of a user associated with the PII. The method further includes generating at the account of the data provider, a result table including the secure identifier. The result table is shared with the account of the data consumer.

公开(公告)号：US11743324B2

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

申请号：US17940436

申请日：2022-09-08

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 ,  G06F16/23 ,  G06F21/62 ,  H04L67/1097 ,  H04L67/51 ,  H04L67/53

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 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.

公开(公告)号：US20230231853A1

公开(公告)日：2023-07-20

申请号：US18184145

申请日：2023-03-15

Applicant: SNOWFLAKE INC.

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

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

CPC classification number: G06F21/606 ,  G06F16/2455 ,  G06F21/6218

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.