Changing the Schema for Aggregate Tables

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

Before you begin

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

About this task

This information is stored in the schema details for each AtScale data warehouse. If you want to change where aggregates are created, you can edit the data warehouse and enter a different schema.

Procedure

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

Select Settings from the main navigation. Choose Data Warehouses and then select the data warehouse that you want to configure.
Click Edit