公开(公告)号：US20250110718A1

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

申请号：US18479589

申请日：2023-10-02

Applicant: Snowflake Inc.

Inventor： Jin Mo Ahn ,  Vlad Bunescu ,  Lin Chan ,  Ryan Druckman ,  Adrian Hamza ,  Alexander Hess ,  Gabriel Kliot ,  Albert Nathan McNamara ,  Subramanian Muralidhar ,  Jiaqi Yan

IPC: G06F8/60 ,  G06F11/34

Abstract: A system and method of isolated testing platform for cloud database production queries. The method includes providing an execution platform including a production deployment to receive a first group of queries from a first group of user devices. The production deployment includes a local data storage to store a first dataset associated with the first group of user devices and an execution node to process the first group of queries based on a first version of an application and based on the user data. The method includes receiving a request to test a second version of the application based on the first version of the application. The method includes deploying a ghost deployment onto the execution platform. The method includes replaying the first group of queries on the ghost deployment using copies of the first version of the application and the second version of the application.

公开(公告)号：US12135697B2

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

申请号：US18326929

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  Lishi Jiang ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22

Abstract: The subject technology generates, by a compute service manager, a schema hash value for a new schema version associated with a new schema version value, the schema hash value based on determining a sum of hash values of a set of attributes of value columns, the set of attributes comprises a column identifier, and a logical type of a column. The subject technology stores a mapping of the schema hash value to the new schema version value for a table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and a new column for the table in the metadata database, the metadata database storing multiple entries for different schema versions, each entry including a particular schema hash value for mapping to a corresponding schema version from the different schema versions.

公开(公告)号：US20240028567A1

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

申请号：US18326929

申请日：2023-05-31

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  Lishi Jiang ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu

IPC: G06F16/21 ,  G06F16/22

CPC classification number: G06F16/213 ,  G06F16/221

Abstract: The subject technology generates, by a compute service manager, a schema hash value for a new schema version associated with a new schema version value, the schema hash value based on determining a sum of hash values of a set of attributes of value columns, the set of attributes comprises a column identifier, and a logical type of a column. The subject technology stores a mapping of the schema hash value to the new schema version value for a table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and a new column for the table in the metadata database, the metadata database storing multiple entries for different schema versions, each entry including a particular schema hash value for mapping to a corresponding schema version from the different schema versions.

公开(公告)号：US11709808B1

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

申请号：US17656558

申请日：2022-03-25

Applicant: Snowflake Inc.

Inventor： Benoit Dageville ,  Adrian Hamza ,  William Waddington ,  Khaled Yagoub ,  Wumengjian Zhu ,  Lishi Jiang

IPC: G06F16/21 ,  G06F16/22

CPC classification number: G06F16/213 ,  G06F16/221

Abstract: The subject technology receives a statement to perform an operation to add a new column into a table. The subject technology generates a schema hash value for a new schema version associated with a new schema version value. The subject technology stores a mapping of the schema hash value to the new schema version value for the table in a metadata database. The subject technology stores a new schema entry based on the schema hash value, the new schema version value, and the new column for the table in the metadata database. The subject technology performs an operation to add the new column to the table.