Auto-mode and Partitioned Tables

If you are using ML-based monitors on partitioned tables, enabling the "auto" setting for the time field will use by default the partition key when it is a timestamp/date field.

In this case, during the first run, the time partition key will be used to train the model based on the historics (default value is set to 365 days). In the following runs, the time partition key will be used as well in the lookback period (default value is 1 day) to take into account the most recent data point in an incrementat and hence optimised manner.


In auto mode, users don't need to opt-in for the usage of the partition key anymore to optimize the query.


This feature currently applies to two types of partitions for BigQuery: INGESTION TIME and TIME_UNIT_COLUMN