公开(公告)号：US12222954B2

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

申请号：US18513140

申请日：2023-11-17

Applicant: Snowflake Inc.

Inventor： Kavinder S. Dhaliwal ,  Bicheng Gao ,  Valeri Kim ,  Nithin Mahesh ,  Jiaqi Yan ,  Jiaqi Zhang

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/245

Abstract: The subject technology provides techniques for enabling hidden database objects, which in an example are utilized for testing and verifying new database objects against existing workloads. Hidden database objects are a mechanism for bridging that gap by running user workloads on user data in advance of exposing the feature to users. This mechanism allows placing a database object as a hidden object nested beneath a user's visible object (e.g., table, column, view, and the like). Hidden database objects can be used to verify the functionality, parity, performance, and correctness of new unreleased features.

公开(公告)号：US20240427794A1

公开(公告)日：2024-12-26

申请号：US18513140

申请日：2023-11-17

Applicant: Snowflake Inc.

Inventor： Kavinder S. Dhaliwal ,  Bicheng Gao ,  Valeri Kim ,  Nithin Mahesh ,  Jiaqi Yan ,  Jiaqi Zhang

IPC: G06F16/25 ,  G06F16/22 ,  G06F16/245

Abstract: The subject technology provides techniques for enabling hidden database objects, which in an example are utilized for testing and verifying new database objects against existing workloads. Hidden database objects are a mechanism for bridging that gap by running user workloads on user data in advance of exposing the feature to users. This mechanism allows placing a database object as a hidden object nested beneath a user's visible object (e.g., table, column, view, and the like). Hidden database objects can be used to verify the functionality, parity, performance, and correctness of new unreleased features.

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