Custom SQL Enhancements (Feb 2024)

We’re improving our Custom SQL monitors to reduce volatility and better align with other monitor types.

As a result of these changes, the expected ranges of your Custom SQL monitors may shrink or expand.

Anomaly State

When an anomaly is detected, Custom SQL monitors now freeze the expected bounds until the observed value comes back into that range. This change brings the Custom SQL in line with how all other monitor types in Metaplane handle anomalies.

Previously, the expected bounds for Custom SQL monitors would change after an anomaly was detected. This sometimes led monitors to leave anomaly states too soon or to not leave when they should.

Mark Normal Handling

When using “Mark Normal” after an anomaly is detected, Custom SQL monitors now adjust the model to keep the expected ranges about the same size as they were before the anomaly. Previously, the expected ranges could expand significantly after an anomaly.

Seasonality Detection

Custom SQL monitors now use the same seasonality detection method as other monitor types. Previously, it used a different seasonality detection method that led to misalignment across monitors.