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.
- Aggregate Build Queries: Use this engine for aggregate build queries. This should be assigned to a connection that has more compute power. The Aggregates Build Queries connection mapping must not be subject to resource limitations that would prevent it from building aggregate tables.
- System Queries: Use this engine for AtScale system processing, such as running aggregate maintenance jobs and querying system statistics.