Snowflake Inc.

Shiyu Qu

Jiaqi Yan

Vlad Bunescu

Jaeha Lee

Yan Huang

Zerui Wei

Joshua Klahr

Louis Magarshack

Methods, systems, and computer programs are presented for providing performance metrics in an online performance analysis system employing customer production workloads. A plurality of metric source data is received from a cloud data platform. A workload is identified as a stable workload candidate based at least in part on the plurality of metric source data. The cloud data platform generates a performance index based on the workload being identified as a stable workload candidate. The performance index is tracked over a period of time to identify changes in workload.

Performance indexing of production databases

A method includes decoding, by at least one hardware processor, a notification of a changed database code of a database. A query is executed responsive to the notification. The query indicates a data processing command and a data object in the database. A regression in the changed database code is detected based on multiple regression testing operations applied to the data processing command and the data object. Analysis of the regression is performed to detect a rollout parameter of a plurality of rollout parameters as a root cause of the regression. The plurality of rollout parameters are associated with the changed database code. A determination is made on whether to perform a mitigation action for the regression based on the rollout parameter.

Infrastructure for automating rollout of database changes

Provided herein are systems and methods for automating the rollout of database changes. For example, a method includes detecting a change in database code of a database resulting in a changed database code. The change in the database code includes a parameter rollout for at least one parameter setting of the database. Execution of a query associated with the change in the database code is monitored. The query uses the at least one parameter setting. A regression in the changed database code is detected based on the monitoring. Impact analysis is performed to determine a scope of impact of the regression on at least another query using the at least one parameter setting. A determination is made on whether to perform a rollback of the change in the database code or perform mitigation based on the scope of impact.

Growing community of inventors

Bellevue, WA, United States of America

Shiyu Qu