New BigQuery DETECT_ANOMALIES Function

Liam Cole
1 min readAug 14, 2021

Really impressed with the function! Saves time

Problem: When abnormal things happen to the data, I want to know

We are wanting to identify anomalies when new data arriving into tables (usually on a schedule) does not look normal based on previous historical patterns.

A new function (ML.ANOMALY_DETECTION ) has just been released recently and I will be using it with an ARIMA model to identify anomalies. This new function requires less code to identify anomalies, thanks to…

--

--

Liam Cole

Hopefully one my articles helps someone! Complexity is the enemy to execution. Born and bred kiwi