In this lab, you'll learn the best methods to optimize query performance in Looker.
Overview
Syllabus
- GSP985
- Overview
- Setup
- Key recommendations for optimizing query performance
- Task 1. Create an incremental persistent derived table that will auto-update without rebuilding the entire table
- Task 2. Create an incremental aggregate table to summarize order data across multiple time periods
- Task 3. Join views in a performant manner to optimize Explore queries
- Task 4. Monitor the builds of persistent derived tables in a Looker instance
- Congratulations!
