Working With Aggregate Partitions
You can add system-defined aggregate partitions for models by modifying their underlying SML.
To create aggregate partitions for a model, edit the model file's
underlying SML to include the partitions
property. For more
information, see
the AtScale SML Object Documentation on GitHub.
Be sure to deploy the model afterwards.
Once a query containing the dimension levels that you specified as a partition has been executed on the deployed model, the AtScale engine determines whether to build a new system aggregate with the partition, based on the following:
- If the estimated number of rows per partition meets or exceeds the
threshold set in the engine setting
AGGREGATES.CREATE.PARTITION.SYSTEMDEFINEDAGGREGATE.THRESHOLD
. - If the estimated number of partitions in the aggregate table exceeds
the threshold set in
tables.create.partitions.maximumEstimatedNumberOfPartitions
, the table is not partitioned. The default value is 800.