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

公开(公告)号：US20240168950A1

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

申请号：US18329915

申请日：2023-06-06

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Kavinder S. Dhaliwal ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/2453 ,  G06F16/2455

CPC classification number: G06F16/24542 ,  G06F16/24564

Abstract: Techniques for reducing query compilation time are described. Dynamic compilation behavior based on query properties can reduce time and computational costs. For example, the techniques can identify stages and rewrite rules to skip or modify in the compilation process based on, among other things, properties of the parse tree and the query plan.

公开(公告)号：US20250094418A1

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

申请号：US18525811

申请日：2023-11-30

Applicant: Snowflake Inc.

Inventor： Srilakshmi Chintala ,  Jianzhun Du ,  Naresh Kumar ,  Jaeyun Noh ,  Srinath Shankar ,  Leonhard Franz Spiegelberg ,  Eric Shawn Vandenberg ,  Jiaqi Yan ,  Andong Zhan ,  Yun Zou

IPC: G06F16/2453

Abstract: Examples provide a method for performing dynamic pivot queries employing PANDA-compatible semantics inside a cloud data platform workload. A SQL engine receives a pivot query specifying a pivot column for dynamically determining pivot values in a dynamic pivot operation. The SQL engine identifies, in the pivot query, a keyword or a subquery indicating dynamic determination of the pivot values. Based on identifying the keyword or the subquery indicating the dynamic determination of the pivot values, the SQL engine determines distinct pivot values for the pivot column by evaluating the keyword or executing the subquery. The evaluating of the keyword includes issuing a query to a data store to obtain the distinct pivot values for the pivot column. The SQL engine performs the dynamic pivot operation using the distinct pivot values for the pivot column.

公开(公告)号：US11816239B2

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

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

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

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.

公开(公告)号：US20240256540A1

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

申请号：US18162486

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Yujie Li ,  Mohammad Saber Mirzaei ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/2453

CPC classification number: G06F16/24542 ,  G06F16/24532 ,  G06F16/2454

Abstract: Interleaved infrastructure can interleave fragment execution during query compilation. For example, compilation can be paused, and a plan fragment is executed. The results of the plan fragment can be fed back into the compiler, which can then restart the compilation and modify the compilation based on the results of the plan fragment execution. The interleaved workflow provides a flexible, robust infrastructure, which can enable and improve a variety of database features and query optimizations.

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

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

公开(公告)号：US12210525B2

公开(公告)日：2025-01-28

申请号：US18162486

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Benoit Dageville ,  Igor Demura ,  Brian Charles Forney ,  Weili Gu ,  Yujie Li ,  Mohammad Saber Mirzaei ,  Jaeyun Noh ,  Jiaqi Yan

IPC: G06F16/24 ,  G06F16/2453

Abstract: Interleaved infrastructure can interleave fragment execution during query compilation. For example, compilation can be paused, and a plan fragment is executed. The results of the plan fragment can be fed back into the compiler, which can then restart the compilation and modify the compilation based on the results of the plan fragment execution. The interleaved workflow provides a flexible, robust infrastructure, which can enable and improve a variety of database features and query optimizations.

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