Create Persisted Aggregations

Create persisted aggregations to store pre-computed aggregation results that run on a schedule. You can create persisted aggregations from the overview page or save a query directly from the Search page.

Persisted aggregations run aggregation queries on a schedule and store the results for faster querying. The query must contain at least one aggregation function. For more information about persisted aggregations syntax, see Persisted Aggregations.

Create a persisted aggregation from the overview page

  1. Go to the Repository and Views page.

  2. Select a Repository or View.

  3. Go to Automation and select Persisted aggregations on the side tree: the Persisted aggregations overview page shows the list of the available persisted aggregations:

    Screenshot of the Persisted aggregations overview page displaying a table with columns for persisted aggregation names, schedules, status indicators, and management options

    FigureĀ 301.Ā Persisted aggregations overview


  4. Click New persisted aggregation. You are redirected to the Query Editor, where you can type your aggregation query:

    Screenshot showing a new persisted aggregation row in the table with editable fields for name, query, and schedule configuration

    FigureĀ 302.Ā Create persisted aggregation from table


    Refer to Persisted Aggregations for the syntax requirements and the supported functions for creating persisted aggregations queries.

  5. Configure the persisted aggregation settings in the panel (see FigureĀ 300, ā€œPersisted aggregation configuration panelā€).

  6. Click Save to create the persisted aggregation. The aggregation begins running on its defined schedule.

See Configure Persisted Aggregation Properties for details on the available configuration settings.