Configuring Query Mapping
If you have multiple connections for the same type of data warehouse, you can configure which types of queries are permitted per connection. A query role can be assigned to only one connection at a time.
To configure query mapping for your data warehouses:
-
In Design Center, open the main menu and select Settings. The Settings page opens.
-
In the Settings panel, click Data Warehouses.
-
Click the expand icon next to a data warehouse in the list.
-
In the Query mapping section, select the connection you want to assign to each type of query:
- Large Interactive Queries: Use this engine for large user queries. These are usually BI queries involving full scans of the raw fact table or ones that involve high-cardinality dimensions.
- Small Interactive Queries: Use this engine for small user queries. These are usually BI queries that can be optimized by AtScale aggregates or ones that involve low-cardinality dimensions.
- System Queries: Use this engine for AtScale system processing, such as building aggregate tables or querying system statistics. The System query role user must not be subject to resource limitation rules that would prevent it from building aggregate tables.