GCP Optimizing Performance of LookML Queries GSP985
00:00 start
00:31 Key recommendations for optimizing query performance
01:17 Task 1. Create an incremental persistent derived table that will auto-update without rebuilding the entire table
15:33 Task 2. Create an incremental aggregate table to summarize order data across multiple time periods
18:52 Task 3. Join views in a performant manner to optimize Explore queries
26:39 Task 4. Monitor the builds of persistent derived tables in a Looker instance
https://www.cloudskillsboost.google/c...