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