Performing Full Rebuilds of Incremental Aggregates

Incremental aggregates process only new windows of fact data rows, rather than processing all of the data. In some cases, you may want to reprocess all of the data to ensure that aggregates are accurate. For example, if the data of a dimension dataset has changed significantly or if you have older data that missed a processing window.

Procedure

To trigger a full rebuild of all of the aggregates for a model:

1. In Design Center, open the Deployed Catalogs panel, then open the catalog that contains the model you want to run a build for.
2. Click the Build tab.
3. Click the Start Full Batch for the model to trigger a full rebuild (including incremental aggregates) of its aggregates.

You can also deactivate aggregates so that AtScale performs a full rebuild of them the next time it builds aggregates for the corresponding model. Incremental builds will continue after that. For more information, see Deactivating An Active Aggregate Instance.

note

After you deactivate the instance, the AtScale engine may decide that it will not rebuild the instance. Instead, it might create a new aggregate definition based on the current aggregate definition, or ir might create an entirely new aggregate definition that better serves the query workload against the model.