Rollup Designer

Rollup Designer provides an easy way to create and edit pre-aggregations.

Identifying slow queries

You can identify queries that might be accelerated with pre-aggregations in Playground and Query History.

You can also access Rollup Designer from Data Model.

Playground

When you execute a query in Playground that has no matching pre-aggregations, you would see this notificaton. Clicking on it will open Rollup Designer with a suggested pre-aggregation:

Query History

When you browse a query in Query History that has no matching pre-aggregations, you would see this notificaton. Clicking on Accelerate will open Rollup Designer with a suggested pre-aggregation:

Creating pre-aggregations

When you open Rollup Designer from Playground or Query History, it will suggest a pre-aggregation accelerating the query in question:

If desired, you can also modify settings such as the refresh key, the partition granularity, and indexes to further optimize the pre-aggregation by clicking the ​Settings tab:

Click Add to the Data Model to add the pre-aggregation to the data model.