🗃️ About Aggregates
14 items
📄️ Monitoring Aggregate Usage
The Aggregates page displays all aggregate instances that have been
📄️ Defining Aggregates Yourself
You can define your own aggregates for use cases that fall outside of those covered by system-defined aggregates.
📄️ Changing the Schema for Aggregate Tables
AtScale creates its aggregate tables in your data warehouse in a schema
📄️ Dimensionally modified aggregates
Some of the queries processed by AtScale request calculated measures as
📄️ Disabling the Creation of System-Defined Aggregates for a Dataset
For some fact datasets, you might want to disable the creation of
📄️ Priming the System with Demand-Defined Aggregates
The AtScale engine can generate demand-defined aggregates before analysts start querying your data, which may improve the performance of the initial queries they issue. Priming is done by enabling Training Mode on the Settings page, then running queries representative of the queries that analysts will issue.
📄️ Excluding Specific Attributes from Aggregates
You can exclude specific attributes from being used as grouping keys in
📄️ Exporting and Importing System-Defined Aggregate Definitions
AtScale supports migrating system-defined aggregate definitions for
📄️ Handling NULL Values to Prevent Incomplete Aggregate Tables and Unexpected Query Results
When NULL key values are present in the relationship key column of
📄️ Working With Aggregate Partitions
You can add system-defined aggregate partitions for models by modifying
📄️ Dimensionally modified aggregates
Some of the queries processed by AtScale request calculated measures as
📄️ Setting Properties to Allow Incremental Rebuilds of Aggregates
You can enable incremental rebuilds of aggregates for your models.
📄️ Rebuilding Aggregates Manually
You can manually perform an initial build or a rebuild all aggregates
📄️ Rebuilding Aggregates Using the REST API
You can use the aggregates-batch endpoint of the AtScale engine REST API to trigger full or incremental builds for all aggregates of a deployed model. When running an incremental build, you can optionally specify grace period overrides for specific datasets in the model.
📄️ Scheduling Aggregate Builds
You can configure aggregates to be built according to a schedule using the aggregates-creation/scheduler endpoint of the AtScale API. This enables you to schedule builds to run at convenient times, rather than immediately after catalog deployment, to save on resources and costs.
📄️ Performing Full Rebuilds of Incremental Aggregates
Incremental aggregates process only new windows of fact data rows,
📄️ Aggregate Maintenance
AtScale features a built-in job for maintaining aggregates. The aggregate maintenance job performs tasks like health checks on all active aggregate instances and cleanup of orphaned or unreliable aggregates. This job runs periodically to improve the performance of AtScale.
📄️ Aggregate Data Security
You can configure AtScale so that queries can simultaneously access data
📄️ Inbound SQL Session Parameters
AtScale supports four SQL session parameters that you can use in an SQL
📄️ Inbound SQL Hints to Control the Use and Generation of Aggregate Tables
There are two SQL hints that you can insert into SQL statements to