公开(公告)号：US20230409430A1

公开(公告)日：2023-12-21

申请号：US18104249

申请日：2023-01-31

Applicant: Snowflake Inc.

Inventor： Selcuk Aya ,  Leonid Baraznenok ,  Jaeha Lee ,  Adrian Peter Neumann ,  Ryan Michael Thomas Shelly ,  Zerui Wei ,  Jiaqi Yan

IPC: G06F11/14 ,  G06F11/07 ,  G06F16/215

CPC classification number: G06F11/1435 ,  G06F16/215 ,  G06F11/079

Abstract: Embodiments of the present disclosure may provide a data protection system that performs identification of errors from queries on a database. The data protection system can further identify corrupted data from additional errors, are difficult to detect, and occur between layers of data in the database system. The data protection system can perform corrections of the error data by rebuilding database data or removing the corrupted data.

公开(公告)号：US11822582B2

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

申请号：US17896446

申请日：2022-08-26

Applicant: SNOWFLAKE INC.

Inventor： Yi Fang ,  Varun Ganesh ,  Xinglian Liu ,  Ryan Michael Thomas Shelly ,  Jiaqi Yan ,  Yizhi Zhu

IPC: G06F16/28

CPC classification number: G06F16/285

Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for improving query processing of a database. An example method can include: storing table data for a table in a plurality of micro-partitions, each micro-partition comprising a portion of the table data for the table; for each micro-partition of the plurality of micro-partitions, storing metadata for the micro-partition in at least one of a plurality of expression properties; and selecting, by a processing device, a subset of the plurality of expression properties to be grouped into a grouping expression property based at least partially on the metadata of the subset of the plurality of the expression properties. The grouping expression property may include cumulative metadata associated with the metadata of the subset of the plurality of expression properties.

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

公开(公告)号：US20240354315A1

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

申请号：US18302234

申请日：2023-04-18

Applicant: SNOWFLAKE INC.

Inventor： Varun Ganesh ,  Alvin E. Jou ,  Donghe Kang ,  Ryan Michael Thomas Shelly ,  Jiaqi Yan ,  Yizhi Zhu

IPC: G06F16/28 ,  G06F16/2455

CPC classification number: G06F16/285 ,  G06F16/24556

Abstract: A method for selecting micro-partitions for a clustering operation includes: storing table data in a plurality of micro-partitions of a storage device, wherein each of the plurality of micro-partitions comprises a portion of the table data, wherein subsets of the plurality of micro-partitions are associated with a respective one of a plurality of expression property (EP) files, and wherein each of the plurality of EP files comprises an EP data region that represents the portions of the table data of the subset of the plurality of micro-partitions associated with the EP file; determining sub-ranges of the table data based on the EP data regions of the plurality of EP files; selecting a subset of the plurality of EP files for a clustering operation based on the sub-ranges of the table data; and performing the clustering operation on the micro-partitions associated with the subset of the EP files.

公开(公告)号：US11537613B1

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

申请号：US17514084

申请日：2021-10-29

Applicant: Snowflake Inc.

Inventor： Thierry Cruanes ,  Varun Ganesh ,  Ryan Michael Thomas Shelly ,  Jiaqi Yan

IPC: G06F16/24 ,  G06F16/2453 ,  G06F16/17 ,  G06F16/22 ,  G06F7/14

Abstract: The subject technology receives a query plan corresponding to a query. The subject technology executes the query based at least in part on the query plan, the executing including: filtering a first set of files that are to be modified by a merge statement, performing a split operation to send information related to a second set of files to a scan set builder operation in a first portion of the query plan and scan back operation in a second portion of the query plan, performing the scan set builder operation to remove the second set of files from the first set of files, performing a table scan operation based on a third set of files, and performing a first union all operation to combine the first set of data with a second set of data as a first set of combined data.

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

公开(公告)号：US20230229676A1

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

申请号：US17896446

申请日：2022-08-26

Applicant: SNOWFLAKE INC.

Inventor： Yi Fang ,  Varun Ganesh ,  Xinglian Liu ,  Ryan Michael Thomas Shelly ,  Jiaqi Yan ,  Yizhi Zhu

IPC: G06F16/28

CPC classification number: G06F16/285

Abstract: Embodiments of the present disclosure describe systems, methods, and computer program products for improving query processing of a database. An example method can include: storing table data for a table in a plurality of micro-partitions, each micro-partition comprising a portion of the table data for the table; for each micro-partition of the plurality of micro-partitions, storing metadata for the micro-partition in at least one of a plurality of expression properties; and selecting, by a processing device, a subset of the plurality of expression properties to be grouped into a grouping expression property based at least partially on the metadata of the subset of the plurality of the expression properties. The grouping expression property may include cumulative metadata associated with the metadata of the subset of the plurality of expression properties.

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