Course

Optimizing Performance of LookML Queries

Google Cloud

In this Google Cloud Self-Paced Lab, you'll dive into the best methods to optimize query performance in Looker. Discover how to add persistence and incremental updates to derived tables, utilize aggregate awareness to optimize rolled up or summarized data queries, and refine existing explores for enhanced performance.

Throughout the course, you'll understand the impact of running big, complex queries repeatedly, and learn to avoid unnecessary strain on your database by appending new data to existing results. By the end, you'll be equipped with the knowledge and techniques to significantly enhance the performance of LookML queries.

  • Learn when and how to add persistence and incremental updates to derived tables
  • Utilize aggregate awareness to optimize queries on rolled up or summarized data
  • Create a refinement of an existing Explore

Certificate Available ✔

Get Started / More Info
Optimizing Performance of LookML Queries
More Data Analysis Courses

Geographic Information Systems (GIS)

University of California, Davis

Geographic Information Systems (GIS) Specialization equips you with essential skills to analyze spatial data, develop maps, and collaborate with peers in GIS fields....

Big Data Integration and Processing

University of California San Diego

Big Data Integration and Processing is a comprehensive course that equips learners with the skills to retrieve and process big data from various sources using tools...

Exploratory Data Analysis

Johns Hopkins University

Exploratory Data Analysis equips learners with essential techniques for summarizing data before formal modeling.

Working with SQL Stored Procedures using MySQL Workbench

Coursera Project Network

Learn to create and utilize efficient SQL stored procedures in MySQL Workbench. Enhance your skills with input and output parameters, and practice as you progress...