Optimizing Performance of LookML Queries

Offered By: Google via Google Cloud Skills Boost

Course Description

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

In this lab, you'll learn the best methods to optimize query performance in Looker.

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!