Pre-Aggregations

The Pre-Aggregations page in Cube Cloud allows you to inspect all pre-aggregations in your deployment at a glance. You can see which pre-aggregations are accelerating queries, if they are being refreshed, along with the last 24 hours of build history.

Exploring pre-aggregations

You can switch between pre-aggregations and build history by switching between the  ​Pre-Aggregations and Build History tabs.

Pre-aggregations

The Pre-Aggregations tab shows a list of all configured pre-aggregations for the deployment, and is useful for quickly checking details such as when the last build occurred, how long the build took to complete, the total size of the pre-aggregated data, and how many partitions the data is split across. To see more information about a specific pre-aggregation, click on it.

Partitions

The Partitions tab shows all partitions (as specified by partitionGranularity) of the pre-aggregation. In the example below, the pre-aggregation has a single partition:

Pre-aggregations with multiple partitions show a list of all partitions, which is helpful for checking pre-aggregation partition build times and sizes:

Ideally partitions should be of a similar size and build time. If a partition is taking significantly longer to build than others, it may be worth investigating why.

If the pre-aggregation requires rebuilding (usually due to the underlying data changing in a significant way), clicking Build All rebuilds all partitions of the pre-aggregation:

You can also choose to rebuild specific partitions by selecting them and then clicking the Build Selected button:

Definition

The Definition tab shows how the pre-aggregation is defined in the data model without having to switch to the Data Model page:

Preview

To see a sample of the data contained in the pre-aggregation, click the  ​Preview tab:

This can be used to verify that the data within the pre-aggregation is being built correctly.

Used By

The Used By tab shows recent queries that used this pre-aggregation for acceleration:

This is especially useful for checking that the pre-aggregation is being used as expected by queries sent to the deployment.

Indexes

Indexes significantly improve the performance of configured pre-aggregations. The Indexes tab displays any configured indexes for this pre-aggregation:

Build History

The Build History tab shows the last 24 hours of build history for all pre-aggregations in the deployment. From here, you can see if a pre-aggregation build succeeded (or failed), how the build was triggered, when the build started, and how long it took to complete.

To see more information about a specific build, click on it: