Optimizing Performance of LookML Queries
About this Course
This is a Google Cloud Self-Paced Lab. In this lab, you\'ll learn the best methods to optimize query performance in Looker. Looker is a modern data platform in Google Cloud that you can use to analyze and visualize your data interactively. You can use Looker to do in-depth data analysis, integrate insights across different data sources, build actionable data-driven workflows, and create custom data applications. Big, complex queries can be costly, and running them repeatedly strains your database, thereby reducing performance. Ideally, you want to avoid re-running massive queries if nothing has changed, and instead, append new data to existing results to reduce repetitive requests. Although there are many ways to optimize performance of LookML queries, this lab focuses on the most commonly used methods to optimize query performance in Looker: persistent derived tables, aggregate awareness, and performantly joining views.Created by: Google Cloud
Related Online Courses
This introductory course is designed for beginners and individuals with limited programming experience who want to embark on their software development or data science journey using Python.... more
The learning experience will provide participants with an understanding of psychological safety and the skills needed to create safe, inclusive, and supportive environments in their lives. At the... more
This Specialization is designed to help anyone involved in developing software for Arm Cortex-M processors. Over four courses you will develop your knowledge of this popular microcontroller variant... more
This course is designed for novice learners wanting to understand the basics of ISO and IEC security standards. Learners will gain understanding how security standards address the challenges facing... more
Are you looking for a simple guide to learning unit testing? This video course is perfect for you. It includes hands-on exercises and best practices to help you understand JUnit and Mockito unit... more