US 12,066,917 B2
Auto insights into data changes
Christian Kleinerman, Burlingame, CA (US); Christopher F. Pouliot, Portola Valley, CA (US); and Jacobus J. P. Van Ryswyck, Danville, CA (US)
Assigned to Snowflake Inc., Bozeman, MT (US)
Filed by Snowflake Inc., Bozeman, MT (US)
Filed on May 16, 2023, as Appl. No. 18/318,113.
Application 18/318,113 is a continuation of application No. 17/656,581, filed on Mar. 25, 2022, granted, now 11,687,436.
Application 17/656,581 is a continuation of application No. 17/408,284, filed on Aug. 20, 2021, granted, now 11,321,212.
Prior Publication US 2023/0281101 A1, Sep. 7, 2023
Int. Cl. G06F 11/34 (2006.01); G06F 11/30 (2006.01)
CPC G06F 11/3419 (2013.01) [G06F 11/3006 (2013.01); G06F 11/3075 (2013.01); G06F 11/3466 (2013.01)] 18 Claims
OG exemplary drawing
 
1. A method comprising:
generating an input query to identify root causes in a data shift in a performance metric associated with a network-based data system, the input query including a plurality of dimensions, treatment and cohort controls, and a key performance indicator (KPI), the treatment and cohort controls including at least one time interval including the data shift;
executing the input query to generate an initial set of results;
pruning the initial set of results to generate pruned results including a plurality of data segments; and
generating an output table based on the pruned results, the output table including a plurality rows corresponding to the plurality of data segments and a plurality of columns including dimensional vales associated with the plurality of dimensions and KPI values in the treatment and cohort controls.