Aggregate-Aware Query Execution

Learn how to route queries to the right Model automatically and get faster answers without the warehouse bill.

rate limit

Code not recognized.

About this course

This course teaches you how to set up aggregate-aware Model switching in ThoughtSpot so queries automatically route between a detailed Model and one or more smaller aggregate Models, cutting warehouse load and speeding up results across every consumption surface.

  • Understand what aggregate-aware Model switching is and why it matters for cost and performance
  • Identify the Models and TML configuration needed to enable query routing
  • Configure the aggregated_models block

Curriculum22 min

  • Welcome
  • Course Overview
  • Aggregate-Aware Query Execution
  • Aggregate-Aware Query Execution 7 min
  • Review
  • Review 10 min
  • Knowledge Check 5 min
  • Feedback

About this course

This course teaches you how to set up aggregate-aware Model switching in ThoughtSpot so queries automatically route between a detailed Model and one or more smaller aggregate Models, cutting warehouse load and speeding up results across every consumption surface.

  • Understand what aggregate-aware Model switching is and why it matters for cost and performance
  • Identify the Models and TML configuration needed to enable query routing
  • Configure the aggregated_models block

Curriculum22 min

  • Welcome
  • Course Overview
  • Aggregate-Aware Query Execution
  • Aggregate-Aware Query Execution 7 min
  • Review
  • Review 10 min
  • Knowledge Check 5 min
  • Feedback