公开(公告)号：US11568079B2

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

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

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.

公开(公告)号：US11386222B2

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

申请号：US17521348

申请日：2021-11-08

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 hashing datapoints of a consumer account and creating a secure view of the hashed datapoints of the consumer account. The method further includes processing, using a secure user defined function (UDF), the hashed datapoints of the consumer account and datapoints of a provider account to generate a secure join key, wherein the hashed data points of the consumer account are provided to the secure UDF using the secure view.

公开(公告)号：US11036881B2

公开(公告)日：2021-06-15

申请号：US16241463

申请日：2019-01-07

Applicant: Snowflake Inc.

Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

IPC: G06F21/62 ,  G06F21/78 ,  G06F16/245 ,  G06F16/22 ,  G06F21/60

Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes generating a share object in a first account comprising a share role. The method includes associating view privileges for the share object such that an underlying detail of the share object comprises a secure user-defined function definition. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account and providing a response to the second account based on the data or services of the first account. The method is such that the underlying detail of the share object that comprises the secure user-defined function definition is hidden from the second account and visible to the first account.

公开(公告)号：US20200327249A1

公开(公告)日：2020-10-15

申请号：US16902266

申请日：2020-06-16

Applicant: Snowflake Inc.

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

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

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.

公开(公告)号：US20200226281A1

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

申请号：US16836521

申请日：2020-03-31

Applicant: Snowflake Inc.

Inventor： Martin Hentschel ,  Allison Waingold Lee ,  Robert Muglia ,  Peter Povinec

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

Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes generating a share object in a first account comprising a share role. The method includes associating view privileges for the share object such that an underlying detail of the share object comprises a secure view definition. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account and providing a response to the second account based on the data or services of the first account. The method is such that the underlying detail of the share object that comprises the secure view definition is hidden from the second account and visible to the first account.

公开(公告)号：US12242636B2

公开(公告)日：2025-03-04

申请号：US17844601

申请日：2022-06-20

Applicant: SNOWFLAKE INC.

Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

IPC: G06F21/62 ,  G06F16/22 ,  G06F16/245 ,  G06F21/78

Abstract: Systems, methods, and devices for implementing secure user-defined function (UDF) in a multi-tenant database system are disclosed. A method includes receiving a grant to access a share object comprising usage functionality associated with a secure UDF to underlying data. The method includes accessing the share object using the grant. The method includes causing a share component to implement the secure view and the usage functionality associated with the secure UDF.

公开(公告)号：US20220318419A1

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

申请号：US17844601

申请日：2022-06-20

Applicant: SNOWFLAKE INC.

Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

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

Abstract: Systems, methods, and devices for implementing secure user-defined function (UDF) in a multi-tenant database system are disclosed. A method includes receiving a grant to access a share object comprising usage functionality associated with a secure UDF to underlying data. The method includes accessing the share object using the grant. The method includes causing a share component to implement the secure view and the usage functionality associated with the secure UDF.

公开(公告)号：US20220114277A1

公开(公告)日：2022-04-14

申请号：US17559226

申请日：2021-12-22

Applicant: SNOWFLAKE INC.

Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

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

Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes receiving, by a cross-account, a grant to access a share object comprising a secure view and usage functionality associated with a secure user-defined function (UDF) to underlying data. The method includes accessing, by the cross-account, the share object using the grant. The method includes sending a request to a share component to cause the share component to implement the secure view and the usage functionality associated with the secure UDF. The method includes sending a query to the share component to cause the share component to implement the secure UDF.

公开(公告)号：US11170125B2

公开(公告)日：2021-11-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: 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 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.

公开(公告)号：US11768953B2

公开(公告)日：2023-09-26

申请号：US16937415

申请日：2020-07-23

Applicant: Snowflake Inc.

Inventor： Allison Waingold Lee ,  Peter Povinec ,  Martin Hentschel ,  Robert Muglia

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

CPC classification number: G06F21/6227 ,  G06F16/2282 ,  G06F16/245 ,  G06F21/6218

Abstract: Systems, methods, and devices for implementing secure views for zero-copy data sharing in a multi-tenant database system are disclosed. A method includes generating a share object in a first account comprising a share role. The method includes associating view privileges for the share object such that an underlying detail of the share object comprises a secure view definition. The method includes granting, to a second account, cross-account access rights to the share role or share object in the first account. The method includes receiving a request from the second account to access data or services of the first account and providing a response to the second account based on the data or services of the first account. The method is such that the underlying detail of the share object that comprises the secure view definition is hidden from the second account and visible to the first account.