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 main menu and select Settings. The Settings page opens.
  2. In the Settings panel, click Data Warehouses.
  3. In the list, hover over the data warehouse you want to edit and click the pencil icon. The Edit Datawarehouse panel opens.
  4. In the Aggregate schema field, enter the new schema.
  5. Click Apply.