Skip to main content

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:

  1. In Design Center, open the main menu and select Settings. The Settings page opens.

  2. In the Settings panel, click Data Warehouses.

  3. Click the expand icon next to a data warehouse in the list.

  4. 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.