-
公开(公告)号:US11461493B1
公开(公告)日:2022-10-04
申请号: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: H04L29/06 , 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.
-
公开(公告)号:US11190524B2
公开(公告)日:2021-11-30
申请号: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.
-
公开(公告)号:US11188670B2
公开(公告)日:2021-11-30
申请号:US16368339
申请日:2019-03-28
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 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.
-
公开(公告)号:US20210279359A1
公开(公告)日:2021-09-09
申请号:US17321327
申请日:2021-05-14
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 includes creating a secure view of datapoints of a consumer account and processing, 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 join key comprises a hash string of the datapoints of the provider account and the datapoints of the consumer account, and wherein the datapoints of the consumer account are processed via the secure view. The method further includes executing a consumer function to analyze the hash string of datapoints of the secure join key for common data points.
-
公开(公告)号:US10977268B2
公开(公告)日:2021-04-13
申请号:US16428592
申请日:2019-05-31
Applicant: Snowflake Inc.
Inventor: Justin Langseth , Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan
IPC: G06F16/2455 , G06F16/25 , 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.
-
公开(公告)号: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.
-
公开(公告)号:US12229424B2
公开(公告)日:2025-02-18
申请号:US18162692
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Christopher Peter Child , Matthew J. Glickman , Justin Langseth
IPC: G06F3/06 , G06F16/2457 , G06F16/248 , G06F16/25 , G06F16/28 , G06F21/31 , G06F21/62
Abstract: A request to share cloud data associated with a first account in a database system with an application is received. Based on the request, second-party application data and third-party data that is accessible by the first account is identified. The second-party application data comprises application data corresponding to a second application provided by a second-party application provider. The third-party data corresponds to a second account maintained by the database system. The second account corresponds to a third-party data provider. The application is enabled to access the cloud data associated with the first account based on the request. The cloud data comprises customer data associated with the first account, second-party application data, and the third-party data.
-
公开(公告)号:US12021877B2
公开(公告)日:2024-06-25
申请号:US18369404
申请日:2023-09-18
Applicant: SNOWFLAKE INC.
Inventor: Pui Kei Johnston Chu , Benoit Dageville , Matthew J. Glickman , Christian Kleinerman , Prasanna Krishnan , Justin Langseth
IPC: H04L29/06 , G06F16/2455 , G06F21/60 , G06F21/62 , H04L9/40 , 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 receiving a request for access to a first listing of a data exchange, each listing of the data exchange comprising version metadata. The method further includes, in response to the request, accessing a first version of a data set referenced by the first listing, wherein the first version of the data set comprises a first structure defined by first version metadata, a second listing of the data exchange references a second version of the data set, the second version of the data set comprising a second structure defined by second version metadata, and the second structure is incompatible with the first structure.
-
公开(公告)号:US20230385286A1
公开(公告)日:2023-11-30
申请号:US18162688
申请日:2023-01-31
Applicant: Snowflake Inc.
Inventor: Matthew J. Glickman , Orestis Kostakis , Justin Langseth
IPC: G06F16/2455 , G06F16/242
CPC classification number: G06F16/24568 , G06F16/24564 , G06F16/244 , G06F16/2456
Abstract: A system for generating similarity data for different datasets in a cloud data platform. A first dataset of a plurality of datasets on the cloud data platform is identified, where the first dataset is associated with a first user of the cloud data platform. A semantic type for each feature the first dataset is identified, and each semantic type for the first dataset is compared with existing data of the first user. Semantic types for each feature of each dataset are identified, and each semantic type for the first dataset is compared to each semantic type of each dataset. Overlap requests are generated to output overlap datasets between the first dataset and each of the plurality of datasets. A results dataset is generated by applying the overlap requests to a joined dataset comprising data from the first dataset and data from each of the plurality of datasets.
-
-
-
-
-
-
-
-
-