Skip to main content

Changing the Schema for Aggregate Tables

AtScale creates its aggregate tables in your data warehouse in a schema that a system administrator creates before installing AtScale. It is possible to change the schema after AtScale is installed.

Prerequisites

The schema you specify must already exist in your data warehouse, and the AtScale service account user must be able to read and write to this location.

Procedure

To change the schema that AtScale uses to store system-defined aggregate tables for a data warehouse:

  1. In Design Center, open the Dabtasources panel.
  2. Click the context menu for the data warehouse you want to edit and select Edit. The Edit Data Warehouse panel opens.
  3. In the Aggregate schema field, enter the new schema.
  4. Click Update Data Warehouse.