公开(公告)号：US11507685B1

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

申请号：US17586646

申请日：2022-01-27

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: H04L29/06 ,  G06F21/62 ,  H04L9/40 ,  G06F16/245 ,  H04L9/32 ,  G06F16/248

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US12235985B2

公开(公告)日：2025-02-25

申请号：US18359360

申请日：2023-07-26

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: G06F21/00 ,  G06F16/245 ,  G06F16/248 ,  G06F21/62 ,  H04L9/32 ,  H04L9/40

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US12007997B2

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

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/00 ,  G06F7/14 ,  G06F16/22 ,  G06F16/23 ,  G06F16/2453 ,  G06F21/62

CPC classification number: G06F16/24549 ,  G06F7/14 ,  G06F16/2228 ,  G06F16/2379 ,  G06F21/6218 ,  G06F21/6227

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

公开(公告)号：US20230214391A1

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

申请号：US18183483

申请日：2023-03-14

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/23 ,  G06F16/22 ,  G06F7/14 ,  G06F21/62

CPC classification number: G06F16/2379 ,  G06F16/2228 ,  G06F7/14 ,  G06F21/6218

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

公开(公告)号：US20230115726A1

公开(公告)日：2023-04-13

申请号：US18048560

申请日：2022-10-21

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: G06F21/62 ,  H04L9/40 ,  G06F16/245 ,  H04L9/32 ,  G06F16/248

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US11270020B1

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

申请号：US17487716

申请日：2021-09-28

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: H04L29/06 ,  G06F21/62 ,  G06F16/248 ,  H04L9/32 ,  G06F16/245

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US20240289333A1

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

申请号：US18656126

申请日：2024-05-06

Applicant: Snowflake Inc.

Inventor： Lin Chan ,  Tianyi Chen ,  Benoit Dageville ,  Yiming Kang ,  Jun Luo ,  Nithin Mahesh ,  Eric Robinson ,  Brian Smith

IPC: G06F16/2453 ,  G06F7/14 ,  G06F16/22 ,  G06F16/23 ,  G06F21/62

CPC classification number: G06F16/24549 ,  G06F7/14 ,  G06F16/2228 ,  G06F16/2379 ,  G06F21/6218 ,  G06F21/6227

Abstract: As described herein, a N-Gram index may be created and the search may be conducted using the index, which will lead to faster search results. The N-Gram index may also include partial N-Gram components to capture more relevant data. Moreover, as described herein, the search may also take into account recent log data that has not yet been indexed. Techniques for building an index store using log data and efficiently searching the index store and log data to process search requests are described herein.

公开(公告)号：US12010147B2

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

申请号：US18053956

申请日：2022-11-09

Applicant: Snowflake Inc.

Inventor： Jeremy Yujui Chen ,  Unmesh Jagtap ,  William A. Pugh ,  Brian Smith ,  Xu Xu

IPC: H04L9/40

CPC classification number: H04L63/20

Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.

公开(公告)号：US20230367896A1

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

申请号：US18359360

申请日：2023-07-26

Applicant: Snowflake Inc.

Inventor： Damien Carru ,  Thierry Cruanes ,  Subramanian Muralidhar ,  Nicola Dan Onose ,  Ryan Michael Thomas Shelly ,  Brian Smith ,  Jaeyun Noh

IPC: G06F21/62 ,  G06F16/248 ,  H04L9/32 ,  H04L9/40 ,  G06F16/245

CPC classification number: G06F21/6227 ,  G06F16/248 ,  H04L9/3213 ,  H04L63/102 ,  H04L63/105 ,  G06F16/245

Abstract: Techniques described herein can allow users to share cached results of an original query with other users while protecting sensitive information. The techniques described herein can check whether the other users have access to the underlying data queried before allowing those users to see the stored query results. That is, the system may perform privilege checks on the shared users before giving them access to the stored query results but without having to re-run the original query.

公开(公告)号：US20240163316A1

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

申请号：US18423012

申请日：2024-01-25

Applicant: Snowflake Inc.

Inventor： Jeremy Yujui Chen ,  Unmesh Jagtap ,  William A. Pugh ,  Brian Smith ,  Xu Xu

IPC: H04L9/40

CPC classification number: H04L63/20

Abstract: A data platform for developing and deploying a user application within a unified security context. The data platform authorizes a first user to use an editor to access source code of a user application based on security policies of a security context and authorizes the first user to use an application and data manager to set usage privileges for a second user to use the user application based on the security policies of the security context. To provide the user application to the second user, the data platform deploys the user application by instantiating a User Defined Function (UDF) server and an application engine of the UDF server within the security context, instantiating the user application as an application of the application engine within the security context, and authorizing access by the user application to databased on the security policies of the security context.