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
With this project, you will be able to discover Later, a platform that will allow you to program content for your social networks. You will be able to add quite attractive content to your social... more
This is a survey of modern history from a global perspective. Part Two begins early in the twentieth century, as older ways of doing things and habits of thought give way. What follows is an era of... more
This specialization covers essential skills in Python programming, data preparation, and foundational machine learning techniques such as linear regression and classification, providing a... more
Embark on a transformative journey through the digital landscape with our comprehensive course on Digital Transformation and Persuasive Technologies. Explore the intricate dynamics of social media... more
This is a self-paced lab that takes place in the Google Cloud console. This lab will teach you how to use the Pipeline Studio in Cloud Data Fusion to build an ETL pipeline. Pipeline Studio exposes... more