📄️ Aggregates Overview
AtScale incorporates the data-warehousing concept of aggregate tables.
📄️ Types of Aggregate Tables in AtScale
There are two types of aggregate table that the AtScale engine can use:
📄️ How Aggregate Tables Are Populated With Data
After an aggregate table is defined, an instance of it needs to be
📄️ Life Cycle of Aggregate Tables
The following diagram summarizes the stages in the life cycle of an
📄️ Flowchart of the Actions Taken for Each Query
Each query that requests aggregated data causes the AtScale engine to
📄️ Aggregate Definitions and Aggregate Instances
AtScale separates the concept aggregate table into two separate
📄️ When the AtScale Engine Creates Demand-Defined Aggregates
Demand-defined aggregates are a type of system-defined aggregate that
📄️ When to Define Your Own Aggregate Tables
AtScale recommends that you rely on the AtScale engine to generate
📄️ About Hinted Aggregate Tables
Hinted aggregates are a type of user-defined aggregate table; you
📄️ Partitioned System-Defined Aggregate Tables
AtScale Model Architects provide prioritized partitioning hints to the
📄️ Partitioned User-Defined Aggregates
When you create or edit a user-defined aggregate (UDA), you can specify
📄️ About Incremental Rebuilds
This type of rebuild of instances of aggregate tables appends new rows
📄️ Aggregates for Fact Datasets that Use Joins
If a fact dataset uses inner joins to join to one more dimensions, the
📄️ Deactivating an Active Aggregate Instance
Active aggregate instances can be manually deactivated from the Aggregates page, as well as the Aggregates panel of the Queries page. Hover over an aggregate in the table and click the Deactivate button, shown below.